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?
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...