Getting Parameter Value Pop Up Box

[Dumb Blonde]

I have the following query..
SELECT [Member Information].Memb, [Member Information].[Clown Name], [Member Information].[First Name], [Member Information].[Last Name], [Member Information].Street, [Member Information].City, [Member Information].State, [Member Information].Zip, [Member Information].[Home Phone], [Member Information].[Work Phone], [Member Information].Ext, [Member Information].[Cell Phone], [Member Information].[E-mail], [Member Information].Bday, [Member Information].SCH, [Member Information].[C-year], [Member Information].JOINED, [Membership Types].[Member Type], [Status Types].[Paid Type], [Member Information].[Dues Pd], [Member Information].COAI, [Member Information].[COAI #]
FROM ([Member Information] INNER JOIN [Membership Types] ON [Member Information].Type = [Membership Types].[Member Type Abbreviation]) INNER JOIN [Status Types] ON [Member Information].[Active/Past Due] = [Status Types].[Paid Type Abbreviation];

When I try to run the query, the parameter query box pops up with the verbiage "Query1.Street". Any ideas why?

 

[Rick B]

Why do some of your fields appear in brackets, and some do not?

[Member Information].Memb
[Member Information].[Clown Name]


Is [Member Information].Street a valid field?


Shouldn't it be Member Information.Street ?

Rick B

I have the following query..
SELECT [Member Information].Memb, [Member Information].[Clown Name], [Member
Information].[First Name], [Member Information].[Last Name], [Member
Information].Street, [Member Information].City, [Member Information].State,
[Member Information].Zip, [Member Information].[Home Phone], [Member
Information].[Work Phone], [Member Information].Ext, [Member
Information].[Cell Phone], [Member Information].[E-mail], [Member
Information].Bday, [Member Information].SCH, [Member Information].[C-year],
[Member Information].JOINED, [Membership Types].[Member Type], [Status
Types].[Paid Type], [Member Information].[Dues Pd], [Member
Information].COAI, [Member Information].[COAI #]
FROM ([Member Information] INNER JOIN [Membership Types] ON [Member
Information].Type = [Membership Types].[Member Type Abbreviation]) INNER
JOIN [Status Types] ON [Member Information].[Active/Past Due] = [Status
Types].[Paid Type Abbreviation];

When I try to run the query, the parameter query box pops up with the
verbiage "Query1.Street". Any ideas why?

 

[Dumb Blonde]

Honestly, I hadn't noticed that. I wrote the query in design view, then viewed it in SQL and copied and pasted. [Member Information].Street is a valid field. My guess is that Access didn't put brackets around the field names that are only one word.

 

[Rick B]

Ah. Good point. I never put spaces in my field or object names, So I guess
I have never seen that before.

I do not see why that would be happening. Hopefully someone will look at
this post who has a better idea than I.

Rick B


Honestly, I hadn't noticed that. I wrote the query in design view, then
viewed it in SQL and copied and pasted. [Member Information].Street is a
valid field. My guess is that Access didn't put brackets around the field
names that are only one word.

 

[Dumb Blonde]

Thanks anyway. I have one other query that's doing the same thing and I don't have a clue why!

Ah. Good point. I never put spaces in my field or object names, So I guess
I have never seen that before.

I do not see why that would be happening. Hopefully someone will look at
this post who has a better idea than I.

Rick B


Honestly, I hadn't noticed that. I wrote the query in design view, then
viewed it in SQL and copied and pasted. [Member Information].Street is a
valid field. My guess is that Access didn't put brackets around the field
names that are only one word.

Why do some of your fields appear in brackets, and some do not?

[Member Information].Memb
[Member Information].[Clown Name]


Is [Member Information].Street a valid field?


Shouldn't it be Member Information.Street ?

Rick B

I have the following query..
SELECT [Member Information].Memb, [Member Information].[Clown Name], [Member
Information].[First Name], [Member Information].[Last Name], [Member
Information].Street, [Member Information].City, [Member Information].State,
[Member Information].Zip, [Member Information].[Home Phone], [Member
Information].[Work Phone], [Member Information].Ext, [Member
Information].[Cell Phone], [Member Information].[E-mail], [Member
Information].Bday, [Member Information].SCH, [Member Information].[C-year],
[Member Information].JOINED, [Membership Types].[Member Type], [Status
Types].[Paid Type], [Member Information].[Dues Pd], [Member
Information].COAI, [Member Information].[COAI #]
FROM ([Member Information] INNER JOIN [Membership Types] ON [Member
Information].Type = [Membership Types].[Member Type Abbreviation]) INNER
JOIN [Status Types] ON [Member Information].[Active/Past Due] = [Status
Types].[Paid Type Abbreviation];

When I try to run the query, the parameter query box pops up with the
verbiage "Query1.Street". Any ideas why?

 

[Lynn Trapp]

Your first instinct was correct. Access cannot deal with spaces in names
and, thus, adds the brackets to compensate. You will find yourself better
off, in the future, if you will find a way to name fields without spaces.
The easiest way is to use and Underscore _ in the place of a space.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

Thanks anyway. I have one other query that's doing the same thing and I don't have a clue why!

Ah. Good point. I never put spaces in my field or object names, So I guess
I have never seen that before.

I do not see why that would be happening. Hopefully someone will look at
this post who has a better idea than I.

Rick B


Honestly, I hadn't noticed that. I wrote the query in design view, then
viewed it in SQL and copied and pasted. [Member Information].Street is a
valid field. My guess is that Access didn't put brackets around the field
names that are only one word.

Why do some of your fields appear in brackets, and some do not?

[Member Information].Memb
[Member Information].[Clown Name]


Is [Member Information].Street a valid field?


Shouldn't it be Member Information.Street ?

Rick B

I have the following query..
SELECT [Member Information].Memb, [Member Information].[Clown Name], [Member
Information].[First Name], [Member Information].[Last Name], [Member
Information].Street, [Member Information].City, [Member Information].State,
[Member Information].Zip, [Member Information].[Home Phone], [Member
Information].[Work Phone], [Member Information].Ext, [Member
Information].[Cell Phone], [Member Information].[E-mail], [Member
Information].Bday, [Member Information].SCH, [Member Information].[C-year],
[Member Information].JOINED, [Membership Types].[Member Type], [Status
Types].[Paid Type], [Member Information].[Dues Pd], [Member
Information].COAI, [Member Information].[COAI #]
FROM ([Member Information] INNER JOIN [Membership Types] ON [Member
Information].Type = [Membership Types].[Member Type Abbreviation]) INNER
JOIN [Status Types] ON [Member Information].[Active/Past Due] = [Status
Types].[Paid Type Abbreviation];

When I try to run the query, the parameter query box pops up with the
verbiage "Query1.Street". Any ideas why?

 

[John Spencer (MVP)]

Can't see any reason for the specific problem, unless you opened the query in
datasheet view while developing it and applied a sort order or filter based on
the Street field.

Try opening the query in datasheet view and selecting clear sort/filter from the
menu.