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...
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...
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...
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...
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"...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.