Aussie1127
Technical User
I need to find out how to add something from an Access form to an Access database without appending it to the end.
In my database table, i have two columns that are needed, one stores all the passwords for a specific program (somewhere in the vicinity of 3000 of them) the other column stores a list of organisations next to their passwords.
I need to find out what command, and how to insert a new organisation in the next available slot that has a space next to the passwords.
I know i need something like :
"SELECT tblAust.Organisation FROM tblAust WHERE (Organisation='' AND NOT password='');"
Here is an example of what i mean :
Password Organisation
0001a IBM
0002b McDonalds
0003c Oakley
0004d <-- Insert here
0005e
0006d
0007f
...
3000z_____________________________________________
Appended record <-- Not here
Can anyone help me?
In my database table, i have two columns that are needed, one stores all the passwords for a specific program (somewhere in the vicinity of 3000 of them) the other column stores a list of organisations next to their passwords.
I need to find out what command, and how to insert a new organisation in the next available slot that has a space next to the passwords.
I know i need something like :
"SELECT tblAust.Organisation FROM tblAust WHERE (Organisation='' AND NOT password='');"
Here is an example of what i mean :
Password Organisation
0001a IBM
0002b McDonalds
0003c Oakley
0004d <-- Insert here
0005e
0006d
0007f
...
3000z_____________________________________________
Appended record <-- Not here
Can anyone help me?