Search results

Unfortunately, I started developing this program back in the early 2000's when I was just a "rookie" and didn't realize all the issues this would cause me in the future. I do have a few "work-arounds" like this to keep things working relatively smoothly. Now if I only had about 1,000 hours...

I previously had an issue using a button to open a form when the Customer name had an "&" special character in it's name, i.e. Jones & Sons. I solved that by writing following code: stLinkCriteria = "[ EUContact]=" & Chr(34) & Me![ EUContact] & Chr(34) I have run into the same issue...

Thank you for the suggestion. I will give it a try.

Currently when I go to save a report in (.pdf) form to email out, the default file name to "save as" is always: "rpt_SL_Job_Notify.pdf". This is the name of the underlying report I created. (see attached: Save_Document-1.jpg) What I would like to have happen is to have the default file name...

Just as a follow up: I modified the Code to read: DELETE [1Dodge Download Notes T].* FROM [1Dodge Download Notes T] LEFT JOIN specjobs ON [1Dodge Download Notes T].DNJTNo=specjobs.JobTrackNo WHERE [specjobs].JobTrackNo Is Null; Once I added ".* " after DELETE [1Dodge Download Notes T] the...

I still get the same error msg :"Specify the table containing the records you want to delete". Forgive my ignorance but I do not understand your second suggestion: "If that still doesn't work, you would need to check only with exists in". Could you expand on that further? Thank you.

Thank you for your suggestion. YES, I do want to delete any record from [1Dodge Download Notes T] that does not have a matching record in [specjobs] I inserted your above code and still got the same error msg: "Specify the table containing the records you want to delete". Any other...

Please see attached (jpg's). One shows the query code which when run displays the records in table [1Dodge Download Note T] that do NOT have a matching record in table [specjobs]. I assumed I could just convert this query to a DELETE query and it would DELETE the records that were pulled up...

BINGO! THAT WAS IT!! My link criteria for the report was different than the form link criteria! THANK YOU SOOOOOOO MUCH FOR YOUR HELP!! :D:):)

The code for the form and the report definitely are NOT the same...I'll give that a try and let you know. Thank you! :)

It does but I am now getting the attached error msg....does this give you a better idea of what the issue is? thx for your patience... :)

I tried the only suggestion I received and it didn't work.... :(

Tried your suggestion and the report opened, but it was blank, no data at all. :( Before I added the code you suggested, the report opened but showed ALL contacts data.... very frustrating....:banghead: Thank you for your suggestion though! :)

Perhaps you would be kind enough to show me how I should have created the filter string AND then how I should use it? I would greatly appreciate you help on this....... :) Thank you, Mark

Sorry for the lengthy description but I hope to make this issue I am having as clear as possible. I have a report that I have developed which is associated with a contact's name on an "AIA Firm Contact form". The only way I can currently get the report to open and only show that contact's info...

It worked! Thank you very much for your all your help and your patience! :)

Please excuse my ignorance as I am learning as I go along..... Here is the code I put in the Event Tab/On Load Job Quote Form10-2005-MKD.OrderBy=[specjobs].[Rev_Rept_Date] DESC I have attached the error code I am getting.....I guess I don't understand what "Me.Orderby" represents...

Same thing I describe above....it reopens using the last Sort I performed on the form............

Sorry, I didn't understand your first question....here is the code used to close the form: Private Sub CloseJobs_Click() On Error GoTo Err_CloseJobs_Click DoCmd.Close Exit_CloseJobs_Click: Exit Sub Err_CloseJobs_Click: MsgBox Err.Description Resume Exit_CloseJobs_Click...

Please open the (sortOrder1.jpg) I attached and that will show you the "Order By" code I put in the "Order by" field of this forms Property Box....