I am working remotely. A tech onsite pulled the machine out of the rack and booted up at his desk. Everything worked fine, perfect, logged in as me. So he put the workstation back in the rack, and this time he did not connect a keyboard or mouse. It works fine for me now.
So, our theory is that there is a short in the keyboard that was plugged into that machine, causing some key or keys to be pressed at all times. Or, an actual mouse...
jimatqsi
Last Activity: 57 minutes ago
Joined: Oct 6 '06
Location: Louisa, Virginia
-
Bizarre Access behavior
I have a sudden, bizarre set of behaviors that make me suspect Microsoft has stepped on something bad. I see unusual and very bad behavior in MS Access and Chrome.
When I open an Access database on my programming machine, an Access Help window opens on the right side of the window. That does not normally happen. But it happens now and it resists all efforts to close it.
When I try to get into Options the browser opens "by... -
Mysterious Access Crash
Dear Access Community,
I have a puzzle for you. I believe this puzzle has already been presented here, similarly but differently. The essence of the puzzle is, why does my Access program crash with the message "Microsoft Access has stopped working?"
This program is a form with 17 list boxes and a few other objects. It's called Pick Queue. It is used by the staff to see all manner of information about pick tickets,... -
You are referencing rst!EventNum after having deleted the record. Make your log entry before deleting the record, or capture the value of rst!EventNum in a variable before deleting the record. Then use the variable in your log entry....Leave a comment:
-
Unexpected error; quitting
I am confronted with a brand new Access error / problem as of mid-afternoon US Eastern time on Dec 3. When editing a form in Access, I cannot click on an event's elipsis ... to get into the code behind the form. I get an immediate pop-up message that says "Unexpected error; quitting." The program does not actually quit, nor does it bring up the VBA code. I've tried multiple events of multiple objects in multiple forms and multiple database... -
I'm sorry I couldn't join you. Is there a recording available of this meeting or any of the meetings?
Thanks!Leave a comment:
-
Did you upgrade that machine from Access 32-bit to 64-bit?...Leave a comment:
-
Wow, this one is fascinating. This might not help but I remember tracking down a crash one time that led me to examining Windows logs. There is a log somewhere that will tell you something about the crash. I can't remember now how to find the necessary log, maybe someone else can add that info. And then the message found might be too generic to help.
Given the weirdness of your problem, I'm thinking the problem and solution is probably...Leave a comment:
-
Thank you, sir, you are correct about that bypass key, of course. My mind and my fingers get out of sync quite frequently....Leave a comment:
-
One question about your attempt to Repair the database. Did you start the database with the return (Shift) key pressed so no startup activity happened? And then go directly to the Compact and Repair tool? That would make sure nothing gummed up the works before you could try the repair.
Moving to a new database is not so challenging. You actually have a small number of objects as compared to many Access databases. You don't have to manually...Leave a comment:
-
I cannot add a lot helpful at this point but I may have a similar problem. I have an app that runs on about 20 different machines. Some of those machines have the runtime only version of Access installed. One of those runtime only machines was crashing when it ran a particular form. I couldn't fix it, but eventually I realized that a subform on that form was no longer being used. So I deleted the subform and now that workstation no longer crashes...Leave a comment:
-
Does your app explicitly open any database apps? I'm thinking something along the lines ofCode:Dim ctl As Control Dim db As DAO.Database Dim Path As String Path = "C:\test\" appMasUtil.OpenCurrentDatabase Path & (databasename], True
Leave a comment:
-
Could you offer some more details on this? Under what circumstances does this happen? Immediately upon entering the app, or after some period of time? Does your app explicitly open other database apps? If so, can you add some logging to that process so that you might have a record of events?
Task manager can tell you more. If you explore the view a bit it will tell you the name of the Access database that is running. Is it the same...Leave a comment:
-
jimatqsi replied to Network Connectivity Issues with Microsoft Access when accessing Remote Databasesin AccessWelcome to the Bytes.com community, Romilly. We'll try to help, but more information will go a long way to helping us help you.
What environment are you working in, Windows server with current (Win 11) workstations and Office 365? Or something else? What is the backend data stored in (SQL, Access or something else)?
Is this problem new, in an application that previously had no problem? Do you see the problem when you...Leave a comment:
-
I use listbox every day, or nearly so, but I don't work much with the combobox object.
I could not solve the problem in the database I received from the original poster. I created a new database and imported the forms, tables and macro from the non-working database.
Then I added this code to the GotFocus and OnChange events of the one of the comboboxes
That change...Code:Me.cbo_Find_ID_Driver.Dropdown
Leave a comment:
-
Well now, this is interesting. Let's get some more information.
It's especially interesting because you refer to combo boxes, plural. So I'm thinking the problem may lie outside those objects. But first, about those objects.
How many boxes are we talking about? Are there some that do not fail?
What is the row source type or types (Table/Query, Value List, or Field List)? All the same type ?
Please share...Leave a comment:
-
Neopa, thank you for clearing that up. I didn't read very well the original post. Understanding the problem is a requirement to fixing the problemLeave a comment:
-
You needn't worry about that. It is probably a .txt copy of the .ldb file, and so it is of no consequence. When you start Access that .ldb file is created and when you close out it should be deleted. It doesn't always get deleted and I don't know why. But it is recreated the next time you start Access.Leave a comment:
-
Now you have me looking at it more closely. I understand it to be returning a true/false value. Been using it for years ... or have I? I don't use multi-select often enough to have a complete grasp of the details ready at hand.
I poked around the Internet and found this example from Microsoft. Ade went off kilter a little bit. The collection he refers to is actually .ItemsSelected. Here's MS' example, which does not reference the...Leave a comment:
-
You may well like Neopa's solution better than my own. I've used both methods but I often forget about that .Selected collection.
I use listboxes extensively, nearly every form I create has at least one listbox on it. They are so very useful. But I don't often use multi-select lists. I use two lists instead, so the user can clearly see what has been selected, no matter how long the origin list is.
I'm glad to be reminded...Leave a comment:
No activity results to display
Leave a comment: