Search results

I think I am missing something. Each of these would be a field name to capture data, not data itself. The first section of the field namePRS11- or 60cm- is just to help me differentiate which product line that field is associated to. This would actually be dropped from the field name once I have...

Each product line has a completely different set of components. The components may look similar, However the component part number will vary from product line to product line. I.e. There are no component part numbers that are used on more than one product line. Additionally, a product line may...

Sorry for being silent on this the past couple days. I played around a bit to try and clarify Product Lines. I now have 2 tables (one for each of two defined product line) to show the data that would need to be captured when that product is shipped. Table-60cm_Data Table-PRS11_Data I entered a...

Field labels to the right of Customer Email are part number designations for individual components. I.e.: 60cm-140087-MO is looking for the manufacturing order (-MO) we used to build a 6 pin configured connector (140087) for the 60cm product line (60cm). The 60cm- would be a specific...

Hi Ranman256, You completely lost me. What are make table queries and atomic values?

Thank you for the clarification. It helps my understanding. I typed the code exactly as you provided and get an error message. "Compile error. Expected end of statement." Attached are a couple of images showing the info entered (Capture1) and the error message (Capture2). Any help to fix this...

Hi Pat, I was thinking the same thing. I opened a new thread in the TABLES forum called Table Design & Relationships to pursue the disorganized tables. This thread will remain limited to copying data to a new record. Thank you.

I was provided a database (with inadequate limited data already dumped in by a predecessor) and told to make it work. The end goal is to include all product lines and their component details at the time of shipment to a customer. Currently, the database includes one table with 1200 records. Each...

So the new code would look like the following? Option Compare Database Option Explicit Private Sub Product Line_AfterUpdate() Me.[Product Line].DefaultValue = "'" & Me.[Product Line] & "'" End Sub Private Sub Product_Line_BeforeUpdate(Cancel As Integer) End Sub I understand Private sub...

Hi isladogs, Thank you for responding. When I open the code builder I see the following: Option Compare Database Private Sub Product_Line_BeforeUpdate(Cancel As Integer) End Sub (There is a straight line below Option Compare Database. Not sure if this indicates a module title.) Am I deleting...

Hi Linq, Here is where my ignorance shows. :) How do I find the code module for the form? Thank you.

Hi Pat, I was provided the database (with inadequate limited data already dumped in by a predecessor) and told to make it work. The end goal is to include all product lines and their component details. Thus, this is a one time conversion that I want to ensure will work properly. :) My initial...

A zipped file is attached. A couple notes about the file: Table 1 currently contains all the data. Some of the data records were truncated to reduce file size. Table-60cm Dish is a sample list of the different system components of the 60cm product line. This table is not currently in use and is...

Hi Pat, Table design is another struggle I am having. I suspect I may need more than 2 tables. Currently, this database has one table with 1200 records. Each record contains multiple fields of data and appears to have originated from an Excel spreadsheet. Each System (or product line) had the...

Private Sub YourControlName_AfterUpdate() Me.YourControlName.DefaultValue = """" & Me.YourControlName.Value & """" End Sub Hi missinglinq, Thank you. This sounds like what I want to do. However, could you explain this a bit more? When I type this code into the After Update line on the Event...

I want to type information into a form and then when I save the record, the input data is used to pre-populate fields on the next record/form. Goal: The database captures shipping and configuration information for multiple systems going out to one location on the specified date and tracking...