RE: Parameter from form
- From: KARL DEWEY <KARLDEWEY@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 1 Apr 2008 11:29:02 -0700
How are you using [Forms].[SPC Form].[Start_date] in your query?
Post the SQL of your query.
--
KARL DEWEY
Build a little - Test a little
"PowerPoint Jedi" wrote:
Hello,.
First off I am using Microsoft acess 2003 and am running of an SQL Server
I am designing a macro that calls a number of different queries to
accomplish my end goal. Each query requires a date input (which is the same
for all of them). I have created a form to enter the one date so that I
didn't have to be prompted 8 times.
I have done this before when not running on an SQL server and used this
command
[Forms].[SPC Form].[Start_date]
Where SPC Form is the name of my Form and Start date is the name of the text
box with the information in it.
When I try to save this it tells me
"ADO ERROR - The column prefix [Forms].[SPC Form].[Start_Date] does not
match with a table name or alias name used inthe query
How do I call a form using acess on an SQL server? This worked before just
running off my normal network.
- Follow-Ups:
- RE: Parameter from form
- From: PowerPoint Jedi
- RE: Parameter from form
- References:
- Parameter from form
- From: PowerPoint Jedi
- Parameter from form
- Prev by Date: nested AND loop Qery Question
- Next by Date: RE: Advanced sort
- Previous by thread: Parameter from form
- Next by thread: RE: Parameter from form
- Index(es):
Relevant Pages
|
