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...
56073
Bill Mosca
wrmosca
Jan 1, 2008 7:50 pm
Hi Sara I'm glad some good came of it. Do you get the error if you open a new database and create a new form from scratch? Bill From:...
56074
Brett Collings
sumbrett
Jan 1, 2008 8:58 pm
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 ...
56075
Sara
sarakay123
Jan 1, 2008 11:52 pm
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...
56076
Bill Mosca
wrmosca
Jan 2, 2008 1:42 am
Hi Sara Are you running on Windows Vista? If so, take a look at the response from nobugz in this thread: ...
56077
Bill Mosca
wrmosca
Jan 2, 2008 1:44 am
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:...
56078
toukey1
Jan 2, 2008 2:00 am
Hi Brett, The Colours table consists of: ID (autonumber) Colour (text) The Client table consists of: Client_no (autonumber) name (text) address (text) ...
56079
toukey1
Jan 2, 2008 2:04 am
Hi John, Here are the answers to your questions: 1) Control Source - blank ... [colour].[Colour] FROM colour; ... of the ... toukey1 ... jersey ... name, ... ...
56080
toukey1
Jan 2, 2008 2:05 am
Thanks Clive. ... the ... the...
56081
hunterpaw
Jan 2, 2008 6:25 am
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 ...
56082
John Viescas
jlviescas
Jan 2, 2008 6:46 am
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: ...
56083
John Viescas
jlviescas
Jan 2, 2008 6:57 am
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 ...
56084
hunterpaw
Jan 2, 2008 8:59 am
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...
56085
John Viescas
jlviescas
Jan 2, 2008 9:12 am
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...
56086
toukey1
Jan 2, 2008 1:26 pm
Thanks John. I will give that a try. Toukey ... make "Colour" the ... property either ... toukey1 ... the ... the...
56087
toukey1
Jan 2, 2008 2:24 pm
Hi John, Your suggestions below worked. Thanks a million. Regards Toukey ... make "Colour" the ... property either ... toukey1 ... the ... the...
56088
MS_Access_Professiona...
Jan 2, 2008 2:25 pm
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 :...
56089
A.D.Tejpal
adt_h
Jan 2, 2008 2:27 pm
Jim, My sample db named Query_DateSpansInDateRange.zip, uploaded to Samples folder in Files section, demonstrates the approach outlined in my earlier post...
56090
PENKIN Bernhard T
bernie_penkin
Jan 2, 2008 3:25 pm
<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...
56091
John Viescas
jlviescas
Jan 2, 2008 3:39 pm
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...
56092
PENKIN Bernhard T
bernie_penkin
Jan 2, 2008 4:01 pm
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....
56093
John Viescas
jlviescas
Jan 2, 2008 4:40 pm
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...
56094
PENKIN Bernhard T
bernie_penkin
Jan 2, 2008 4:54 pm
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,...
56095
Paul Cook-Giles
barongiles
Jan 2, 2008 4:57 pm
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...
56096
John Viescas
jlviescas
Jan 2, 2008 5:18 pm
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 ...
56097
John Viescas
jlviescas
Jan 2, 2008 5:25 pm
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...
56098
PENKIN Bernhard T
bernie_penkin
Jan 2, 2008 5:31 pm
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...
56099
runuphillracing
Jan 2, 2008 5:38 pm
I'm having problems with a combo box. I've uploaded a file to the 2_AssistanceNeeded folder, OrderSample.zip The combo boxes are on the form...
56100
John Viescas
jlviescas
Jan 2, 2008 5:56 pm
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 ...
56101
PENKIN Bernhard T
bernie_penkin
Jan 2, 2008 6:15 pm
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...
