Replies

In the future, it is often prudent to have an intermediate line of code like this:

strSQL =”SELECT Dept, ” & dbField & ” FROM ” & rTable & ” ORDER BY Dept”
Set RSD = DBR.OpenRecordset(strSQL, dbOpenDynaset)

This way when that “SET RSD =…” line errors, you can easily look at contents of strSQL and see what it contains. The more complicated the formulation, the more likely you’ll make an error. Let me rephrase that, the more complicated the formulation, the more likely that I’ll make an error!

I don’t see how “[NameID]=” & Me![BorrowerName] would work, unless perhaps BorrowerName is the name of the combobox and that the ID is the bound column?

Any time you are formulating WHERE clauses, you need to be aware of the data types for the fields you are using. Obviously [NameID] is probably a numeric field, so quotes aren’t needed to use 7 and not ‘7’. Quotes are needed around text fields, and you must use the # symbol around date fields.

As a word of caution, you should get out of the habit of naming fields in your tables with reserved words (like Name) that Access uses for Property, methods, or function names. So instead of your Name field, you should use BorrowerName, etc.

The Where clause should be “NameID=7”.

Pretty simple. Assuming you know the location and name of the file in question (let’s assume it is in a variable named strFullFileName), the code behind the button to view the file would be:

Application.FollowHyperlink strFullFileName

Windows will open it in the application that is the default for that file type.

Rui,

I found the Group Policy Editor, and I found a bunch of options which were “not configured”. Unfortunately, I don’t have a clue on what any of they do! But I don’t want to be a Windows administrator, and this should not be that difficult for the average user! It’s just annoying.

The latest is 14393.10, which are you on? (run>winver)
The latest build came out a few days ago…

Win 10 Pro Build 10586.494! But again the question, if it is doing automatic updates, why don’t I have current build?

There should be a link immediately below “Available updates will be…” which says “Change active hours”. Not sure which build introduced this concept. It may not be in the build you are running.

I definitely don’t see that. I just upgraded 2 weeks ago, so I’d assume I got the latest build at the time. And since it appears to be updating automatically, why wouldn’t I have the latest one now?

Trev,
I don’t see that option. All I see is a statement “Available updates will be downloaded and installed automatically.” I can’t see where to change that.

The Before Update event is part of the form itself, and should operate whether the form is opened directly or as a subform. There are no events on a subform control (other than Enter/Exit).

The first problem you have is with “WHERE Field1 = null”; this needs to be “WHERE Field1 Is Null. Any expression such as Field1 = Null equates to Null and not True/False; it doesn’t matter what Field1 is.

The only explanation is that to present the the query in the query design view, Access must create the Rows 1 and 2 you showed; but apparently it isn’t good at putting them back into the original SQL Where clause.

I’d keep that “Life Membership” field. I think it is an important piece of information. I dislike using artificial entries (like 2525).

Exactly where did you put this Validation Rule? You could put it in the [meter] field in the table. In a form, you’d put code in the Form’s BeforeUpdate event to check for this.

Do you know about conditional formatting? This can handle your situation without any code.

In addition to what Wendell mentioned, make sure you haven’t tried to format the field. Also, make sure the detail section “Can Grow” property is True.

Basically you first need a query that returns a single record for each Client and Date, then that is the source for your final query. Something like this:

SELECT ClientID, Count(EventDate) AS UniqueDays FROM (SELECT DISTINCT ClientID, EventDate FROM Events) GROUP BY ClientID