Hi Bill, Thanks for your reply. I downloaded and installed the updates, and compacted/repaired the database, but am still getting the "ActiveX component can't...
Hi Tourkey Congrats on using a query and basing the form on it, most struggle with that. You didn't state your table field structure but would I be right in ...
Hi Bill, Yes. I created a new database and the ActiveX error message occurred when I tried to create a list box on a form. But before that, also in the new...
Ah! I bet that is the issue. What are the libraries listed in the code window References? Open the code window and click on Tools>References. Bill From:...
Hi Brett, The Colours table consists of: ID (autonumber) Colour (text) The Client table consists of: Client_no (autonumber) name (text) address (text) ...
Hi John, Here are the answers to your questions: 1) Control Source - blank ... [colour].[Colour] FROM colour; ... of the ... toukey1 ... jersey ... name, ... ...
Happy New Year to All! I have created my first add-in and it works quite well except for one thing. I have been unable to get a list of reports to fill a ...
Toukey- In an earlier post, you said your tables look like this: The Colours table consists of: ID (autonumber) Colour (text) The Client table consists of: ...
Patrick- When you run a query in an add-in in a form that's in the add-in, I believe the context of the engine is the code database. You might have to do ...
Hi John, You are amazing! I tried your query and it works just great! I learned something. I did not know you could use another database name in a query. I...
Pat- Yeah, it's tricky doing bound forms or reports in an add-in or library database. That's one of the obscure uses for the IN clause in Access SQL. Nope, my...
Hello, This email message is a notification to let you know that a file has been uploaded to the Files area of the MS_Access_Professionals group. File :...
MS_Access_Professiona...
Jan 2, 2008 2:25 pm
56089
Jim, My sample db named Query_DateSpansInDateRange.zip, uploaded to Samples folder in Files section, demonstrates the approach outlined in my earlier post...
<http://geo.yahoo.com/serv?s=97359714/grpId=6448978/grpspId=1705115370/m sgId=56020/stime=1198869285/nc1=3848627/nc2=4670553/nc3=4990216> Happy New Year...
Bernhard- Does the code in COMMETS_Click work? I notice you're using Forms!User there instead of Me. Is "USERID" a control on the form, or is it a field in...
Hello John, It is a comment box that we enter people on vacation and then clear it when they come back. The data is saved to a table for historical purposes....
OK, Bernie it is! What is the name of the form? Does the form have a Recordset? Is there a control called USERID on the form? Help me out here - I feel a...
John, I uploaded a copy of the subform and table to the groups Assistance Needed folder. It is called Vacations. I was able to isolate the form and table,...
I'm still trying to set a PassThrough query's ODBCConnectString property using code; Access Help on "ODBCConnectStr Property" says "You can set this property...
Paul- If Help says it is a property of a QueryDef object, then you don't need to open the query in the UI and do the funky RunCommand. You should be able to ...
Bernie- You do indeed have a control on the form called USERID, and the Control Source is a field named Userid. But here is your Record Source: SELECT...
If I remember correctly to designer of this form told me the USERID some how linked to the user login id on the particular computer they were at for that...
Bernie- No, it does not. The form as designed basically has an error - there's a control referencing a non-existent field. Is there a UserId in the VACATION ...
John, I took a look at the other similar forms. Found that there is a user id section, but don't know where it comes from. I will continue to poke around to...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
