Search results

Please anybody?

Hi In Outlook I would like to trigger the Attach file window (Paperclip) to a set folder location based on the value in the templates .oft UserDefinedField called JID (JobID) Each JID (JobID ) has a folder for documents in the server e.g for JID12345 = path Y:\JobFolders\JID12345 I have...

Anybody? 10 downloads and still not a bite

Hi I wanted to replicate google Screencapture app that you can get for the Chrome browser Idea was to have 3 buttons on the webbrowsers frm 1. Copy & Save Visible area in Webbrowser 2. Copy & Save Highlighted area in Webbrowser 3. Copy & Save Full page in Webbrowser Unfortunately practical...

Finally figured it out changed TestJID for Matched_JID When you have the time Ha ha… could you re post the code with 'comments as I find it’s the best way to learn what’s going on in the code Thanks again Stewart

Ok manual it is then. Or i could just fire up my old code if Matched JID = O Thanks again for all your help Stewart

So close….....Works great when the email contains a Conf No but when it’s a email that contains a JID00001 it just adds 0 values to the Matched JID & Matched JAID

I had already changed the Me.TestJID = lngJobID to Me.Matched JID = lngJobID What i was looking for was the Me.Matched JAID to be populated with the Conf No`s JAID (JobActionID) from the tbl_JobActions As an example if you look at the MessageID 7 (3rd in the set) you will see JID=1 JAID=5...

Thanks again for the update Did you have any luck with as well as the JID in the Matched JID

Nate....Ops sorry i posted out of sync earlier and ...cheers for the "never mind" update When i changed the Me.TestJID over to the Me.Matched JID i was trying to figure out what to change/add to also 1. Get the code to check the Subject field for results 2. When the email has a Conf No in it...

Can I check I have been using the frm_DummyData_MailMessages which is based on the sample data tblMailMessagesDummyData It contains separate records for testing all the variables I could think of 1st JID in Subject 2nd JID in body 3rd Conf No in Subject 4th Conf No in Body Etc Also you will...

Looks promising…but when I replaced the code nothing happened. No errors though. Could you upload the DB you got working and I can check what I have done wrong Cheers Stewart

The quickest way is if you look at the relationships in the qry_Supplier to Client Switchboard Correct the email with JobID “JID00001” examples will more likely be from a Client The emails containing Conf No will more likely be from a supplier Correct the Conf No is stored in the...

Hi nschroeder Sorry for my poor explanation i meant to clarify the SupplierConfirmationNo as a fieldname won’t appear but its value will. The sample data has a SupplierConfirmationNo value of 1A2B3C4 in the main tbls to “match” against the imported email tbl which has a sample record in the...

Hi I have got to the Grrrrr:banghead: stage. I have been constructing an import routine for emails. I have worked through all the code to get the email to table etc. But I am trying to get my DB to “Read & Match ” two DB fields that will appear in the imported email Subject & or Body...

Hi Paul, Thanks for the code i will have a go Cheers Stewart

Hi After finding r.Harrison amazing postcode lookup example in the Sample databases section i imported the frm into my db. On my frm_NewClient added a button to open the postcode lookup frm. I am now stuck with the code for splitting up the address into my fields and adding them to my...

Hi We have a special reduced rate that a client must prepay 12weeks before or sooner if a date is put in the [OverRideDate] field I have been trying to construct a Query / If statement or should I use case statement to work out the actual payment date. Taking in to consideration all our funny...

Hello and thanks for the quick reply works a dream thanks again

Hi First timer question After searching for Nemours combinations I am now asking for some help I have tried combinations to get a expression to give me a list of bookings staying tonight The fields in the table I use to store the Start & End date of the booking are below [CheckInDate]...