Search results

That is it. Thank you very much for all of you assistance. :D

When I run this code I get an error in the CurrentProject.Connection.Execute area.

I have been searching on the append queries, to no avail. I can't get the syntax right to add these fields to the code that you gave me.

Thank you very much

How would I go about getting 2 date field to be populated along with the bar code numbers?

Thank you very much!!! This worked great! I am sory again for the multiple postings

I posted in the general forum first and thought it would be better in the VBA forum. Sorry.

When I do this I get and ivalid use of Null error on:intMin = DMin("[MyNumber]", "NumbersBetween") + 1 Any ideas

I am using Access 2003. he table is name BarCode. It has the following fields: DateIn, DateOut, BarCode.

I want to define the range by putting numbers into 2 different fields? I have bar codes that get entered into a database. There are times when I want to enter the first bar code and the last bar code and have the bar codes in between automatically populate.

I am new to programming, how would this be done

I want to define the range by putting numbers into 2 different fields? I have bar codes that get entered into a database. There are times when I want to enter the first bar code and the last bar code and have the bar codes in between automatically populate.

I have the same issue. I cannot find the post that you mentioned that might have the solution.

I need to add a range of records to a table based on the entry of the first record and the entry of the last record. Example: If I enter 123 as the first record and 127 as the last record, I want Access to create records for 124, 125 and 126.