Recent content by johnbowser11

If you open the word document on its own the merge works fine, it open up access, runs the query and then fill out the merge.

I have a database on a machine with office xp. I store the database in C:\Database. I can run a query then link the results of that query to a template document I have setup via mail merge. The document then opens and fills out the fields based on the query results. I transferred the database...

Hi everyone, an easy one probably for most of you no doubt. below is the code for my button which attatches the report to an email as HTML, what I want it to do is fill in the address field too, with say access@programmers.co.uk so the user can just send the report straight out to the dept its...

ahhhh ok, the invoice address entry int eh customer database sounds like the way to go! MAny thanks for your helpo everyone :)

Because it may be for a customers customer if you see what i mean. All I need is to have some sort of alternate delivery address option, but cant for the life of me work out how to do it.

Anyone? :confused:

Hi Ive got a form that has customer details at the top i.e name, address etc. and then a products subform. Once I have chosen a customer it then automatically fills in the address fields and i can then add products to the order. I then press a button which produces a form showing the customer...

no sorry at query level. Basically my query asks me to enter the items batch number which then returns a list of items with that batch number and the quantity of each so I want it to be able to add all of the quantity coloumn up!

Sorry can you give a bit more detail, or an example as im a bit of a beginner! Just to clarify im after the following ID Description Quantity Total 001 Whatever 5 5 002 Whatever...

Hi ive made a query but instead of calculating the total at the end of each line I want it to add up the total quantity at the end. For example: ID Description Quantity ID Description Quantity ID Description Quantity...

Anyone? I really need help

once the search had found the relavant item, it would then need to be sold to a customer and the quanity sold to the customer would need to be deducted from the total quantity in stock, so the stock levels are correct

Hi, I am a beginner with making databases, so am looking for a bit of advice so I can know where to start. What I'm trying to do is make a stock control database for our drugs dispensary as there are constantly drugs going in and out and they need to be able to keep track of where drugs have...