Recent content by Nick Druce

thanks Many thanks to you both for that

I have created a database that calculates a total for a week or month depending on what the customer wants. How do I calculate the Tax it? I have attached the Databases in case it helps Any help would be great.

Random Generation Thanks for that but how would I go about creating a random password?

I have a table full of user names and passwords, Is there any way that I can make the database randomly allocate one of these passwords to a user? Any Help Would be great.

If I have a form with the details filled in, how do export it into a word template that i have desgined?

thanks thanks very much namliam

I am Trying To calculate Costs for a particular month how do i do this when taking into account that the months obviously hae different lenghts? I have the overall week cost but how do i do it for the month?

I Still get the same error Syntax Error (Missing operator) in Query expression'(childsname=tom)'

I have created a form, when all the feilds are feild in I want to be able to click a button and have the report print out the details for that instance on the form. The code i have is below. When I click the buttojn i get the error Syntax Error (Missing operator) in Query...

Single report I have used my own field names but using [] is a prompt for the user to input somthing. That is what I am tryng to bypass

How do I Pubish a from from access into word using a word template i have created? and not just into a blank word document?

Single Report Thanks For that. However I would like to be able to not have to prompt the user to input the data Once the from is filled in . They just Click the button and the information that is currently on the form is printed to the report. Any Ideas would be very helpfull.

I have all the fields i need but i only want to print a report for one customer but when i try to print the report displays evrything in the table. I need a way of asking the user to select a customer and then it will print the reoprt for that customer only.

When i have a form in access with all the details filled in, how do i print that as a report And NOT have All the fields in the table be printed on the report as well?

I have created a report in access. But how do I get the database to prompt the user for the name of the customer so that it will only print his specifc report?