Search results

Thanks for the reply Cosmos75 but I don't think this is the probelm. What I am trying to achieve is the following: Users will be working through a waiting list i.e. open the form and then call the person on the form and allocate them to a course(which is done in another system), there is no...

Hope someone can help. I picked up the code below from the forum. I am trying to allow a user to 'lock' the record they are viewing so other users don't work on the same record. This code would seem to do everything I wanted. problem is I can't get it to work. I get an error on this line...

I have added the DoCmd.RunCommand acCmdSaveRecord to the AfterUpdate event of the RecLock boolean field. No longer getting the error, hopefully that will make everything work. as it should. Cheers RussG

Hi - I am using the code posted above by Pat Hartman to lock a record when it is being used but I am getting an VBA error on the save record part of the code. DoCmd.RunCommand acCmdSaveRecord Can anyone tell me what is happening here? Sorry just noticed that I am having the same problem as...

I have a similar issue with a calculating Age , until a date is entered I get the #error. Cheers RussG

I understand, many thanks for your help it's much appreciated. RussG

I have based the form on a query in order to sort the waiting list in date order. You will notice that I have a button to lock the record, this is because 2 -3 people will access the form at once and this stops more than one user working on the same record. I Had the same issue with search...

Hi Dudley, the search box is unbound. I have had a look at all the properties, can't see what it could be at all. Thanks RussG

I added a Search lookup Combo Box at the top of a form. This worked fine until I changed the Forms record source to a query. Don't quiet understand why this doesn't work now. Is there another way to achieve the same function. Thanks RussG

Thought of a solution, Made a copy of the form to be 'Read Only' and locked all the fields manually. RussG

Thanks for replying. I can get the lookup to work by opening the form in normal mode but I want to make the form available to users as Read Only, I also want them to be able to use the lookup. Maybe I need to use another method. Any other ideas anyone. Thanks RussG

Hi - I used the wizard to create a search combo box on my form, i.e the selected item in the combo finds the associated record and fills the form. This works fine, however I have created a macro to open the from in Read Only mode and in this mode the Lookup combo does not work. When you make a...

Thanks Simon, guess I'll give it a shot then. RussG

Yes I had been to the site but was wondering if anyone here had actually done it, any problems/issues, how easy it was etc.

I was wondering if anyone had any experience of integrating a product like QuickAddress (QAS) into an Access Database to aid the completion of address details. Thanks RussG

Sorted the problem, I had allow edits, deletions and additions set to NO. Thanks for your help chaps, got there in the end. RussG

Thanks for that, yes all makes sense. I had tried setting defaults on the sub form but it didn't work, for some reason the system isn't creating a new record on the sub form when I create a new record on the main form. I will have to check how I have set this up, something not right somewhere...

Will do but I will need to clean it up a bit first , I am testing stuff at the moment to see the best techniques to use and the test DB is a bit of a mess. I will try and do it over the next couple of days. One thought did occur to me earlier when I had another look at the Northwind DB. In...

No that doesn't work at all. The strange thing is this is the same setup as on the orders form in Northwind. No errors show in the 'subtotal' text box on the orders form when there are no orders on the sub form but I can't see any extra 'bits' to stop an error showing. (so why am I getting the...

Thanks for your reply, that doesn't seem to work? Totals are still passed but I am still getting the error. Cheers RussG