Parameter from form

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

Relevant Pages

  • Re: The best elegant solution to override 65k rows limit in a sheet
    ... Access ships with MSDE.. ... >SQL Server Books Online (again-- Access ships with freeware SQL Server ... better ways to achieve their results through queries. ...
    (microsoft.public.excel)
  • Re: Official Status of SQLServer 2005 ADP
    ... solution might be to use ADP. ... With MDB and Linked tables, the only ways of accelerating things are the use ... of Views and the cumbersome use of SQL passthrough queries. ... > SQL Server, and carry on using Access like I aways had. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: SQL Server 2000 and Latching problem
    ... While the way we indexed our tables and the way we wrote the queries etc ... "chances are you are getting latches because you are ... query on the results the query .. ... SQL Server 2000 and Latching problem ...
    (microsoft.public.sqlserver.connect)
  • Re: Sql server as back end
    ... There is an option in the Tools menu, Database Utilities, for Upsize to SQL Server. ... But after that, the queries should generally work, shouldn't they? ...
    (microsoft.public.access.tablesdbdesign)
  • Re: SQL Server (?) performance issues
    ... it's usually that those queries are being blocked by something else. ... Columnist, SQL Server Professional ... exact counters are being watched, but we are being told that all the ... all is fine and there is plenty of spare capacity. ...
    (microsoft.public.sqlserver.server)
Loading