Search results

Oof. I'll try to strip it down but the problem doesn't persist. If the table is local the problem isn't there. I'll see what I can do.

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

Update 2: Changed the code to point to Google. The users with error code 8 now successfully launch the link. Am I missing something about SharePoint? Surely the users' browser should open no matter what, and let the SharePoint permissions determine whether the file can be accessed?

Update - after a few minutes the hyperlink works on the end-user's PC. I have no idea why. Interestingly enough, I tried it on two others' PC's and received error code 8: Cannot Download the Information you Requested. Looking through some other articles, it may have to do with the "Work...

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

Thanks everyone for the responses. Sneuberg's was what I was going for in the simplest way, but I appreciate the other suggestions.

Never mind-- a few minutes after i posted I came up with the following code-- it might be a bit long-winded, but it works... note-- I added a field call "CritVal" into my source table. This code adds up the non-blank fields and inserts that value into [CritVal]. That value is then used as...

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

Thanks, CJ. Worked a treat. I honestly never registered that there was conditional formatting in access--I was always under the impression things like this had to be done with VBA (which I would actually prefer, for the practice in writing it).

Have now altered the code to this: Private Sub ATCST_AfterUpdate() Dim Arr As Long Dim WNB As Long Dim Wht As Long Arr = RGB(231, 244, 66) 'Colour Code is #E7F442 WNB = RGB(0, 255, 0) 'Colour Code is #00FF00 Wht = RGB(255, 255, 255) 'Colour Code is #FFFFFF If Me.ATCST = "Arrived" Then...

So where would I put that conditional formatting? In the query that collects the form data or in the VB?

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

That's no problem, my chocies are "Not Arrived";"Arrived";"WNB" Not arrived is default value. WNB stands for Was Not Brought (it's a children's hospital so we call it was not brought rather than did not attend...we're caring like that)

Nah it's going to be used by a few different people, and some of them are not tab-savvy, unfortunately. Now, onto the next problem. The combo box works, and I want to have the fields turn optic-yellow when their status is set to "Arrived". The code is such that: Private Sub...

Yknow what, I'm just gonna do it the easy way. New field in the table that's a combo box, "arrived", "not arrived", "non-attender".

I have changed it to a toggle button, but again, if i click the button in the first record, it changes for all records. All I want is to change things in the active record. Filling in the boxes isn't a problem, as they are part of the datasheet, but its the formatting of the individual records...

I have a high-enough post-count now- Before click: After click:

It's to use in a multidisciplinary clinic-- the smudged out headings at the top of the form are the clinician's names. The boxes are merely going to show the time on the clock that the notes were passed to that clinician, and not their status of seen, in room, etc. I'll try toggle button

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