Recent content by bsnalex

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