Search results

  1. X

    Find as you type

    I just need to know how to activate a query every time I type a character in a textbox.
  2. X

    RecordSet Problem

    I have a recordset and I'm trying to get it to select the last entry in a certain row in a table but it doesn't support the MoveLast command and getting MoveNext command in a loop causes EOF error.
  3. X

    Having Trouble with Tree Views

    I have to add a TreeView for a form. This treeview must have 3 nodes, and each node contains simple information based on a value selected from a combo box. The samples I have seen all have added features that I do not want or need. There are 4 tables involved. Let's say I work for a State's...
  4. X

    Trying to run a COUNT statement but having trouble

    It still doesn't seem to work.
  5. X

    Trying to run a COUNT statement but having trouble

    Both just makes the textbox say the statement rather than doing it.
  6. X

    Trying to run a COUNT statement but having trouble

    Anyone?? This is work related.
  7. X

    Trying to run a COUNT statement but having trouble

    I have a text box and I am trying to count a certain number of rows. Suppose the textbox is called txtnumrows My SQL Statements are as follows: (the rest is probably unimportant) Dim sqlstring as String sql string = "SELECT COUNT (rowcount) FROM tbltable" DoCmd.RunSQL (string) I have tried...
  8. X

    Calendar form

    I need to have a Calendar that can add appointments based on name, start time, end time, and description. How do I do that? Will I need four times the number of text boxes?
  9. X

    Access toolbar Programming

    Ok, now I have a question about the Application.CommandBars("nameoftoolbar") function. I have a toolbar with a menu with command buttons inside, sort of like this. toolbar name is toolbar A menu on the toolbar is file on file is changepassword quit save How do I make the changepassword...
  10. X

    Yes/No to boolean

    doesn't work. I think the problem deals with the boolean statement.
  11. X

    Yes/No to boolean

    enablethis = DLookup ("candothis", "tbltable", "tblname = " & cmbtblname) This is what it looks like. Syntax is correct (I use other DLookup commands and they work).
  12. X

    Yes/No to boolean

    ok I am putting a field, enablethis = DLookUp ("candothis", "tbltable", tblname = " & cmbtblname) enablethis is a boolean candothis is a yes or no field tbltable is a table tblname is a text field in a table cmbtblname is a text field on the form I'm getting an error message that says "You...
  13. X

    Yes/No to boolean

    I need to know how I can get code in Visual Basic to understand a Yes/No field in a table? I would prefer using booleans, but anything is fine.
  14. X

    Access toolbar Programming

    I'm still a little confused. I know what the Module does but how do I get to respond to a toolbar-button click event?
  15. X

    Access toolbar Programming

    I need to know how to make a command button on a toolbar open a form. The code has to work for each and every form I have.
Back
Top Bottom