Search:

Type: Posts; User: munsworth

Search: Search took 0.03 seconds.

  1. Thread: Newbie

    by munsworth
    Replies
    10
    Views
    993

    The first book I ever read was in the Learn to...

    The first book I ever read was in the Learn to Program series
    by John Smiley. It's a great book for people with little previous
    exposure to programming.



    The order of the events really...
  2. Replies
    1
    Views
    561

    Change: ...

    Change:

    rpt.DataDefinition.RecordSelectionFormula = "Select * employee where empposition='"& "Programmer" & "'"'

    to

    rpt.DataDefinition.RecordSelectionFormula = "{employee.empposition} =...
  3. In the .NET Configuration in administrative tools...

    In the .NET Configuration in administrative tools I added the
    executable to the list of trusted assemblies. It also lets you
    specify the permission level you want to grant it. For example,
    you...
  4. I figured it out, thanks.

    I figured it out, thanks.
  5. Running an Executable over a network *Resolved*

    I've got an executable that runs fine if it is located on my local
    machine, but if I put it on a network drive and execute it I get
    a security exception. Is there something I can do to solve this...
  6. Dim var1 as String Dim var2 as String Dim var3...

    Dim var1 as String
    Dim var2 as String
    Dim var3 as String
    Dim objItem as ListItem

    Open File for Input as #1

    Do While Not EOF(1)
    Input #1 var1, var2, var3
    Set objItem = Your...
  7. Replies
    4
    Views
    670

    You don't need a dataset to do any of that, but...

    You don't need a dataset to do any of that, but depending on what you are doing you may need one to store the data you retrieve from your DB.

    As far as finding data, if you want a quick forward...
  8. Replies
    0
    Views
    318

    Script to Generate Hyperlinks

    How would i go about wrinting a script that would generate an
    HTML page with links to all of the mp3s on a given site.

    Example:
    On page one I want to specify a url http://www.--------.com
    I...
  9. Replies
    4
    Views
    471

    Agreed :)

    Agreed :)
  10. Replies
    2
    Views
    703

    Private Sub Command1_Click(Index As Integer) ...

    Private Sub Command1_Click(Index As Integer)

    Select Case Index
    Case 0
    'button command1(0) was clicked
    Case 1
    'button command1(1) was clicked
    ...
  11. Replies
    4
    Views
    646

    If the problem is that the file isn't being saved...

    If the problem is that the file isn't being saved with the comas
    and apostrophes, just change:



    Write #FileNumber, ProductArray(iCounter, 0), ProductArray(iCounter, 1), ProductArray(iCounter,...
  12. In the click event for one button, set the...

    In the click event for one button, set the caption for another.


    Private sub command1_click()
    command2.caption = "Change Text Here"
    end sub
  13. Replies
    4
    Views
    435

    WHat do you want to do? Do you want to display...

    WHat do you want to do?
    Do you want to display it from within your app?
  14. Replies
    10
    Views
    987

    Amen! :) It would also help make your code...

    Amen! :)

    It would also help make your code more readable if you created some functions or sub procedures to break up all that code in the one click event.

    ex.


    Private Sub...
  15. Replies
    15
    Views
    718

    What are you trying to do? :confused:

    What are you trying to do? :confused:
  16. Replies
    10
    Views
    987

    That code needs help. :eek:

    That code needs help. :eek:
  17. Replies
    3
    Views
    1,093

    You shou have code similar to this somewhere in...

    You shou have code similar to this somewhere in order to access the fields on the report.



    Dim crxApp As New CRAXDRT.Application
    Dim crxRpt As CRAXDRT.Report

    Set crxRpt =...
  18. Replies
    3
    Views
    1,093

    I don't see where you even open the report. What...

    I don't see where you even open the report. What you posted is the equivalent of declaring a recordset object and wondering why you cant populate it with data from a database you're not connected to.
  19. Replies
    0
    Views
    621

    Run time error

    I've got a program that I wrote in VB 6.0 which accesses an
    Access database and prints reports. The following code is
    used to preview the report:



    Dim acc As...
  20. Replies
    0
    Views
    631

    Strange Runtime Error

    I've got a program that I wrote in VB 6.0 which accesses an
    Access database and prints reports. The following code is
    used to preview the report:



    Dim acc As...
  21. Can you create a relationship at runtime?

    I have an Access 'make table' query which is run
    when my application is first started. This table is
    deleted when the program ends. Can I create
    relationships between this and other tables...
  22. Replies
    1
    Views
    543

    Passing server password

    I've got an access database that contains 4 linked tables.
    I also have one "make table" query.
    The access database itself is not password protected,
    but the tables are.

    I'm using this code to...
  23. You could use this function: If you want hours...

    You could use this function:
    If you want hours and minutes displayed just pass the
    string "hn" as the interval and it will return a string formated
    as x hours x minutes.



    Public Function...
  24. Replies
    2
    Views
    803

    You can save a picture but you have to set the...

    You can save a picture but you have to set the data type of the field to OLE object and convert the picture to a BLOB (Binary Large OBject)
  25. Replies
    14
    Views
    1,307

    Your problem is probably in all of the...

    Your problem is probably in all of the Quotes/Apostrophes.
    Try using the Chr() function instead. Example:



    uName = "abc"
    pWord = "123"

    sSql = "INSERT INTO WRITER (username,password)...
  26. Replies
    14
    Views
    1,307

    Post your code.

    Post your code.
  27. Replies
    3
    Views
    839

    Read This...

    Read This
  28. Replies
    3
    Views
    839

    Private Sub Command1_Click() Dim sSql as...

    Private Sub Command1_Click()

    Dim sSql as string
    Dim db as Database
    Set db = DBEngine.Workspaces(0).OpenDatabase("path to database")

    sSql = "UPDATE tableName SET Field1 = "
    sSql = sSql &...
  29. Replies
    5
    Views
    748

    You can use the DateDiff() function: ...

    You can use the DateDiff() function:

    DateDiff("yyyy", DOB, Now())

    Where the first argument is the interval you want returned,
    the second argument is the earlier date, and the last argument
    is...
  30. Replies
    4
    Views
    747

    App.Path is the path to your VB application,...

    App.Path is the path to your VB application, Data1.mdb is the name of the database.

    If you use

    app.path & "databasename.mdb"

    in your connection string your database must reside in the same...
  31. Replies
    4
    Views
    747

    What's your question? It looks like you're...

    What's your question? It looks like you're trying to use ADO is this correct? What are you trying to accomplish?
  32. Did you see my relpy to your other post? ...

    Did you see my relpy to your other post?

    http://www.vbforums.com/showthread.php?s=&threadid=216797

    You can do it the same way just use a different SQL statement.
  33. You should put a message box or a break before...

    You should put a message box or a break before the If. . Then to see what values are really in the fields before it errors out. Also check to make sure both fields are text fields.
  34. Thread: Database

    by munsworth
    Replies
    1
    Views
    652

    Each time your timer event fires set up a...

    Each time your timer event fires set up a connection to the DB and run a query looking for the current value you have for the URL and date. If the query returns an empty set then insert your URL...
  35. Replies
    5
    Views
    931

    If you go to Tools/Analyze, Access will document...

    If you go to Tools/Analyze, Access will document your whole database for you. Also, if you open the relationships window then go to File, Print Relationships should be available.
Results 1 to 35 of 35



Click Here to Expand Forum to Full Width