Search results

Further to Bobs post, I have not set Access to run as administrator, and still have had no problems at all.

I haven't had one issue with the thing at all with any aspect or program. I talk to people and they say oooh Vista yuk, stay away from that. The bloke at place that installed the extra RAM (not where I bought the machine) even offered to remove vista and put XP on it because he reckoned Vista...

Of last night (New Years Eve)? ..... Very little :p The laptop came with 1Gb, but when the salesman was demonstrating it he showed me the task manager to see the dual processors working. Went to the tab where the RAM usage is displayed and it was using between 600 & 700 Mb just sitting there...

Oh dear...

Not sure about how you would go about it using macros (gave them away years ago) But code.... To open the second form with only that record: Docmd.OpenForm "YourFormName",,,"IDField = " & Me.IDField To open the second form and goto the record Dim rs as Object Docmd.OpenForm "YourFormName"...

I also have a Vista Business Laptop (ASUS) with Office 2003 and have had no probs (apart from the annoying vista security warnings). One thing I noted in your doc is that the error messages seem to say they cannot find a field, not the value. I find this sometimes if I change a query and forget...

You need to check your references and compare them to the sample db

Try this... I wasn't sure whether a deduct should be added or subtracted, so you can edit the balance due as you wish. Dave PS. I would put the deduct and payment fields in subforms also. This way you can have as many as you like. (Part of normalization)

Quote... Is that repeated line “ Me.sfmOrderItems.Form.AllowAdditions = False “ a typo and should read “Me.sfmOrderItems.Form.AllowEdits = False” ? Yes, typo, you are correct. Quote... If I click the lock/edit button then I can enter data into the sub form but I’m sure this is not how you...

This is a start to normalisation (well the subform anyway). The fields on the main table that can calculate a total should. You should try to avoid storing calculated values wherever possible. The Invoice Amount now calculates from the subform. Hopefully you will be able to use calculated...

I think you need to get outdoors a bit more. :p

After looking at you Db, you need to normalise your tables, then what you are trying to achive would need virtually NO code at all. Dave

Where do you get the data for Me![AccountCode] ? The search code refers to Text23.Text and Me.lstdata.Column(1) If Text23.Text = Me.lstdata.Column(1) Then Me.txtsearch2.SetFocus stLinkCriteria = "[txtsearch2]=" & "'" & Me![AccountCode] & "'" DoCmd.OpenForm FrmWorkfile1, , , stLinkCriteria...

Thats my sense of humor:D:p

Pleasure.. Cheers. Dave

My advice... Ditch the Access Wizard switchboard and create you own (Access form). I think this is just the Access design team showing off. (Or at least showing what can be done with access) When you add a button, simply select [Event Prodedure], then in the code window put: Call RunDeletions...

Dcrake's uses code written in VBA and supplies an SQL line (SQL is the same as a query, except a query is saved) and reloads the listbox each time, where as the sample I have uses very little code, just uses the "*" (wildcard) in a query and refreshes the list box after each key press. Dave

Try downloading the sample example I posted here... http://www.access-programmers.co.uk/forums/showthread.php?t=138165

I would be interested in your solution when it is up and going....

Thank Gary, feel free. The only issue I have with it is that the source of mail merge data you select is stored in a table, so if your db is locked down the end user cannot add different data sources easily. Dave