Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. pollenman

    Activity Record update

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

    Activity Record update

    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...
  3. pollenman

    Reports

    Thanks
  4. pollenman

    Reports

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

    Printing Pages

    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
  6. pollenman

    Printing Pages

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

    Printing Pages

    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
  8. pollenman

    Change Printer

    Egnore post, problem solved. Thanks
  9. pollenman

    Change Printer

    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...
  10. pollenman

    Add Record

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

    Add Record

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

    Add Record

    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...
  13. pollenman

    Add Record

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

    Add Record

    Morning The Ace man Main - Customer Sup form - Site
  15. pollenman

    Add Record

    Sorry, where do i but that code :-)
  16. pollenman

    Add Record

    Hi all, I have created a button on my customers form to add an invoice, how do i keep focus against the chosen customer? Regards :-)
  17. pollenman

    Linked Tables

    Answered my own question. LOL Terry :-)
  18. pollenman

    Linked Tables

    Thanks guys, the tip about the date is excellent. Hymn - The database is split and I am at the front end is that right or should i be looking else where. Terry :-)
  19. pollenman

    Linked Tables

    Morning All, I have a linked database, however one of my colleques suggeted that it would be a great idea to have a ticked field to say job complete. Problem, how do i add a field to an existing linked table, as it won't let me, I have tried deleting the link as suggested in help but it says i...
  20. pollenman

    Questionaire

    Thanks guys, any ides how this could be acheived? Terry

Part and Inventory Search

Back
Top