access got fill series like excel?
- Thread starter Harrold
- Start date
- Local time
- Tomorrow, 05:30
- Joined
- Jan 20, 2009
- Messages
- 12,895
It can be done using a loop in VBA. Either with queries or a recordset.
The detail of what you want depends on the circumstances of the processing. Are the records already in the table or are you creating new records as you go?
The detail of what you want depends on the circumstances of the processing. Are the records already in the table or are you creating new records as you go?
say i bought a set of mobile phone prepaid card with serial number 0001 to 0050. I would like to enter this set to access with its amount. when a staff request for a card, i will need to key in the details like who use the card, date taken, the month to deduct that amount from salary.
Thanks
Thanks
- Local time
- Today, 20:30
- Joined
- Sep 12, 2006
- Messages
- 15,980
you can enter these with code (equivalent say to using a code macro in excel, - ie not a keysequence macro)
you CANNOT ever drag and drop data in access within a table (I dont think)
It is important to understand why. The point is that although an access datasheet resembles an excel spreadsheet - the real difference is that each row is COMPLETELY independent of all other rows. Autofill in excel works in excel by "knowing" that rows are ordered in a given way (and maintains that order as you process the spreadsheet).
Access is diametrically opposed to this, if you will. Every row stands on its own as far as the "dataset" of rows go, and access itself does not guarantee to present the rows in any order, although the user can stipulate a certain order. So every cell has to be filled indivdiually, although the cell can validate itself in respect of other cells.
That is why you can reorder and filter datasheets in access however you like without ever affecting the data. Because no data in a access table is dependent on other rows.
It may seem to be slightly less "friendly" in some ways, but it's much more powerful in general.
you CANNOT ever drag and drop data in access within a table (I dont think)
It is important to understand why. The point is that although an access datasheet resembles an excel spreadsheet - the real difference is that each row is COMPLETELY independent of all other rows. Autofill in excel works in excel by "knowing" that rows are ordered in a given way (and maintains that order as you process the spreadsheet).
Access is diametrically opposed to this, if you will. Every row stands on its own as far as the "dataset" of rows go, and access itself does not guarantee to present the rows in any order, although the user can stipulate a certain order. So every cell has to be filled indivdiually, although the cell can validate itself in respect of other cells.
That is why you can reorder and filter datasheets in access however you like without ever affecting the data. Because no data in a access table is dependent on other rows.
It may seem to be slightly less "friendly" in some ways, but it's much more powerful in general.
