Search results

Thanks for all the help peeps, Im still having a slight problem though. When i transfer the data base from my local machine to the server the password and check box conditions no longer apply. Is this due to the ME. statement? Im fairly new to this so any help would be good. Should I...

Cheers DCB your a champ. I did have something similar earlier but did not have the else statment for the conditions where you have put it. I have changed the "Me.AllowAdditions = False" to = True though as I need them to be able to enter new records. Thanks again for your help. Adam

Hi guys and girls, Im having an issue with unlocking records for editing. I have a check box on a form that is selected by our accounts dept and when it is checked and the focus is taken away from that record then it is locked for editing and deletion. See code: Private Sub...

Thanks John, Please excuse my ignorance as I am fairly new to access. I will look at changing the names of the tbl's etc.. and give that a go. I have had some limited success with the following but it is producing some interesting results Transaction Amount: IIf([TBL Accommodation...

Thanks for your reply John, I tried what you suggested but still no luck. I'm getting the same error as before. I now have the code as:Transaction Amount: = ( [QRY_CAMP COSTS]![COST PER NIGHT] where [TBL_Accommodation Transactions]![Camp Location]==[TBL_CAMP COSTS]![CAMP LOCATION] Cheers...

Hi everyone, I am trying to use expression builder to gather information for my table. For example i have 2 TBL's TBL Accommodation Transactions TBL Camp Costs and have generated a query that gets its results from TBL Camp Costs. QRY Camp Costs Results are: For Example Camp...

Thank you for taking the time to reply. Unfortunately I am a little confused with regards to "Set their control source as the appropriate field from the Record Source of the form" Could you explain this for me please. I already have an after update event procedure in place. Thank you Adam

Form not saving all data to Table. :( Hi Everyone, I am fairly new to Access and have a couple of questions. If you could help me solve the issues I am having it would be greatly appreciated. Currently I am developing a Database that keeps track of the Employee flight & accommodation...