Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Inserting Data from a form to a specific point in a table

Status
Not open for further replies.

Aussie1127

Technical User
Apr 16, 2003
2
AU
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?
 
One way to do it would be to:

Create a query based on your table
Set the criteria for field Organisation to Is Null

Create a form based on the query.
Set the Allow Additions property to No to prevent users adding new records.

Put the Organisation field on the form - if necessary also put on the Password field (you might want to set the Enabled property to No)

This form will enable the users to enter the organisation name in the next available space.

HTH
Chris

Oh why do you walk through the field in gloves?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top