boblarson

Split the database and give each user a copy of the frontend. Multiple versions working in the same db file can only lead to corruption, as well as behaviour you describe here. See here for more about that: [url]http://members.shaw.ca/AlbertKallal/Articles/split/index.htm[/url]

Check out my sample here: [url]http://downloads.btabdevelopment.com/Samples/listbox/SampleSelectReportFromForm.zip[/url]

[QUOTE=mansi sharma;579803] PLz checj my above procedure for listbox & reply where I m going Wrong.[/QUOTE] The very first thing you are doing wrong is using LOOKUPS at the table level. Wrong, wrong, wrong, wrong, wrong....Can you tell I think it's wrong? See here for more info about that: [URL="http://www.mvps.org/access/lookupfields.htm"]The …

It's possible your auto updates updated your Access 2003 to Service Pack 3 and that has some wonky things going on with it. If you find yourself on SP3 be sure to apply the Access 2003 Post SP3 hotfix.

This is roughly what you want. Don't know what you want for the result so I returned the value that was the largest. [code] Option Compare Database Private Sub cmdCompare_Click() MsgBox "The largest number is " & FindLargestNumber(Me.Text1,Me.Text2) End Sub Public Function FindLargestNumber(dblNumber1 As Double, dblNumber2 As Double) As Double …

Make sure when you go to install your drivers, that you run the install as Admin because in Vista, if it is changing configuration and it isn't Microsoft Software, it doesn't always let the software install unless it is certified by Microsoft UNLESS you run the install as admin.

[QUOTE=Milster;520910]Hello. I'm working on a similar project. Is it possible to have the results returned in another form, Rather than a report? I want to do a Date range search and then be able to edit the data in my resulting records. Thanks[/QUOTE] Yes, you would do similar to what …

Check out this report sample here on my site. It shows you how to set the criteria for reports from a form: [url]http://downloads.btabdevelopment.com/Samples/combos/FormSampleFromMultipleCriteria.zip[/url] It isn't exactly the same as what you are looking for, but it should get you on the right track.

[QUOTE=K7AAY;523628]Looks like Access 2003 and earlier don't have that feature, and there are multiple Office Marketplace apps for sale.[/QUOTE] Don't have what feature? The documenter is available in 2000 to 2007 I know that as I have them.