User Profile
Collapse
-
is there a better way to run the sub than to use a macro? -
how do i call a sub from Access. i see how to call a function....Leave a comment:
-
This is what i was originally thinking of doing but did not know how to write it. I have very limited VB skills but lets see if I get what to do.
I created the following function:
Public Function ParseData()
Cnt = 1
Cnt1 = 1000
Do Until rs.EOF
SELECT AANAAANA.Serial _Number, AANAAANA.Alph_A lias INTO printdatatest
FROM AANAAANA
WHERE ([ID] Between " & Cnt & " And " &...Leave a comment:
-
The data is sorted on the ID field, and there are no gaps in the incremental listing....Leave a comment:
-
I thougth that might be the case as well but they are all there.Leave a comment:
-
the first three queries work great. the last one returns records 3000 to 3998 subsequent sets are off by one more record incrementally. I tried the first format and it returned every 4000th record. I also set the Mod parameter to 4001 Between 3001 and 4000. This returns records 3000 to 3999 but the second set starts at 7001 to 7999 the third 8000 then 1102 to 1201 etc. Any idea how to remedy this?Leave a comment:
-
the ID field starts at 1 and goes to 5,000,000 the Serial field starts at 20,000,000 and goes to 24,999,999 and yes they increment by 1 in both fieldsLeave a comment:
-
the ID field is an autonumber field and the serial field increments by one for each record.Leave a comment:
-
-
The data is a fixed set of 5 million records. we have three fields in the data an ID, Serial, AlphaAlias. We are printing labels each one unique with a serial number and an alpha numeric alias each roll of printed labels is 6500 long. However we are printing four labels at a time. the printer driver needs the data in a flat file that mimicks the four across label configuration. So we need to take the single long list of records and break it...Leave a comment:
-
we need to set up the data in a specific order for a printing process and the primary field has millions of recordsLeave a comment:
-
Query or script to sort data needed.
Access 2003, Windows XP Pro
Trying to take one field of values in a table select a range of records and then skip a range of records and then select a new range of records to append into a new table.
For example, if my inital field has 100,000 records in it and I want to select the first 1,000 records then skip the next 3,000 records, then select the next 1,000 records and continue this until the end of the initial field...
No activity results to display
Show More
Leave a comment: