Experienced that too but it's working now. Just received an email from IT. Apparently there were some reported issues with a windows update in August (about the same time we started having problems) and MS Access using VBA. IT is going to install this new update. Fingers crossed.
Strange thing...
It's a split database. Can you expand on the FE isn't being correctly distributed?
We've been using split databases for 10+ years and this just started happening. I'm currently waiting for IT to find out if there have been any Microsoft Updates deployed lately. About 6 months ago, I did migrate...
Don't see an option to maximize the window. Here's the strange thing, when it happens, the database doesn't show up under Apps but under background processes. We are using Windows 10
It's happening with Access itself. Just got a call. Had the user try different things. One database did open. The others had the F11 key disabled. This one didn't. Talked to another db developer here and he said a database he saw it happen to DID NOT have the F11 key disabled. Still might be...
it's not opening off screen. No code affecting visibility. Holding the shift-key down has produced the same result. So frustrating as it's not reproducible
thanks for the response. You're not quite understanding the problem. When a database is launched, it doesn't open on the monitor. Task manager show's it open and the lock file is created.
You are correct tho, we have to close it thru task manager and then delete the lock file. Then try to...
HELP!! Microsoft Access isn't launching all of the time. It's hit or miss and not reproducible. This started happening within the last 2 weeks. Task Manager shows it open. There is a lock file created. It's just not visible on the computer. It's happening with many different databases. I've seen...
I'm trying set the query criteria from a textbox on a form. It's a Status field in the query. 1 = Open, 2 = Closed. If I set the criteria to "1" it shows all open, "2" and it shows all closed and "1" or "2" it shows all. The problem I'm having is setting these in the form. I've set the query to...
I inherited a database. I want to change all the text/criteria in one column from * to ISSUE. Why they used the * I'm not sure. The problem I'm running into is that because the text is a wildcard it changes all the info to ISSUE. Suggestions?
Thanks
MS Office sp1
Attached is the error message we get when trying to email pdf of a report in Access (using SendObject). This was working until last week. There was an MS Office sp1 installed. If I shut down Outlook, I can email from Access but the To:, Subject Line and Body Message are empty...
I've been asked to get some percentages of how many of each CardVal by Dept. The query looks like this:
CardID CardVal Dept
1 F 21
2 F 21
3 U 21
4 IP 21
5 F 21
6 U 21
Is...
MS Access 2007.
Our barcodes are missing when we email a report as a pdf file using VBA. If we print/preview a report and email the report the barcode still exists. Here is the code I'm using in VBA:
DoCmd.SendObject acSendReport, "Report_Name", "PDF Format(*.pdf)"...
This one has me...