Search results

I am trying to work out how to batch enter some info into a table or query. Sample attached. Basically this sample db is part of a bigger db i'm working on. It tracks the administration of medicine on animals. Using the "Individual Medicine Admin" button on the sample db it is simple to select...

Thanks for the replies so far - not sure if i explained myself very well. I'll use the northwind db as a basis for trying to explain what i want to do. Afterwards, if you could tell me whether the suggestions already made will work then i'll work on it. Using the relationships in northwind...

I have been developing several databases over the last couple of years, and whilst i wouldn't consider myself a genius i am pleased with what i have learnt and achieved in this time. In the course of this development i have found a couple of times that i wish to apply a similar value to multiple...

NOt sure i understand you Bob ! MOst of the time the customer details will be repeated in the quote details but there are also many times when the quote details are different. The reason is because we make buildings. Most are directed to our own customers but some are for other building firms...

Hi all Its been a while since i posted and i liked to just say thanks to all the people who have responded in the past to various problems i've encountered - it's been a huge help in my learning of access programming in VBA and i find it gr8 fun...... However i now a strange problem that i...

Hi all. I have a database that amongst other things has a list of contracts with addresses, phone numbers etc. I can select any record & double click it to show me more details in a form. In this form i want to add a button that when clicked will open up a jpg. The jpg will depend on the...

Thanks for your reply. It is similar but does differ to what i need. It appears that your code would add images to a report. I need an open dialog box that points to a specific folder that list files of type jpg, gif, htm or bmp and shows only files beginning with the contract no ID. Is this...

Hi all. I have a database that amongst other things has a list of contracts with addresses, phone numbers etc. I can select any record & double click it to show me more details in a form. In this form i want to add a button that when clicked will open up a jpg. The jpg will depend on the...

update i still have not had time today to do anything on the db but i wanted to just thank you for your input.....i will make more time 2moro. thanks again rabbie

Thanks - i will incorporate into db and let you know - before i do (it is 1st thing monday morning) but what is this doing : If Forms!frmMedicineAdministered!qtyLeft = 0 Then End If ??

That may actually sound logical. I wonder whether its doing my calculation whilst the command is running to save the record .!!!! Could that happen ? Is there a way to put a slight pause between the 2 commands ?

Bob, i think i know how to set a breakpoint but how do ya step through the code. I have set a breakpoint on the line of code in question and notice the value of AmountLeft is wrong - if i knew how to step through, would it show me that value change to correct itself ?

I'm glad in a way it's not just me that is baffled by this - if anyone else has an idea then feel free to offer your suggestions !:confused:

Timing is 1 thing that did keep passing my mind but i disregarded it after a bit of investigation. I forget why now though. The strange thing is that when you go back in then out of the amount box it recalcs correctly.

I have uploaded here the updated database - it still has the problem i am trying to get over with the AmountLeft & qtyLeft boxes not being in sync but i may give you more idea what the 'bigger' database is doing. I am using Master/Child links between the Form & Subform instead of relationships...

I have uploaded here the updated database - it still has the problem i am trying to get over with the AmountLeft & qtyLeft boxes not being in sync but i may give you more idea what the 'bigger' database is doing. I am using Master/Child links between the Form & Subform instead of relationships...

Where are the DB inventory things you mention

I get what you're saying but i'm not trying to store the calculated field. I want to copy the value from the calculated field, to a field which is stored. Then at some point when i click the tick box i want to make the stored field zero regardless of the value of the calculated field. IE when...

Fantastic - many thanks - i've tried quite a few things - i'm fairly newbie and not familiar with a lot of commands so maybe i'm missing something. I still don't understand error trapping or on err routines yet either.

OK i've added the report i'm on about. If you pick a medicine that is nearly empty then tick the empty tick box it will force the empty status to zero and not show up in the report. This is what i'm after. But when you tab out of the amount box in the subform you have to go back in then back...