Search results

yea this works. thanks

That appears to have worked, thanks.

When i do Null as [fld_Date_trec] the entire column is blank, the data from table 2 doesnt show up.

So i have 2 Queries i'm combining into 1 with a Union Query. Table 2 has a date field that Table 1 doesn't and so it needs to be created/defined in table 1 which i have done like this: ""as [fld_Date_trec] But this is making that column a text field and so the dates from table 2 don't act as...

Hi, I'm struggling with this issue also. I'm trying to open a form using 2 variable where conditions and keep getting type mismatch errors. CourseMOD = "[fld_Name_course] = '" & Course & "'" PersIDMOD = "[fld_PersID_trec] = '" & PersID & "'" strCriteria = CourseMOD & " And " &...

How do make it where "course 1" is the definition "ColHead"? ie: ColHead = "Course 1" passcount = dcount("1", "ThetableName", "course =ColHead And fld_Name_stat = 'Pass'") I tried but cant seem to figure out correct syntax

so i have a Crosstab Query [qryTraining-Crosstab] to track who has done what courses. the column headings are Course Names..... course 1, course 2, course 3, etc the row headings are the people name [Fname] .... jim, john, jane, etc... and the values are there course status [fld_Name_stat]...

Yea sorry it works, thank you.

so i can use sendkeys as a workaround to get the date picker to open? if so, how? (never used send keys). if ive misunderstood and a custom date picker is the only way then thanks for your help but i wont bother. its nice to have but not worth "that much" effort.

Heres a basic example of the issue. open frmpersonnel_sub_history, code works fine. open frmpersonnel where "frmpersonnel_sub_history" is embedded as a subform and it doesnt.

Yes, when the field has focus the datepicker icon is floating to the right as normal and work as expected. Edit: Actually its not working properly, let me get back you when I sort this out.

Yea same error.

yea fld_date_trec is the date field and has no format applied. The code works fine when the form is opened on its own, but fails when opened as a subform.

im using the code: Private Sub fld_Date_trec_MouseUp(Button As Integer, Shift As Integer, X As Single, Y As Single) DoCmd.RunCommand acCmdShowDatePicker End Sub this code is on the subform. Main form is "frmPersonnel" Subform Control Name is "SubFrmHistory" Subform name is...

This works great on normal forms, but doesnt seem to work when run from a subform (subform is a continuous form). any idea why? "Run-time error '2046': command or action 'ShowDatePicker' isnt available now"