Adding a record then filling it in

[Guest]

Hi All,

Really stupid question, but bear with (newbie with VBA and Access for the
most part). I want to allow the user to pick a file (or set of files) and
then fill in a table with attributes from the selected file (file name, date
created, etc). How do you do this? I can get the file list and loop through
them, but I can't seem to find any help on how to add a record to the
table/fill it in.

Thanks again!

 

[Guest]

Part of the difficulty in answering your question is that there is unclear
terminology.

What is a "file" in your case? Is it a record in an existing Table or an
exterior file somewhere else?

You state to "fill in a Table"...but do you actually mean to fill in a Form?

not sure....

 

[Guest]

Exterior files, jpg image files specifically.
Nope add records and fill in the fields with the data. Sure the user can
edit it through a form later, but the data has to be in the table in the
first place right?

 

[Guest]

ok - - well then what I think is that you are in the generic area of
importing data into a table. That vanilla feature is found when you have the
Table open - look in 'File' at the upper left toolbar and select 'Get
External Data'

Of course this is mechanized - so the file format has to have a fixed
logical structure in a format that Access will recognized........not sure
your raw jpg is...but on the otherhand to do it via coding one would need a
fixed logical structure anyway.....so probably you will want to
massage/manage your file into a mode that is import-able....perhaps changing
to structured txt file or something...not sure - you may have to
experiment....