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

    Operation not supported by this type of object?

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

    Operation not supported by this type of object?

    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 =...
  3. Gumbo78

    header show on every page?

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

    Max function problem

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

    Max function problem

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

    .RecordsetClone from a form bound to different table

    Opening the recordset as Dynamic works! Thanks!! -G78
  7. Gumbo78

    .RecordsetClone from a form bound to different table

    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 = " &...
  8. Gumbo78

    .RecordsetClone from a form bound to different table

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

    .RecordsetClone from a form bound to different table

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

    .RecordsetClone from a form bound to different table

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

    print to more than one printer @ same time?

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

    form maximize on load

    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?
  13. Gumbo78

    force report to open in landscape

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

    Insert problem when some fields left blank

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

    Insert problem when some fields left blank

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

    Insert problem when some fields left blank

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

    Insert problem when some fields left blank

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

    Insert problem when some fields left blank

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

    missing operator?

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

    missing operator?

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

Part and Inventory Search

Back
Top