Search:

Thanks, Cronk. Yes, I see what you mean by the misplacement of the "2"

Tom

RG
Thanks for the input.

To clarify, here are the steps.
1. The user input the varied Materials in fsubMaterials
2. The text box in the footer of fsubMaterials sums the cost of those Materials....

Using Access 2007

On a form, I have a text box that pulls the total of Materials ordered from a subform fsubMaterials. The Materials are then marked up by the contractor, with a default of 20% but...

In Windows Media Player I clicked on Help and then Technical Information. Here is the video part of what shows:
Video Codecs

TypeNameFormatBinaryVersion

ICM
Microsoft RLE
MRLE
msrle32.dll...

Zig
Could be. How do I check...or correct...that?

Tom

Subject: Using Windows Media Player in Windows 7
I wonder if anyone else has noted a problem with Windows Media Player. About 3 weeks ago WMP started acting up. It won't recognize a CD or DVD with...

Hi John
Right you are.

I'm still working on that aspect. The user goes to an unbound form that only has two List Boxes. One is a List Box which is a Value List of months January through December....

Tom Wickerath's "rounding" of the Wedding Anniversary date fixed that part.

I changed "Month" to "TheMonth" and "Day" to "TheDay" in the query so as not to use reserved words.

The entire query...

Using Access 2007

A members' database. On a form the user selects the month for which a report is desired. This calls for a report of members' wedding anniversaries occurring in the month selected...

Using Access 2000

A table has a Date field called CurDate, set to the default date of new record entered.

On a form, I would like shown:
If CurDate is between January 1 and June 30 of a given...

That's got it. Thanks so much. I looked long and hard trying to figure that out.

Greatly appreciated.

Tom

Here's the entire Before Update code. I didn't include the first part in order to simplify.

You will note that the test for a new record is included in the code. The piece I posted was in an...

Using Access 2003 (2000 format)

I have custom navigation buttons on a form. The BeforeUpdate for the form includes the following code:

If IsNull(Me.Status) Then
Me.Status = "Active"

Select...

Actually, the following works...
Like "*[#]*"

Tom

Using Access 2003(2000 format)

I want to be able to find records with a # sign in an Address2 field.

Entries in the field are like
RR 7
R.R. #22
RR #4

Seems as if Access treats numbers as...

The other thing I can do, I suppose, is to put a label on the bottom of frmTrinity, indicating Canada Post guidelines for entering Streets and Street Directions

Tom

I have used a modification of PeterN's suggestion.

1. Created a new field in tblTrinity for the Apartment/Suite/Unit/Room number
2. Linked tblTrinity with tblRetirementHome by RetHomeID (one to...

Stephane
You have captured the picture correctly. And there is no simple solution. But since these particular collection of streets (Wellington Rd. 22, 29 and 39) is the only anomaly, I'm going to...

mbarron
Thanks for the offer of uploading a scaled down database, but it's not the easiest thing to do.

Actually, since it's only this one page of streets that prints out this way, I am deciding...

I also tried this padding...
Right("000" & [HouseNbr],10)

Same result.

Tom

In the query I plugged in this column
SortHouseNbr: Format([HouseNbr],"0000")

That does the padding, but it makes no difference in the situation
5434 Wellington Rd. 39
7748 Wellington Rd. 22...

The HouseNbr and Street are 2 separate fields to begin with.

I'll have to figure out how to pad the HouseNbr. in the query, in order that the sorting comes out properly in the report. Without the...

Re...
5434 Wellington Rd. 39
7748 Wellington Rd. 22
then 2 addresses on Wellington Rd. 29

The issue isn't an incorrect sorting. The issue is that Wellington Rd. 39, Wellington Rd. 22 and...

Works perfectly!
I am using SortColumn: Right("00000" & Left([FullAddress],InStr([FullAddress]," ")-1),5) & Mid([FullAddress],InStr([FullAddress]," "),99)

Here's an anomaly.

The report sort...

Using Access 2003 (2000 format)

The field is text data type. It stores a street number. I can't make it a numeric field because the street number could be something such as 5D or 12C rather than...