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

Method or data member not found--but it's there!

lwwhite
P: 16
This is driving me crazy and probably has a simple solution. Access 2003 Win XP. On a form, I have an unbound text box named "drive." I have an unbound combo box called "version" that looks up values in a table. I have a button that calls a shell statement that concatenates the values in these fields plus some other fields and some hardcoded text to create a complete path to a document to open in in FrameMaker. This is working perfectly on several other forms in my database. On this particular form, I get the "Method or data member not found" message for both drive and version, as if those controls were not on the form or were there by some other name, but I have checked and double-checked and those are the correct control names. When I'm in the VB editor and type "Me.", the dropdown includes those control names for selection.

I tried re-adding the unbound controls, letting Access assign a default name and using those names in my shell statement instead, but still no go. I've repaired the database and everything else I can think of.

Any clue why I am getting this message and what I can do to fix it? Here's my shell statement:

Shell "C:\Program Files\Adobe\FrameMaker7.1\FrameMaker.exe " & Me.drive & ":\Sourcedocs\EMRSuite\" & Me.version & "\" & Me.path & Me.sourcedoc, vbNormalFocus
Dec 6 '06 #1
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,660
Try putting in your code before your Shell() code :
Expand|Select|Wrap|Line Numbers
  1. Dim strTest As String
  2. strTest = "C:\Program Files\Adobe\FrameMaker7.1\FrameMaker.exe " & Me.drive & ":\Sourcedocs\EMRSuite\" & Me.version & "\" & Me.path & Me.sourcedoc
  3. Debug.Print strTest
and see what is displayed in the debug window (Ctrl-G from the VBA window).
Dec 7 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.