Recent content by olivercastell

thanks, that has fixed the one problem, but now i have another, when i open the form the dose field says #Error (would you expect this? I know it cant contain a value at this point as i havent specified a label code) then one i start to fill in data the #error message goes, but once i enter the...

thank you this is what iv got; Private Sub Label_Code_AfterUpdate() [dose] = DLookUp("[usual dose]", "[Cytotoxic products table]", "[label code]=' " & [label code]"'") End Sub Am I on the right lines? my label code isnt numeric. do I need to define anything before hand with dim or anything...

hi, I got pointed in the right direction with dlook up to solve this problem, but i cant for the life of me get it to work, so any help would be greatly appreciated. I have two main tables: batch record this contains information on each batch, including patient details, date of manufacture...

Thanks , I see how this works however its not quite what im trying to achieve. With this example if you put in the quantity as 10 you get 10 labels, where as for a quantity of ten items i would require 21 labels (2n+1). I cant really change the field from number of items(units) to be...

Thanks When the query runs it is asking me to input the quantity is this what you expected? or am i doing something wrong? I would prefer it if it could automatically take this data (number of labels to print based on the number of units) from the main table as this has already been entered -...

Hi, thanks very much, that seems like a good way round the problem. I think i get it, so you end up with the appropriate number of reports(labels) rather than requesting it to print the one label x number of times.?? Thank you very much for your help Ill give that a go now and see how i get...

Hi, I work in a hospital pharmacy and i am trying to write a database for the production of labels for sterile manufactured products. This is my first real experience with access and im impressed with the possibilities/uses of it. What im looking for is a macro/code to produce the correct...

OK thanks will have a look cheers

hello, I Have one database of pharmaceutical products with required warning labels and a second database of products supplied. Is there a way I can create a form for entry of data into supplied database with a listbox for products so that when I choose a product the appropriate warning label...