Search results

  1. A

    display records accross the page on a subform

    Hey guys, I have a subform with the default view set to continous forms with one control on each. Is there any way I can display the records across the page rather than down? Thanks in advance!
  2. A

    CODE worksheet function

    Thanks for that!
  3. A

    CODE worksheet function

    Hi guys, I'm trying to return the code associated with a character. Access Help tells me to use the CODE worksheet function, eg. CODE(A) returns 65, CODE(B) returns 66 etc. This works fine in Excel but what is the equivalent function in Access? In other words I want the inverse of the "chr"...
  4. A

    loop through every record in a field

    Thanks very much! I knew there must be an easier way!
  5. A

    loop through every record in a field

    Hi guys, I want to loop through every record in a yes/no field (intFilterCode) in a table (tblOrganisation) and set every yes (1) back to a no (0). Could anyone give me a bit of code for this please? I'm afraid I'm not much of an expert. Maybe there is an easier way to do this? Thanks a lot
  6. A

    Multi select list box

    Hi guys, Thanks for your thoughts on this. I've finally sorted this and included some code so that the query runs with no criteria if nothing is selected in the list box. I'll post the code when I've got some more time.... Cheers Adam
  7. A

    Multi select list box

    Wayne, Thanks for that. Do you mean the quotation marks in the IN clause? I'm not much of an expert! Any ideas on how I get the WHERE clause I've got in a text box on a form into the query's SQL statement? Adam
  8. A

    Multi select list box

    Hi all, I'm having real trouble specifying the items selected in a multi select list as criteria in a query. I've tried loads of different code from various forums but so far nothing has worked. I got the following code from the Microsoft knowledge base but when I run it the debugger...
  9. A

    running queries from another database

    Hi, I have several make-table queries in different databases that when run all create tables in a common database. I want to create a macro in this database that runs all these make-table queries at once so that the tables are kept up-to-date. In other words, how do I run an action query that...
Back
Top Bottom