Search results

Private Sub Command16_Click() Dim strSQL As String strSQL = "Update Advisory_Messages" _ & " Set Status = 'Assigned'" _ & " Where [Message Number] =" & Me.Combo14 'Dim olApp As Outlook.Application ' Dim objMail As Outlook.MailItem ' Set olApp =...

Update Advisory_Messages Set Status = "Assigned" Where Message Number = Me.Combo14 The result of the code above is "Compile Error: Variable not defined."

Hey, thanks for replying. my internet is stupid slow right now. So I have a form, I want to click a button, and you're right, I should have taken that line out because I am not creating a new value because it would have already been entered. I also have my columns named appropriately now and...

DoCmd.GoToRecord , , acNewRec Update Advisory_Messages Set Column7 = "Assigned" Where Column2 = Me.Combo14 So the code above is what i have in there right now and i am getting an error that states "Compile Error. Variable not Defined" and has the table name highlighted. Is it a Syntax Error?

I think that worked. thank you both very much for how to make this query work.

ok. Thank you. So what would the correct syntax be to run the query?

Thank you for explaining it to me. I have gone through and re-structured my database to one table and then put a status button in. I want to run an update query so that I can change the status from "entered" to "assigned" but I can't seem to get the syntax right for running the update query...

Private Sub Command12_Click() DoCmd.GoToRecord , , acNewRec Dim olApp As Outlook.Application Dim objMail As Outlook.MailItem Set olApp = Outlook.Application Set objMail = olApp.CreateItem(olMailItem) With objMail .Subject = "Test Message" .Body = "Body...

The problem I had was that Outlook wasn't checked under references. I still need help though getting the email to be sent though, It compiles though and asks if Access is allowed to use Outlook though which is more than where I was at. Still gotta get that email in there though. So I ran the...

I realize that I have an incorrect design but I really don't want to go back to square one. Really though, how important is it that I not move records?

So this would be for moving a record, I have the records coming up properly on my forms but as soon as I click submit to right the other table, i need it to delete from the table it pulled the information from. I figured that a flag would solve it but I am not so sure if that is the case anymore.

Ok, so what if I wanted to delete an individual record with the flag of, but not all of them. How can I make it so that a single entry is cleared and not all of them?

Is there a way to have a window pop up to confirm whether or not the data is correct that the user is inputting? like an "are you sure you want to write this?"

I received a compile error for "User-defined type not defined."

thank you. that fixed it!

no. outlook is not open. I'm assuming I will need to open it though to be able to send the email.

does that code delete the whole record?

I have entries in a column named flag that I am using as a "flag" ie 0, 1 or 2. I need to know how to do a query to delete the one's. Any help would be greatly appreciated.

Also, I am not sure if this matters but it's not entirely for trouble tickets. It's for security patches applied to computer systems. The person I'm doing this for has multiple computer systems that are all different flavors. So it is to assign personnel to do the security patch and track what's...

Ok. So if I added a column for complete or incomplete, Then I would need to adjust one of my other forms. is there a way that I could have a button input the value as complete? I'm trying to minimize as much user interaction as possible. I think I may need to redesign my database a little bit...