Search results

Still not working keeps emails 1 or 2 than doesnt do it any more. I will check the breakpoint.... thing.... Thanks

Ok I cleaned up the if statment but still leaves me with the same problem. With the below code it will only let me email one item corretly. It seems like I want to create a loop but it still not working Private Sub Received_Request_Click() On Error GoTo Err_Received_Request_Click If...

Well I only want to email updates if a Request is True so that is why I put the email part in the middle of the if statement. But I changed my IF statement to: This now doesn't give me a email now. So I assume I was on the right track with putting the email code in the middle of the if...

Update Just to update if I am not making sense on my issue. Attach is a snapshot of the form. Basically everytime you check mark a milestone it will automate the date and than send a email. If approved or cancelled it goes back to the form and waits for the next button.

I am having issues how my code is working. What I am looking to do is on click of Received Request to auto the date into Received Date (Works Fine) after that email a text message with my updates (layout works fine). Sends first one with no issue. The email box closes and I am again back to...

Thanks works great. Great to know the secert words.

Is it possible to create a automatic email to not have a object to send. I am using Docmd.SendObject is there a command that if you only want to send To; Subject; and MessageText Current code Dim stDocName As String stDocName = "xxx" DoCmd.SendObject objecttype:=acSendReport...

Dude you rock... Somethingk simple I get to go to bed.... Yes thanks alot

Dont mean to be updating but i made a quick example. Any help appreciated.

Any help will appreciated. Table tblAll Country City Cost Cost2 Inside Form have pull down. cboCountry cboCity Then automate Cost into field txtItemDesc and Cost2 into Field txtItemDesc Code: Private Sub cboCity_AfterUpdate() Me.txtItemDesc = DLookup("[Cost]", "tblAll", "[City] ='" & _...

There are 2 thinks I have tried but must not be writing correctly Current Code Code: Private Sub cboCity_AfterUpdate() Me.txtItemDesc = DLookup("[Cost]", "tblAll", "[City]&[Country] ='" & _ [Forms]![frmlAdditions]![cboCity] & "'") Me.txtItemDesc2 = DLookup("[Cost2]", "tblAll"...

Any help will appreciated. Table tblAll Country City Cost Cost2 Inside Form have pull down. cboCountry cboCity Then automate Cost into field txtItemDesc and Cost2 txtItemDesc Code: Private Sub cboCity_AfterUpdate() Me.txtItemDesc = DLookup("[Cost]", "tblAll", "[City] ='" & _...

thanks Thanks I have been looking to export the outlook but it doesnt accept the body.. where all the data is.. So I will search for TransferSpreadsheet and see if this works Thanks and happy holiday.

Than if subform is not the best option what would you suggest. Because Simply put for 1 ticket there can be 150 records. I than have releationship that equal the Circuit ID gives me the address and additional information. The data comes from a email. I thought the easiest way is to copy into...

and not able to get it to work. Attached is the form I want to give the group a easy way to paste circuit IDs from Excel into a subform that will tie to the ticket as listed above. I have the releationship of ticket number assigned to the above ticket. Problem.... When i paste the numbers...

Between circuits in the same region. Here is what I need to do, if anyone has any direction or even links to samples that would be great. I have been searching and not coming up with what I am looking for. Basically I need to find the data circuits that are within a 10 mile radius of the...

Figure it out...

2 weeks ago I lock down the Access back screen (This is not the Switchboard or the Database) so that it could not be Min or Max or Closed. So the top bar is locked down. Does anyone know where I might have found the changes to make this completed. I need to reverse the MIN and MAX to be...

ghudson Thanks alot. I have looked at the sample and that is exactly what I wanted. That is all I needed. Much appreciated.

To take the assumuntion that I have not searched before posting would be incorrect. I have spent about 2 hours searching and trying most of the options. Learn some new stuff. But of course not what I wanted. So if can give me a title to search I will do that. But the 2 common post Have...