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 derfloh 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. radioman000

    Requery drop-down list

    Thanks very much! The code [DoCmd.OpenForm "frmNewCustomer", , , , , acDialog] worked great! Thanks again for the help! Radioman000
  2. radioman000

    Requery drop-down list

    Hello all, I have a customer service database that contains a service workorder form. This form has a combo box that uses a query to obtain a drop-down list of customer names. In the event that a customer name is not in the list, a button on the form will open my customer maintenance form and...
  3. radioman000

    Print function - Number of copies

    GingerR.. I figured the code out...here is the code that I used and it works perfectly! Dim intCopies As Integer intCopies = InputBox("Please enter number of copies", "Copies", 1) DoCmd.PrintOut acSelection, 1, 1, acHigh, intCopies, True Thanks again for your help! I hope this might...
  4. radioman000

    Print function - Number of copies

    Thanks GingerR for your reply. I tried the code you suggested and it worked great except it wants to print all the records. I need this to only print the selected record. I tried adding the print range "acselection" to the DoCmd.Printout string and I get an error that says "Run-time error 2200...
  5. radioman000

    Print function - Number of copies

    Hello to all, Is there a way in Access when printing from a print "button" utilizing a macro and printing the "selected record" to have a window pop up and ask how many copies you would like to print? I know that you can set the number of copies in the macro, but I need it to ask how many...
  6. radioman000

    How to repeat last entry in Access

    Hi all.. I have an Access database use for service workorders which contains fields for customer name, contact, phone, make, model etc. Many times we get several items from one customer and I would like to make the customer name, contact and phone fields "repeat" when adding the next "new"...
  7. radioman000

    Auto Populating Fields

    Just wanted to say thanks to everyone for the help with the auto-populate problem. Spelling was the problem along with a few periods out of place... here is the code that worked: Private Sub Combo6_AfterUpdate() Dim rst As DAO.Recordset Dim strSQL As String Dim intCustomerID As Integer...
  8. radioman000

    Auto Populating Fields

    John, Thanks for the response top my post. I tried the code you suggested and I am getting an error that syas, "variable not defined" in this line of the code: strSQL = "SELECT * FROM service WHERE CustomerID=" & intCustomerID The "intCustomerID" is the part that access highlights as being in...
  9. radioman000

    Auto Populating Fields

    I have a simple service workorder database and I would like to auto populate the fields for the customer after selecting the customer name from a combo bx drop down list. The database has a table called "customers" and one called "service" which is where all the service records are stored. I...
  10. radioman000

    Full Screen in Access

    Using Access 2002, when trying to add a new text box on on e of my forms, I receive an error message that says "cannot add any more controls on this form or report. If you have deleted controls from this form or report in the past, you may be able to rename the form or report and then add more...

Part and Inventory Search

Back
Top