Travis- That's really strange that the MDAC update or a repair of your Access install didn't fix the missing file. Glad to hear you got it solved!
John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ > -----Original Message----- > From: simonstravis [mailto:[EMAIL PROTECTED] > Sent: Monday, March 21, 2005 7:03 PM > To: ms_access@yahoogroups.com > Subject: [ms_access] Re: Please help on combo boxes. > > > > > John, > I must say that I appreciate your diligence in helping me in getting > this resolved. I finally checked my c:\windowsxp directory ole files > and I noticed that I didn't have the msjetoledb40.dll file in the > directory even after re-installing and repairing the office suite. I > had someone send me the file and I copied it to the directory and it > worked like a champ! I appreciate your help; I really do. > > By the way, I purchased your book Building Microsoft Access > Applications today; and I'm anxious to read it. > > Thank you, > > Travis Simons > Dell Inc. > > > > > > --- In ms_access@yahoogroups.com, "Travis R. Simons" > <[EMAIL PROTECTED]> wrote: > > John, > > I tried downloading the mdac 2.7 and mdac 2.8. which didn't resolve > > the problem. Can you email me simple database that I can replicate > > exactly so I can test it on my system? > > > > > > > > On Sun, 20 Mar 2005 19:50:45 -0600, John Viescas <[EMAIL PROTECTED]> wrote: > > > > > > Travis- > > > > > > You can find the solution to your problem here: > > > > > > http://support.microsoft.com/default.aspx?scid=kb;en-us;839783 > > > > > > John Viescas, author > > > "Building Microsoft Access Applications" > > > "Microsoft Office Access 2003 Inside Out" > > > "Running Microsoft Access 2000" > > > "SQL Queries for Mere Mortals" > > > http://www.viescas.com/ > > > > > > > -----Original Message----- > > > > From: Travis R. Simons [mailto:[EMAIL PROTECTED] > > > > Sent: Sunday, March 20, 2005 6:49 PM > > > > To: ms_access@yahoogroups.com > > > > Subject: Re: [ms_access] Re: Please help on combo boxes. > > > > > > > > > > > > > > > > I curretnly run 2003. > > > > > > > > > > > > On Sun, 20 Mar 2005 18:48:35 -0600, John Viescas > > > > <[EMAIL PROTECTED]> wrote: > > > > > > > > > > Travis- > > > > > > > > > > Which version of Access? > > > > > > > > > > John Viescas, author > > > > > "Building Microsoft Access Applications" > > > > > "Microsoft Office Access 2003 Inside Out" > > > > > "Running Microsoft Access 2000" > > > > > "SQL Queries for Mere Mortals" > > > > > http://www.viescas.com/ > > > > > > > > > > > -----Original Message----- > > > > > > From: simonstravis [mailto:[EMAIL PROTECTED] > > > > > > Sent: Sunday, March 20, 2005 6:25 PM > > > > > > To: ms_access@yahoogroups.com > > > > > > Subject: [ms_access] Re: Please help on combo boxes. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > John, > > > > > > I did verify that the database isn't open > exclusively. I also > > > > > > reinstalled access and it still does it. urg. > > > > > > > > > > > > --- In ms_access@yahoogroups.com, "John Viescas" > > > > <[EMAIL PROTECTED]> wrote: > > > > > > > Travis- > > > > > > > > > > > > > > Did you verify that you do NOT have the database opened > > > > > > exclusively? If > > > > > > > it's open shared and you're still having this > problem, then > > > > > > I suspect a > > > > > > > hosed install of Access. You can try choosing Detect and > Repair > > > > > > from the > > > > > > > Help menu. > > > > > > > > > > > > > > John Viescas, author > > > > > > > "Building Microsoft Access Applications" > > > > > > > "Microsoft Office Access 2003 Inside Out" > > > > > > > "Running Microsoft Access 2000" > > > > > > > "SQL Queries for Mere Mortals" > > > > > > > http://www.viescas.com/ > > > > > > > > > > > > > > > -----Original Message----- > > > > > > > > From: Travis R. Simons [mailto:[EMAIL PROTECTED] > > > > > > > > Sent: Sunday, March 20, 2005 4:18 PM > > > > > > > > To: ms_access@yahoogroups.com > > > > > > > > Subject: Re: [ms_access] Re: Please help on combo boxes. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > The Combo Box wizard should start. Choose the option to > > > > > > > > "Find a record on > > > > > > > > > my form based on the value I selected in my > combo box." > > > > > > > > Click Next. Choose > > > > > > > > > Table: Employees in the second window and > click Next. Is > > > > > > > > this where it > > > > > > > > > fails? John this is exactly where it fails, > and I don't > > > > > > > > understand why. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > If not, add EmployeeID and LastName fields to the > > > > Selected Fields > > > > > > > > > list and click Next. The next window should > offer to Hide > > > > > > > > the key column > > > > > > > > > and display only the last names. Click Finish at this > > > > > > > > point, and you should > > > > > > > > > have a combo box that will go to the name selected. > > > > > > > > > > > > > > > > > > > > > > > > On Sun, 20 Mar 2005 15:44:42 -0600, John Viescas > > > > > > > > <[EMAIL PROTECTED]> wrote: > > > > > > > > > > > > > > > > > > Travis- > > > > > > > > > > > > > > > > > > Open any database. Choose Options from the Tools > menu. On > > > > > > > > the Advanced > > > > > > > > > tab, make sure Default Open Mode is set to > Shared. If you > > > > > > > > had to change it, > > > > > > > > > you'll need to exit Access and restart to > begin opening > > > > > > > > your files shared. > > > > > > > > > > > > > > > > > > You should be able to create a form like this in > Northwind. > > > > > > > > Open the > > > > > > > > > Northwind sample database and select the > Employees table. > > > > > > > > On the next to > > > > > > > > > last button on the toolbar, drop down the choices and > > > > > > > > select AutoForm. > > > > > > > > > Switch to Design view and choose Form > Header/Footer from > > > > > > > > the view menu. > > > > > > > > > Turn on the Control Wizards in the Toolbox > and add a combo > > > > > > > > box to the header > > > > > > > > > of the form. > > > > > > > > > > > > > > > > > > The Combo Box wizard should start. Choose > the option to > > > > > > > > "Find a record on > > > > > > > > > my form based on the value I selected in my > combo box." > > > > > > > > Click Next. Choose > > > > > > > > > Table: Employees in the second window and > click Next. Is > > > > > > > > this where it > > > > > > > > > fails? If not, add EmployeeID and LastName > fields to the > > > > > > > > Selected Fields > > > > > > > > > list and click Next. The next window should > offer to Hide > > > > > > > > the key column > > > > > > > > > and display only the last names. Click Finish at this > > > > > > > > point, and you should > > > > > > > > > have a combo box that will go to the name selected. > > > > > > > > > > > > > > > > > > John Viescas, author > > > > > > > > > "Building Microsoft Access Applications" > > > > > > > > > "Microsoft Office Access 2003 Inside Out" > > > > > > > > > "Running Microsoft Access 2000" > > > > > > > > > "SQL Queries for Mere Mortals" > > > > > > > > > http://www.viescas.com/ > > > > > > > > > > > > > > > > > > > -----Original Message----- > > > > > > > > > > From: simonstravis [mailto:[EMAIL PROTECTED] > > > > > > > > > > Sent: Sunday, March 20, 2005 3:25 PM > > > > > > > > > > To: ms_access@yahoogroups.com > > > > > > > > > > Subject: [ms_access] Re: Please help on combo boxes. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > John, > > > > > > > > > > I just made a simple test database with one table > and one > > > > > > > > form. I made > > > > > > > > > > a table called tblemployee with the field > named employee > > > > > > > > and the data > > > > > > > > > > type text. I also have field name employeeid that is > > > > > > > > autonumber as the > > > > > > > > > > datatype and is also the primary key. I > then created the > > > > > > > > form named > > > > > > > > > > frmemployee; then I proceeded to enter some > entries as > > > > > > > > generic names > > > > > > > > > > of people. I then we back and made a box > wizard for the > > > > > > > > form to lookup > > > > > > > > > > the data and I still get the same message. Very > > > > frustrating. > > > > > > > > > > > > > > > > > > > > Is there somewhere on this site that people > can upload > > > > > > > > mdb files so > > > > > > > > > > people can look at exactly what you are > talking about? > > > > > > > > > > > > > > > > > > > > Travis Simons > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > --- In ms_access@yahoogroups.com, "John Viescas" > > > > > > > > <[EMAIL PROTECTED]> wrote: > > > > > > > > > > > Simon- > > > > > > > > > > > > > > > > > > > > > > What is the structure of the table(s) > involved? You > > > > > > > > should build a > > > > > > > > > > form to > > > > > > > > > > > edit the data and then use the Combo Box wizard to > > > > > > > > build the lookup > > > > > > > > > > for you. > > > > > > > > > > > Are you, perhaps, opening the database in > exclusive > > > > > > mode? That > > > > > > > > > > could also > > > > > > > > > > > be the problem. > > > > > > > > > > > > > > > > > > > > > > John Viescas, author > > > > > > > > > > > "Building Microsoft Access Applications" > > > > > > > > > > > "Microsoft Office Access 2003 Inside Out" > > > > > > > > > > > "Running Microsoft Access 2000" > > > > > > > > > > > "SQL Queries for Mere Mortals" > > > > > > > > > > > http://www.viescas.com/ > > > > > > > > > > > > > > > > > > > > > > > -----Original Message----- > > > > > > > > > > > > From: simonstravis [mailto:[EMAIL PROTECTED] > > > > > > > > > > > > Sent: Sunday, March 20, 2005 11:08 AM > > > > > > > > > > > > To: ms_access@yahoogroups.com > > > > > > > > > > > > Subject: [ms_access] Re: Please help on > combo boxes. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > John, > > > > > > > > > > > > Thank you for your suggestions. In fact > I, created a > > > > > > > > entire new > > > > > > > > > > > > database with just two fields and it is still > > > > doing the > > > > > > > > > > same thing. > > > > > > > > > > > > Should I check my structure of id keys? > > > > > > > > > > > > > > > > > > > > > > > > Group, > > > > > > > > > > > > The current application is to create a form that > > > > > > > > pulls all sales > > > > > > > > > > > > opportunities (or > > > > > > > > > > > > deals), that a sales rep has in the > main table (or > > > > > > > > query). I would > > > > > > > > > > > > like to be able to pull the form up and > > > > select the sales > > > > > > > > > > reps' name in > > > > > > > > > > > > combo box and it would pull all deals that > > > > the person in > > > > > > > > > > the combo box > > > > > > > > > > > > that was selected no matter the number of > > > > opportunities > > > > > > > > > > (or deals). > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > --- In ms_access@yahoogroups.com, > [EMAIL PROTECTED] wrote: > > > > > > > > > > > > > > > > > > > > > > > > > > Travis- > > > > > > > > > > > > > > > > > > > > > > > > > > I can think of only two reasons why the > > > > Wizard failed: > > > > > > > > > > > > > > > > > > > > > > > > > > 1) You had the table open in Design view > > > > with unsaved > > > > > > > > > > changes, so > > > > > > > > > > > > > the table is exclusively locked. > > > > > > > > > > > > > > > > > > > > > > > > > > 2) Your table is corrupt. > > > > > > > > > > > > > > > > > > > > > > > > > > Try the Wizard again. If it fails again, you > > > > > > might need to > > > > > > > > > > > > create a > > > > > > > > > > > > > new blank database and import all the > objects from > > > > > > > > the old one. > > > > > > > > > > > > > > > > > > > > > > > > > > John Viescas, author > > > > > > > > > > > > > "Building Microsoft Access Applications" > > > > > > > > > > > > > "Microsoft Office Access 2003 Inside Out" > > > > > > > > > > > > > "Running Microsoft Access 2000" > > > > > > > > > > > > > "SQL Queries for Mere Mortals" > > > > > > > > > > > > > http://www.viescas.com/ > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > a) What is the Record Source of > your form? (The > > > > > > > > SQL of the > > > > > > > > > > > > > > query or the > > > > > > > > > > > > > > > structure of the table) > > > > > > > > > > > > > > > > > > > > > > > > > > > I'm using the record source from > > > > > > > > > > > > > > the main table called "tblpipeline". > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > b) What is the VB code the Wizard > built? The > > > > > > > > wizard gave me > > > > > > > > > > > > > > an error so when I tried to create > it and said > > > > > > > > Data cannot be > > > > > > > > > > > > > > retrieved from the source you have > selected. You > > > > > > > > must select > > > > > > > > > > > > > > a different table or query to continue in > > > > the wizard. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > c) What is the Row Source (the SQL) of the > > > > > > > > combo box, and > > > > > > > > > > > > > > what is the bound > > > > > > > > > > > > > > > column? > > > > > > > > > > > > > > > > > > > > > > > > > > > the wizard failed. > > > > > > > > > > > > > > > > > > > > > > > > > > > > John, Thank you again! > > > > > > > > > > > > > > > > > > > > > > > > > > > > Travis Simons > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > --- In ms_access@yahoogroups.com, > "John Viescas" > > > > > > > > > > <[EMAIL PROTECTED]> wrote: > > > > > > > > > > > > > > a) What is the Record Source of your > > > > form? (The SQL > > > > > > > > > > of the query > > > > > > > > > > > > > or the > > > > > > > > > > > > > > structure of the table) > > > > > > > > > > > > > > > > > > > > > > > > > > > > b) What is the VB code the Wizard built? > > > > > > > > > > > > > > > > > > > > > > > > > > > > c) What is the Row Source (the SQL) of > > > > the combo box, > > > > > > > > > > and what is > > > > > > > > > > > > > the bound > > > > > > > > > > > > > > column? > > > > > > > > > > > > > > > > > > > > > > > > > > > > John Viescas, author > > > > > > > > > > > > > > "Building Microsoft Access Applications" > > > > > > > > > > > > > > "Microsoft Office Access 2003 Inside Out" > > > > > > > > > > > > > > "Running Microsoft Access 2000" > > > > > > > > > > > > > > "SQL Queries for Mere Mortals" > > > > > > > > > > > > > > http://www.viescas.com/ > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -----Original Message----- > > > > > > > > > > > > > > > From: simonstravis > [mailto:[EMAIL PROTECTED] > > > > > > > > > > > > > > > Sent: Saturday, March 19, 2005 9:48 PM > > > > > > > > > > > > > > > To: ms_access@yahoogroups.com > > > > > > > > > > > > > > > Subject: [ms_access] Please help on combo > boxes. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > When I open my form and create a combo > > > > to search on > > > > > > > > > > a value in > > > > > > > > > > > > > the > > > > > > > > > > > > > > > form I get the following error: > Data cannot be > > > > > > > > > > retrieved from > > > > > > > > > > > > > the > > > > > > > > > > > > > > > source you have selected. I receive this > > > > > > message when I > > > > > > > > > > > > create a > > > > > > > > > > > > > > > combo box under the combo box > wizard, then I > > > > > > > > select "Find a > > > > > > > > > > > > > record > > > > > > > > > > > > > > > on my Form based on the Value I > selected my > > > > > > combo box" > > > > > > > > > > > > (table or > > > > > > > > > > > > > > > query). I select the field that I want > > > > it to pull > > > > > > > > > > from, but I > > > > > > > > > > > > > get > > > > > > > > > > > > > > > the error. Data cannot be retrieved > > > > from the source > > > > > > > > > > you have > > > > > > > > > > > > > > > selected. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > > > > Travis Simons > > > > > > > > 512.388.5808 > > > > > > > > > > > > > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > Travis Simons > > > > 512.388.5808 > > > > > > > > > > > > > > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > > > -- > > Travis Simons > > 512.388.5808 > > > > > > > Yahoo! Groups Links > > > > > > Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
