Search results

Hi, anyhelp on the following would be much appreciated. Last Wednesday evening I implemented changes to our DBS and a couple of the users reported errors when they logged in the next morning. The implementation involved back end and front end changes so I took back ups, applied the BE changes...

I'm running a simple query that provides a list of client IDs that are in the client table but are not linked to the monitoring table. It's running a little slow and if I click to go to the last record for example it just hangs. Client has 18k records, monitoring 12k so result is 6k. The IDs are...

Hi, I've spent far too long trying to get this to work and googling on line for an answer so it's your turn if you will to confirm why I'm feeling stupid at this moment and put me out of my misery. So, in my inexperienced Access mind the following statement looks pretty simple and should work...

For about 2 or 3 weeks now, everytime I click on Access it takes about 10 seconds to load the database I'm working on. I've tried other databases I haven't touched for several months and they take 10 seconds as well. By accident I discovered that if file explorer is open maximum size it takes 10...

Hi, I've just migrated several thousand records into my client's database from an old system and have started to get 3343 unrecognised database format a couple of times a week since then. It's fair to say I've also made a few changes to the code during this time and on the day that the error...

I suspect this comes down to a lack of understanding but I've spent a couple of hours going down rabbit holes so I think I need a bit of help before I let it ruin my evening! This is my update statement: DoCmd.RunSQL "Update tblAppointment SET tblAppointment.appointment_notes = txtApptNotes...

I'm trying to conditionally format a long text field in a continuous form. The form only shows the first line of text so I want to highlight the field if it consists of more than one line i.e. if it contains a vbCrLf. In code I can do this easily enough on a normal form for one record with...

For the life of me I can't get this to work. I need to identify on a 12 month rolling basis by month how many counsellors didn't have any appointments. It has to take into account their start and end dates of employment. If the end date is blank they are still employed and if the counsellor is...

Hi, I've got an appointment history continuous form populated with a query that lists all the appointments for a client and shows the counsellor name for each appointment. The counsellor name is found on the counsellor table via counsellor_ID that's stored on the appointment table. Sometimes...

Logged on this morning and the navigation pane and Property Sheet are grey rather than the customary white background. MSACCESS.EXE appears to have been updated yesterday. I'm now on file version 16.0.15128.20178. Anyone else experiencing the same thing?