Search results

Hello all, I have two brief questions: 1. I have a DB with many reports and use SQL instead of a query as the Record Source. It makes for a lean Query list but does this increase the DB size or make for less efficient operation? 2. In the same DB, I recently switched form a 2-form menu system...

I want to write an error file using the following statement: Open "C:\Shared Documents\PreMailError.txt" For Output As #1 I get an invalid directory with that, but it works fine with this one: Open "C:\PreMailError.txt" For Output As #1 Assume the space in the folder name is the...

In Access 2000, I use a tab control form with an option group on each page as a menu to run various reports, triggered with a command button. When I click the command button and then try to Cancel a report based on a parameter query, I get a MS VB box with "Run-time error '2501'. The OpenReport...

I'm getting random warning messages in a single-user Access 2000 application involving a multiselect list box (lstRegion), where the user can select more than one item from the list (thanks to MikeAngelastro for the suggesion). I need to save the user selections in a table, to be used in another...

I'm using the following If statement in an Access 2000 procedure: If state = "KY" And county <> 'Knox' And county <> 'Scott' Then do something End If I want to change this to let a user pick one of more county names from a list, use the selections to build and save a "condition" clause in a...