Search results for query: *

I got this working now thanks, it was a problem with trying to use rs.findfirst without opening the recordsoure as dynamic (I think) Ended up doing it a different way and its good now! -G78

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

That works now. I'm not use'n autonumber because in the future customers will have set numbers, but right now they are just being assigned numbers for purposes of getting them in the database with their orders. In the future I will force the user to enter the customer id instead of assigning...

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

Opening the recordset as Dynamic works! Thanks!! -G78

I usually like to make a dup just so I'm not messing with my real recordset. When I try use'n the recordset as is that way Mr. Roy I get the error: Run-time error '3251': Operation is not supported for this type of object. and highlights the line: rs.FindFirst "Order_ID = " &...

Operation is not supported for this type of object is the exact error it gives.

I tried that but it won't let me use the .FindFirst or .NoMatch features. It tells me object required. Also tried to do Set rs = CurrentDB.OpenRecordset("Order") with rs cp = .clone end with and a few other things I tried with crazy syntax but I still cant get it to work.

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

Thanks everything is working now. I like the direct method for this it makes things a bit more clean it seams. $$ guys -G78

I'm getting an Run-time error 424: Object required on my Set rs = db.OpenRecordset("Order") line. I'm not used to this method, usually use sql, any ideas? My dim statement for rs is: Dim rs As DAO.Recordset Thanks

I am submitting the SQL from a form. There is no validation attached to the submit button. It does not give a message when it does not work (same as when it does work I have DoCmd.SetWarnings False). There are two tables, Customer and Order. Cust_ID is the primary key for customer, and is...

It happens if I leave any of the fields blank. The fields that are left blank are just normal text or number fields in the table. No validation or index issues. Cust_ID is the only numbered / key value but that is allways entered. If you leave out Size, Class, Manufacturer, Model, or...

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] &...

That fixed me up. I had tried to do it as Str(Me![cbcustomer]) but was getting a mismatch error. Thanks! -G78

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