Search results

Did the trick. Thanks for your patience and help, Dante

I inserted the following code on current into the form. Private Sub Form_Current() If Nz(Me.[ID], 0) = 0 Then Me.[ID] = DMax("[ID]", "[table1]") + 1 End Sub I set up a sample table(table1) and I use ID and my shipper number field. However, I am not getting the desired results. I did get...

True. I need the numbers to be consecutive and continuous. I am not sure how to implement your suggestion. Need support putting it in place. I know this is a simple task but its still new to me. Thanks,

Sounds simple enough. Can I do this in the control or do I have to copy into the code? I am not very sure about how it works using code. Also, will the new form open with the value in place or do I have to set a parameter to make this happen? Thanks

I am new to Access but have done a seach on this subject to gain some info. I have a form to record shipping information and each record contains a primary key record called "shipper number" followed by dtae, location, etc. The value of the "shipper number" is simply increased by "1" for each...

I am creating a report to replace a business form that we current use at work. I would like to replicate the form as closely as possible. It has a gride set up on each page consisting of several rows and columns. What is the easier way for me to create a simialr format using Access 2007...

Not sure exactly how to do this. Understand that several records may have the same order number but the line item number will be different. Won't the duplicate order number create a problem? Thanks, Dante

Friends, My database currently has two tables. One table logs in purchase orders and the primery key is the purchase order number. The second table tracks the line items from the purchase orders and is tied back to the purchase order number. I would like to prevent a line item number from...