Search results

Thanks, that works too. But I have discovered a minor problem. As the Where condition is used, it opens a filtered set of records, and displays nothing before today's date. No surprise here, that's what I told it to do. I was looking at your code for having all records displayed. Where would I...

Thanks Paul. I missed that. I moved it to the Where Condition spot, and it worked perfectly. Thanks for the help.

I put in the delimiters for the date field, but it still only opens to the first record in the database. See updated code below: Private Sub btnOpenOrders_Click() On Error GoTo Err_btnOpenOrders_Click DoCmd.OpenForm "frmOrders", acNormal, , , , acWindowNormal, "[ServiceDate] >= #" &...

The Orders form is opened from the main menu (navigation) form. I have a hidden date field that is set to today's date (in red below), and I refer to it it the command button that opens the orders form. See code below: Private Sub btnOpenOrders_Click() On Error GoTo Err_btnOpenOrders_Click...

I have built a database for my service business, in which I enter all the service orders as they come in. They come in sometimes up to two months in advance of the actual date of service. When I open the form, is there a way I can open it up to today's service date, or in lieu of no scheduled...

Thanks for the quick response Mark. First off the reason I highlighted that line wasn't to say that it caused the error, but to question if it should even be there. Personally, I think the SQL statement is causing the error, and I am trying my damdest to figure out why. It works fine when I run...

Thanks for the help. When my form is open to a specific client work order, and I run the query, it works fine, and returns the exact records I want for that order in query view. It tests absolutely fine every time I try it. However, it doesn't work when I try to add an appointment to the Outlook...

Thanks Mark. I found a small problem and changed it. Now I get the error message "Syntax error in JOIN operation." I've highlighted the changes I made in red below: Private Sub btnCreateAppointment_Click() On Error GoTo Err_btnCreateAppointment_Click 'First Save the Current Record...

I have tried copying your SQL statement exactly, and I'm getting a new error message saying "Too few parameters. Expected 2.". Here is the code I am using: Private Sub btnCreateAppointment_Click() On Error GoTo Err_btnCreateAppointment_Click 'First Save the Current Record...

I cleaned up the code a little bit, but still get the same error message. Private Sub btnCreateAppointment_Click() On Error GoTo Err_btnCreateAppointment_Click 'First Save the Current Record DoCmd.RunCommand acCmdSaveRecord 'Exit the procedure if the appointment has already...

Thanks stopher. I did that, but now I get a message stating " Syntax error (missing operator) in query expression". I know the answer is staring me in the face, but I can't seem to get it to work. Here's my code: Private Sub btnCreateAppointment_Click() On Error GoTo...

Hi Mark, I have tried the OpenRecordset suggestion. Here is my code: Private Sub btnCreateAppointment_Click() On Error GoTo Err_btnCreateAppointment_Click 'First Save the Current Record DoCmd.RunCommand acCmdSaveRecord 'Exit the procedure if the appointment has already...

Cool. Thanks. I'm going to play with it for a while and see what I can do. I really appreciate the help. Hopefully your Canucks can pull it out with Calgary. (At least your team made the playoffs!) Wayne

Thanks Mark. Is there an existing thread somewhere in the archive that demonstrates the use of it?

I'm trying to put multiple records of data from a subform in a single e-mail, and my Outlook calendar. I have a contracting business, and on my Orders form (which details a single client), I have a sub-form that lists all the items to be done at that client's home (a different record for each...

Welcome to the forum Ian, and thank you for your service (from a former military man). Hope you find what you're looking for. Wayne

Welcome to the forum.

Hi Sandy, Welcome to the forum. Hope you find the help you're looking for. Wayne

Hi Simon, Welcome to the forum. Wayne

Hi Ben, Welcome to the forum. I hope you find what you're looking for here. Hopefully, you can pass on what you learn to others along the way. Wayne