Group:  Microsoft Access ยป microsoft.public.access.modulesdaovba
Thread: how do I debug access script?

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

how do I debug access script?
wstephanie 23.08.2006 22:06:02
I have a database that someone else created for me and then went on
vacation...When I attempt to upload data from a selected file, i get runtime
error 2391 Field F2 does not exist in destination table. When i pull the
table and do a find, there are no results...
RE: how do I debug access script?
rocco 23.08.2006 22:31:02
The name of the field can be mispelled in the code.
Open the table and see if you find any field named F2.

Rocco

"wstephanie" wrote:

[Quoted Text]
> I have a database that someone else created for me and then went on
> vacation...When I attempt to upload data from a selected file, i get runtime
> error 2391 Field F2 does not exist in destination table. When i pull the
> table and do a find, there are no results...
RE: how do I debug access script?
wstephanie 23.08.2006 23:01:01
Tried that, no luck.

"rocco" wrote:

[Quoted Text]
> The name of the field can be mispelled in the code.
> Open the table and see if you find any field named F2.
>
> Rocco
>
> "wstephanie" wrote:
>
> > I have a database that someone else created for me and then went on
> > vacation...When I attempt to upload data from a selected file, i get runtime
> > error 2391 Field F2 does not exist in destination table. When i pull the
> > table and do a find, there are no results...
RE: how do I debug access script?
rocco 24.08.2006 02:12:01
If you meant you didn't find any field named F2 well the trouble is that!
The code is trying to pull data in some place that doesn't exist.
If you know which kind of data the field will receive (ie. date, currency,
number, string...) you can try to add the field yourself by opening the table
in design view (righclick on the table and choose design view).
Rocco

"wstephanie" wrote:

[Quoted Text]
> Tried that, no luck.
>
> "rocco" wrote:
>
> > The name of the field can be mispelled in the code.
> > Open the table and see if you find any field named F2.
> >
> > Rocco
> >
> > "wstephanie" wrote:
> >
> > > I have a database that someone else created for me and then went on
> > > vacation...When I attempt to upload data from a selected file, i get runtime
> > > error 2391 Field F2 does not exist in destination table. When i pull the
> > > table and do a find, there are no results...

Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net