Adding to an imported table

E

elisemack

I am a beginning Access user. When I order items, I am able to import
the order information (info about each specific ordered item) into an
Access database. I have figured out that I can add information from
subsequent orders to the same big table (and could use a query to ID
stuff from specific orders if necessary).

I want to mark items received or not received. If I do this in the
table, I mess up the column names and importing the order information
doesn't work (at least, it doesn't work with my limited knowledge). I
have tried to create a form where I add in a checkbox, but I when I
check or uncheck the box, it checks/unchecks the box for ALL records,
not individual ones.

I would like to be able to mark each item received (default not
received) and be able to search based on received/not received items.

Can anybody offer any suggestions (again, being aware of my
rudimentary Access skills...)?

Thank you!
 
A

Al Campagna

Elise,
The way you're doing it now, the checkbox is "unbound", and whatever you enter for
Received on one record will show on al others as such.

Your need to add a field to your table (ex. Received - Yes/No type), then make sure
it's included in the query behind your form, and then add the field (checkbox) to the
form, and make the ControlSource to Received.
This is a "bound" (to the field in your table) checkbox. Now when you check True on a
record, it will only be True for that record. Each record will hold, and save, it's
Received value.

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."
 
E

elisemack

Your need to add a field to your table (ex. Received - Yes/No type), then make sure
it's included in the query behind your form, and then add the field (checkbox) to the
form, and make the ControlSource to Received.
Click to expand...

Thanks for the feedback.

I think if I add the Received field, the table will no longer allow me
to easily import future orders. As far as I can tell from having
tried it a few times over the past week or so, when I import, the
table expects the imported data to have the same exact format (same
columns). If I add a Received column, it seems to throw it off and it
won't import properly. Is there perhaps some way around this?
 
A

Al Campagna

You should be able to Append new imported data into your table
even though the table has a Received field, and the import data doesn't.


I have a 6 column import from a comma separated .txt file.
I import that data into the same table each time the user pulls in another days info.
(I delete the records from that table just before the new data comes in)
That table has 7 columns. I put a [Test] field/column in there just to test.
Works fine...
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."
 
Top