order of export

  • Thread starter Thread starter mike
  • Start date Start date
M

mike

when I am exporting data from a form in outlook to an
access table, do I need to export the data in the same
order that the fiels read in the access table? I am
wondering because currently my form is not writing
anything and that is that only reason I could fathom.
 
Explicitly name your fields in your query that updates or inserts a row and
use the Values clause to set the values in the same order and the field
names. That avoids any possible confusion.

If that doesn't help then provide your version of Outlook, how you are
writing to the database, any errors you receive and show the code that
updates or inserts a row so others can examine it.
 
Back
Top