Search results for query: *

I am getting the error: Operation not supported by this type of object I only get a message box, access does not open the VB screen and highlight any code. This is my code: Private Sub cmdsave_Click() On Error GoTo Err_cmdsave_Click Dim rs As DAO.Recordset Dim db As DAO.Database Set db =...

I'm a newbie for access reports. I can't get the report header to show on every page like the footer does. Is there an option I need to set in properties, or I need to set up code on the OnFormat event? -G78

I am use'n a form to enter customer and order information. If the customer allready exists, the form will auto fill in their Cust_ID and Email so that the user does not have to. If the customer does not exist, I am trying to make the form search through the current Cust_ID's and find the max...

I usually use this method to search a record. I use the logic below except for the Set cp = Order.RecordsetClone is usually Set cp = Me.RecordsetClone The form I am searching from is bound to the Customer table. The value I need to search is in the Order table. This is what I have...

I'd like to be able to print my reports to two printers at once without make'n the user print to one, choose the second printer, print to the second. Is there a method to print to two printers at the same time? The default in the wizard for print report only previews the report and doesnt...

Is there a way to make a form allways maximize on load/open? I can find anything under properties, I couldn't find anything to add to the onload or onopen property in the DoCmd etc lists. There a built in function to accomplish this?

I use SQL to create a query, save the query to a string then print the report. The report template I use needs to be landscaped (many fields and I need the room.) Many users use my program and have their page/printer options set differently. Is there a way to make the report open in landscape...

I am having a problem when entering data and I need to leave some fields blank. This is my SQL statement: strSQL = "INSERT INTO Order (Cust_ID, Size, Class, Manufacturer, Model, Comments) VALUES ('" & [cbcustid] & "','" & [cbsize] & "','" & [cbclass] &...

I have a form that uses combo boxes to enter data. When there is a change in the customer name combo box, I want to search to see if the customer exists, and fill in their customer number to the appropriate area so that I dont allways have to look it up from a printed list. This is my sub...