By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,504 Members | 1,212 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,504 IT Pros & Developers. It's quick & easy.

Slight Changes cause Run Time Error 2465

P: n/a
I have a form that is labeled Document Control. On this form it calls
an API Function to browse for a folder, puts its in to the text box
and allows you to create a table out of the folders contents. The
table field names are FilePath, FileName, ID, etc. all generated
automatically. It also picks up the other table from the database. Now
I also have a command button that when clicked pulls up another form
called getdocs. This form display the folder path in a text box, and
another text that lists the description of the FileName. I would like
to add a value list to the form, instead of scrolling through each
record of FileNames, but rather show a list of FileNames that the user
can pick and open when clicking on a command button. when I try to add
the value list "RunTime Error 2465"
Me![txtPath] = Me![FilePath] & Me![FileName] is highlighted. Anything
possibly small i do to these forms always shows this Error. Even when
changing the code for picking up "doc" and "xls" it will pick up "ppt"
files as well. When I change thats when I get the error. Any
suggestions, greatly appreciated.
Christopher Dix
Kabul, Afghanistan

Feb 18 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
chris wrote:
I have a form that is labeled Document Control. On this form it calls
an API Function to browse for a folder, puts its in to the text box
and allows you to create a table out of the folders contents. The
table field names are FilePath, FileName, ID, etc. all generated
automatically. It also picks up the other table from the database. Now
I also have a command button that when clicked pulls up another form
called getdocs. This form display the folder path in a text box, and
another text that lists the description of the FileName. I would like
to add a value list to the form, instead of scrolling through each
record of FileNames, but rather show a list of FileNames that the user
can pick and open when clicking on a command button. when I try to add
the value list "RunTime Error 2465"
Me![txtPath] = Me![FilePath] & Me![FileName] is highlighted. Anything
possibly small i do to these forms always shows this Error. Even when
changing the code for picking up "doc" and "xls" it will pick up "ppt"
files as well. When I change thats when I get the error. Any
suggestions, greatly appreciated.
Christopher Dix
Kabul, Afghanistan
2465 is a "Can't find the field..." When it blows up, you can scroll
across the abort line and see which field is the problem. Which field
(txtPath, FilePath, FileName) is the problem field? Do any of these
fields have a control source in them (I'd assume they'd be unbound in
your form).

You can go to
http://groups.google.com/advanced_se...e=UTF-8&hl=en&
In the Find box enter
2465
and in the groups box enter
*access*

Perhaps you'll find something in one of those threads that will help you
pinpoint the problem.
Feb 18 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.