Recent content by pollenman

I use a query based on the catergory of the client i.e. retailer, bank.

I have a database that I can generate mail merges to multible clients. As part of the database I have an activity table which shows what activity I have carried out for any client i.e. "Made cold call", "Sent new product Letter". How do I update the activity table for the clients that I have...

Thanks

Is it possible to hide report header/footer? regards Terry

Private Sub Command19_Click() On Error GoTo Err_Command19_Click DoCmd.OpenReport "BQAsset", , , "[BranchID] =" & Forms![Branch Detail]![BranchID] & "" Exit_Command19_Click: Exit Sub Err_Command19_Click: MsgBox Err.Description Resume Exit_Command19_Click End Sub

It runs the first page (front cover) of the report which gives details of the report.

I have a command button that when pressed prints the current record, howevwer it runs the report header page as well. How can I prevent this from happening. Thanks in advance Terry

Egnore post, problem solved. Thanks

I have copied my DB and sent to another in my company, however when he wants to run of a report it is going to my network printer and not his own, the default printer on his PC is correct but the report is wants to send it to mine, how can I change this Regards TC any help would be greatly...

Customer is main form and i will be calling the invoice from the customer. Terry

we will get there!!! Yes Customer is main and site for that customer as a subform. Terry :-)

Just so there is no confusion. Customer "Joe Bloggs" with customerID 5 (Autonumber) all I want to do is press the command button ande it brings up an empty invoice for Joe Bloggs. What is happening at the moment is that i click the button and it brings up the invoice for the first CustomerID...

Getting there TheAceMan1 where do i put it in my button? Thanks for your patience Terry :-)

Morning The Ace man Main - Customer Sup form - Site

Sorry, where do i but that code :-)