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

    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"...
  3. 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
  4. 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...
  5. 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