Recent content by dmenger

Hi All, I have a continous form that is populated from a query. The header has data entry text box for NCR#. I want to run a update query to have the header update each record found in the query. I've tried a number of things and the closet thing I've got is the header entry updating every...

Can't Save it as 2003 file type, and doesn't give me the option to so 2007

Well I'm open to other ideas, but I think this is what I need. The function of the database is to track defective parts as they go through the process of rework. So parts come in at different times and quantities, but don't get touched until enough of them has accumulated to run a full load...

Hi All, No one seems to be able to answer my question. Please Help :banghead: I have a query run that gives me a list of records that I view on a continuos form. What I want is to press a button and run a macro/Append Query to add a Single Summary record to another table. For example my...

1. Open your 1st Table and Select create Query 2. Make the type of query an append query and select the table to wish to add records to. 3. In the query menu add all the field you wish to be in table 2 to the feild rows 4. Select your table 1 in the table row. 5. Adding filters can be done...

Hi All, New to Access could have done this in excel in a heartbeat. :banghead: Looking to perform a query then cycle through each record and spit out each serial number into another table in a single record. Please Help Sub SN() Dim Form As Form_NCR Dim QueryLR, NCRLR, NextSN As Integer...