Search results

Worked perfectly!!! Thanks a million times!

They don't use the log until the end of the day when they fill it out and submit it. The times are the same every day. There is no variation. They can't use the now() value because that would give them a time of about 3:45 pm when they are filling out the time sheet. Does that make sense?

In the database I'm working on, the user has a daily log on a continuous form that encompasses some routine activities. For example at 6am every morning they report to work and at 4 4pm every evening they check out; at noon they eat lunch etc. I want to have a button that autopopulates the...

Thanks Michael! Adding the reference in the library did the trick! Here is the final working code that sends the information on a form in html email format and attaches any attachments! Dim oFilesys, oTxtStream As Object Dim txtHTML As String Dim appOutLook As Outlook.Application Dim...

I needed a button to send information from the text fields in a form as the body of an email, and then attach the attachments that are in the attachment field "IssuePics." I have read hours of forums and found the code that turns the text fields into the body of the email, and I thought I found...

I was referring to your answer and nevermind youre right. I can just use the filter in the form instead of including it in a query.

Thanks that worked perfectly but how would I enter that as criteria in a query?

Does that mean there's no way to filter it?

Yeah the date and time are stored with format mm/dd/yy hh:nn am/pm

I have a bound continuous form that has a form filter on load that filters the control workerid that is set to "WorkerID = 2." I want to have a button that filters another control (StartTime) by today's date while still maintaining the initial filter. I thought the code would be me.filter...

It works in the sample but when I copy it into the real DB it gives me an error that says Variable not defined then in the debug sends me to the line Set mOlCalendar = mOlApp.GetNamespace("MAPI").GetDefaultFolder(olFolderCalendar) and hightlights (olFolderCalendar).

Do you know how to keep it from adding appointments that it has already added?

I wish I could click that Thank you button a million times! Thank you SO much StarGrabber! It works like a charm!

Sorry about that. Here is one with actual data.

Here's a sample attached so you can see the error.

I don't understand what you mean by recordset values.

@StarGrabber: I don't understand what your using as the record source for the form. Currently the record source is as follows: SELECT * FROM ScheduleT WHERE BeginDateTime >= #3/30/2013#; I changed the code to fit your model to the following: On Error GoTo ErrHandler Dim rs As...

I have a continuous form for scheduling that I want to be able to add to the outlook calendar so I created a button with the following code: (isappthere is a boolean function) Dim myReply myReply = MsgBox("Do you wish to add this appointment to your Outlook Calender", vbYesNo) If myReply =...

Nevermind. I figured it out. Something was spelled wrong! Thanks for your help!!!

Thanks. I replaced the code with your suggestions but then I get an error in the Stationcombo dlookup line that says: Run-time error '3075'" Syntax error (missing operator) in query expression 'StationID='.