Recent content by Kenshiro

I'm having the exact same issue. My Calendar Control 11.0 displays perfectly on my screen, but on my team member's screen it is not displaying correctly. She can't even see the days of the week, they are not visible. Is it a graphics card problem? We both have Access 2003, so it's not a...

I realized that I didn't need a .MoveNext in the code, since there is no record there and a new one will get created. The code works now. Thanks for all of your help!

It worked!! Thanks a million! Now the code gets passed that line, but breaks at the ".MoveNext" line in this code section: With rstAnswers .AddNew 'NOTE: [QuestionID] is a field in two tables --...

Ok, found the culprit line: qdf.Parameters(1).Value = Forms!frmMainMenuNew!txtAuditTool What I'm wanting to do here is to add a parameter to my SQL querie's "AuditToolName" field. The parameter is whatever value is in the textbox: "txtAuditTool" that's on the frmMainMenuNew form (which is the...

Great tips, I'll give the debugger a try. Thanks lagbolt...brb.

Nope, I just get an "OK" in the dialog error.

Here's some more background on what the app should do: Basically, I'm creating an Audit database where a users from different Facilities will be filling out their own Audit Forms. Each audit form will point to one record in the table called tblAudit. The new tblAudit record is created when...

Thanks for the tip! I'm rather new to VBA coding so any help is appreciated :) I believe the error is occurring at this line: Set rstQuestions = qdf.OpenRecordset(dbOpenDynaset) It seems as though the code may be having a difficult time passing the value in...

Hi All, I'm new to the forums, and have a problem with some VBA code in one of my Access 2003 databases. I'm getting the following error when running code behind a command button on a form: "Item not found in this collection". I suspect it has something to do with parameters in the query I'm...