Search results

Hi Guys, Just about to leave for the day. I have attached a copy of the database that we are working on. Its in the early stages. I thought it may give you more of an idea of structure ect. Thank you all!

Ah, Silly me!! Been staring at it for too long! I have just made the changes as you suggested but i am still getting the same error. when i go to debug, it is highlighting in yellow the... DoCmd.RunSQL TheSQL Any Ideas?

Hi Guys, Thank you all for showing an interest. I have attached the code as a word Doc. Many Thanks

The above code is on the Update after on the Logged by Field. The code calculates the serial end number for us.

Great, this has worked really well. I have now tried to add data from a combo box to update the table and i get the following message that i have attached as a word document. You have been a great help!!!!!:):)

Thanks for the prompt response.:) We want to log all of the boxes of prescriptions into a table using one entry into a form. Currently, the user does this in Excel as follows. Eg. A B C 1 Box Number - Serial Start Number - Serial End...

I Work for an NHS organisation. A department here orders prescriptions and sends them out to Gp Surgeries. I have been tasked in designing a database to make this easier for them. Prescriptions arrive on a Pallet. Each pallet has 100 Boxes of prescriptions on it. Each box Contains 2000...

Hi Thanks for getting back to me so quickly and for the Welcome. The coding that I have used so far has come from various sources on the internet and my manager (She has a bit more Knowledge than me!) I will explain exactly what I have done and what I am hoping to achieve. Please bear in mind...

Hi, i am new to Access I have a form based on a query and have written code to display a msgbox if a duplicate entry is inputted in the NHS_Number field in the form. I have also added code "me.undo" to clear the form so that it is not saved. I am looking for a piece of code that will display...