Recent content by kpaull

Found it being created dynamically via a query. Thanks all.

Using MS Access 2013, working on a clients database. I am still a junior at this ;) There is a temporary table which a query is running against. I want to determine what is actually creating this temp table? Any way to determine that? Thanks,

Okay, thanks for this guidance! See my responses below: 1. DT>0, RT>0, OT>0 Set Me.txtbox_TotalTime = "RT: " & txtbox_RT & "OT: " & txtbox_RT & "DT: " & txtbox_DT 2. DT>0, RT>0, OT NOT >0 Set Me.txtbox_TotalTime = "RT: " & txtbox_RT & "DT: " & txtbox_DT 3. DT>0, RT NOT >0, OT...

A very junior programmer here. Needing some help to get the desired results with my code: What I need my code to do: 1) I want VBA code to examine the value of three textbox controls: txtbox_RT , txtbox_OT, txtbox_DT "Regular Time, Over Time, and Double Time" 2) Then based on each the values...

Can anyone help me, I am experiencing the same thing with my code, I have users on Outlook 2003 and 2007 and for the 2003 users it blows up. Here is my code: Sub CreateAppointment() Dim myOlApp As Outlook.Application Dim myItem As Outlook.AppointmentItem Set myOlApp =...

I have raw data in .csv files which I import into Access daily. The date field contains "5:44pm MON FEB 23, 2009" or "10:01am TUE FEB 1, 2009" (notice the single and double position day number). I cannot sort using this date. So my options are to modify the .csv files with vba (pre import) or...