Search results for query: *

Hi, I have an Access 2000 db that I have converted to access 97. The db was using the access 2000 Split function with vbNewLine to create an array that takes a text files values line by line in a loop. Does anyone know of a way to get this code running in Access 97? LineArray = Split(Str1...

Hi, I have two forms in Access, the first form takes a string with a WHERE clause enclosed and passes it to the second form using the docmd.openform command. The problem I am having is that my primary key field for the table I am accessing is called [ID #]. When referencing this field Access...

I have two forms. The first displays a set of search results and the second shows a line item from the search results screen in more detail. I have a docmd.maximize set on the results screen form load, lostfocus and gotfocus properties. When the results screen is first loaded the form...

Can anyone tell me how to use the SetOption method in VBA to turn off the Confirm changes checkboxes located in? Tools -> Options -> edit/find tab -> confirm boxes there are three options I need to turn off. Record Changes Document Deletions Action Queries Thanks %-(

cpuburn, Thanks for the tip!!! I actualy managed to fix it by putting an "order by" clause into the select statement on the list box. Not sure how this is working, maybe a bug??? Cheers Jonas

I have two list boxes set up on a form which allow you to switch users from one box to the other and add and remove names to the listbox in order to emulate a profiles screen. The first time I change the first row in the list box I have no problem but if I try to further change the data or...

I have two access forms. The first is a standard form and has two text boxes used to search on date ranges. If I enter a date range in engilsh format.ie. DD/MM/YYYY and pass it to the second form as an argument variable, the second form is a tabular form and displays the results using an...