Search results

Holy rusted metal, Batman! This nailed it! Thank you so Much!!!! This kicked my ass today. Thank you.

I realized that the Notes and Notes date were transposed. Here is the final one, This one still give me an error that it is missing an operator: strSQL = "INSERT INTO ClientNotes(Notes, NotesDate, ClientID,[User Updated], [Date Modified], [Time Modified]) VALUES(" & Me.Home_Visit_Notes &...

Yes. I just saw. Thank you. Here is the final one. THis gives me a syntax error on date? strSQL = "INSERT INTO ClientNotes(Notes, NotesDate, ClientID,[User Updated], [Date Modified], [Time Modified]) VALUES(" & Format(Me.Home_Visit_Date, "dd-mm-yyyy") & "#," & Me.Home_Visit_Notes & "'," &...

Here is where i am at now: strSQL = "INSERT INTO ClientNotes(Notes) VALUES('" & Format(Me.Home_Visit_Notes, "'") & "')" And "INSERT INTO ClientNotes(NotesDate) VALUES('" & Format(Me.Home_Visit_Date, "yyyy-mm-dd") & "#)" And "INSERT INTO ClientNotes(ClientID) VALUES('" & Me.ClientID & "')" And...

Yes. When I click the save it should save it to CLientNotes, I am using the format you're showing me but im just not getting it correctly. I dont know the formatting options for these fields very well nor how to correctly code it. Im just not getting it.

Ive tried this and this is the error i get: Run-Time error '3075' Syntax error (missing operator) in query expression 'visit done-evf'. That last part is something in the notes field for the current record.

Ive been trying the following: strSQL = "INSERT INTO ClientNotes(Notes) VALUES('" & Me.Home_Visit_Notes & "')" And "INSERT INTO ClientNotes(NotesDate) VALUES('" & Me.Home_Visit_Date & "')" And "INSERT INTO ClientNotes(ClientID) VALUES('" & Me.ClientID & "')" And "INSERT INTO ClientNotes('User...

one last request? whats the format of this code for adding multiple values to multiple fields? I keep getting a syntax error and im sure its because im not coding it correctly.

How would i do an append query on the cmdsave button click?

Users need to see when homevisits are completed for clients in the clientnotes. The person who was inputting the homevisits into the homevisits form had to go to the client form and manually enter a new note, with the same exact information, into clientnotes. Its redundant. I can update the...

Hello All, I have a simple form with save / cancel buttons and I want to run an if statement (or something) on click of the save button that will save the entry into the table the form is used for but also create an entry into a different table that will copy certain fields into specific fields...

This works perfectly. I could live with closing the form each time but as we all know it comes down to how the end-user will work with the database. They need to have the forms open constantly and this helps take some stress off them when they're using them. I really appreciate all the help.

What would i need to add to the code to get the double-click action to simply take you to the record IF the Form is already open?

@theDBguy What would i need to add to the code to get the double-click action to simply take you to the record IF the Form is already open?

@thedbGuy - Thank you, this worked perfectly. You're a lifesaver. Ive been messing with settings all morning. I appreciate the help.

Thank you. Any chance you could give me example of what that code would look like? The forms are Clients and Employees and the respective fields are workerID and employeeID. Im not sure where to start for this

Hello all, I am using the on dblclick event procedure (see below) on my "Clients" form to open the "employees" form with the correct record from a field that uses a 2 column dropdown list that displays the employee name but has the employeeID in the second column. So far, everything works as...

Hello All, I have a question in regards to a macro that runs a form open command: The macro opens a form that executes a host of commands on open. I want to add an IF statement to the Macro but im not sure if it should be in the Macro or the Form Open Actions I would like for the Macro/Form...

bump... no one has some suggestions for me?

Hello guys, Im kind of stuck with an operation I'm trying to make happen in the On Current event of a form I have: So far what I have, that is functioning exactly the way i need, is the following [ Private Sub Form_Current() On Error Resume Next Me![ImageFrame].picture = Me![picture]...