Search results

This morning a very odd error has cropped up, that I'm hoping someone here can help with. Two buttons on a subform have suddenly disabled themselves. They should look like this: Instead, they look like this: Notice the magnifying glass and "X" are now greyed out. The buttons themselves...

On a form I have amended a button to point to a Sharepoint folder. It used to point to a network folder, but we're moving our folders to Sharepoint. I have tested it successfully on my PC. Browser opens, goes straight to the SharePoint folder specified. I tested this on an end-user's PC --...

I hope someone here can help--I know a very limited amount of VBA. What I'd like to is create a function that can look at the fields on a form and determine how many of the fields are blank/null (3 fields are dropdowns, 2 are freetext, 1 is free-number). I'm sure it would be something to do...

The long and short of this week's problem is this: I have a list of patients that are seeing various clinicians in a clinic. Currently everything is on paper and when a patient arrives we highlight their name on the list. So now that I'm finally moving everything paperless, I want to have the...

So in my database i'm creating a live form that will open up a list of patients and when they are seen. one of the bits is a button that before they arrive says "Not Arrived" and after they arrive it says "Arrived". The code works fine: Private Sub Command68_Click() Dim C1 As String Dim C2 As...

Ok the long and short is this, my main table is Patient Registration details, which includes a universal PK (field is called RGID) that links to all other tables in my db. I'm setting up a query that will add appointments to my appointment table. The PK in tblAppointments is an autonumber, but...

I've now tried this a few times with no luck-- you know how you add a button on a form that will open a further form. You can select "Find specific data to display". Well, when I selec that option (which I want to do) up comes the screen where you can match the criteria. I find that my "left"...

Hi, Thanks in advance for any help anyone can give. I've got a db that I'd like a group of users to have read-only access to, which I've set through UserLevel Security. Problem is, it is a database of patient records that has a search box whereby you enter in the ID of the patient, click...

I've recently started in my post and I've inherited a slew of pretty big databases from my predecessor, who, unfortunately did not leave a user guide on where everything is (there's around 85 pages of code). The main database contains patient records. It has a clone that is a read-only...

Hi, first post, hopefully someone can help me. I'm building a database to audit the use of "Do Not Resuscitate" forms at the hospital I work at. To capture the use of each DNR, I've got a form to enter a series of Yes/No questions for each patient. What I want to do is, to ensure that noone...