Search results

I backup my MS Access 2007 database every night. When I went to open the copy I backed up on Tuesday night, all my macros, table and forms did not show up! I copied over the macros, tables and forms from my Monday night backup and the program started running again. Unfortunately, when I copied...

The issue only started AFTER I used the Compact/Repair feature of Access. The discussion above triggered an idea on my part and sure enough, for some reason the sub-form on the right was filtering, see attached (issue-w-filter.jpg). Once I removed the "filter", see...

The (B4-Filter.jpg) attached is a screen shot of my main form with 2 sub-forms, one on the bottom left and one on bottom right. This issue I am having has to do with the bottom right sub-form, under "Dodge Status Notes Shown Below" When I work with the data in the main form, many times I...

Thank you very much! That did it

I have a number of quotations that I would like to follow up on and I want to base it on all quotations from the date the query is run, going back one year. I know I can manually set the query up to input a date range, but I'd like the query to run and automatically go back one year. For...

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...