"snowiii" <snowiii@discussions.microsoft.com> wrote in message news:6DFEFB02-7942-4708-B5A6-A650B8421EF8@microsoft.com... I am trying to input form fields from a word doc into access...I alos want to add the file name as a field into the table with the data fields...I am running up against a brick wall on this and am a rookie at VB....I have the code shown below...Any help

Awesome! This will take a few days to enter all the data, but I will get back with you. Thanks Again! "Klatuu" wrote: Okay, now we need to load some data into the tables. First, create a simple form using tblVehicle as the form's record source. Put a text box control on the form for each field in the record source. Once you have selected a record source, you will get a box with

Thanks a million! I did the tables as stated. "Klatuu" wrote: Okay, thanks. You need one table that contains all the year, make, and model combinations. It also needs a unique primary key. In this case, an Autonumber field would be a good idea. This is not a properly Normalized design, but since you are not familiar with Access or Relational Database design, we can keep it

I tried this an nogo...I need to import the file name into a named field in the table called "FileName" which is a text field. I tried the below and received an error "Compile error. Expected array"... Here is the altered code.... !strFileName = strPath & strFileName(FileName).Result "bart.nissen@gmail.com" wrote: On Apr 28, 9:41 am, snowiii <snow...@discussions.microsoft.com> wrote

I am trying to input form fields from a word doc into access...I alos want to add the file name as a field into the table with the data fields...I am running up against a brick wall on this and am a rookie at VB....I have the code shown below...Any help would be appreciated. Snowiii Private Sub GetWordData_Click() 'You need to add the path to the docs you want to process - this is hard