Recent content by kstump

It Worked Thank you very much, it worked perfectly :)

I have a very weird situation . . . I have two different sytems which contain a UPC #. System 1 has the UPC set up correctly as an 11 digit number. System 2 has the UPC set up as an 13 digit number. I need to take that number and convert it to match the 11 digit in the System 1 so that I...

It didn't work. The CustomerNumber feild is a number . . . the form name is frmLastCustomer

I have a very simple question . . . This is the first time I have tried to do a DLookup. I have a field CustomerNumber. When the value is entered, I want to make sure this is not a duplicate number in a table LastCustomer. I have been trying to make this work as an AfterUpdate code, but so...

I need to filter my reports by a date which would be selected by the user. I have an append query which includes a field in the table called Date. This field is automatically updated when the append query runs. When the user selects the "Review Report" button on the form, I would like them to...

Your probably correct in that I could be running into some problems. The problem is that the data in my linked tables (which I do not have control of) change almost daily. When I run the make table query and then print the report one week, all the data will change by the time I run it again...

Is there a way to save a query to a table when I run the query which will allow me to name it then. Basically, I have tables which are linked to more extended ODBC database which is updated constantly. Each time I run a report (or query) I need to save the data as a table, I would like to be...

I have two tables which are linked from a database I cannot change. Each table contains a field called Category. In what table it is defined as a text and the primary key. The other table defines the field as a number. I am trying to combine these in a query, but need to convert the text to...