Prev: Galatasaray, Çağlar'ın transferinde sona yaklaştı
Next: Please help direct me to the right forum
From: relativehunter on 25 May 2010 12:14
I am having a problem with a form and a query. When I open the form (called
Paper), it runs a query that adds a row to a table called Time. If Paper is
open and I try to run a query to see my total time on the form, I get a 2950
error. If I close the Paper form, then I have no problem calling the total
time query. I tried doing an explicit close of the Time table in the macro
that sends the row to the Time table, but that did not solve the problem. Any
ideas?
From: Wayne-I-M on 25 May 2010 12:35
Does your query have a start time and end time.
If so, you can't run the query to see your time on Paper with Paper still
open as you will not have an end time and the query will (when you try and
open it) try a half calculation (that like say 1 + = intead of 1 + 1 =).

Maybe I am not understanding.

Can you post the sql so we cna see it


--
Wayne
Manchester, England.



"relativehunter" wrote:

> I am having a problem with a form and a query. When I open the form (called
> Paper), it runs a query that adds a row to a table called Time. If Paper is
> open and I try to run a query to see my total time on the form, I get a 2950
> error. If I close the Paper form, then I have no problem calling the total
> time query. I tried doing an explicit close of the Time table in the macro
> that sends the row to the Time table, but that did not solve the problem. Any
> ideas?
From: Daryl S on 25 May 2010 12:57
Post the SQL to your query, so we can see if we spot something. What is the
text of Error 2950? What version of Access are you using?

--
Daryl S


"relativehunter" wrote:

> I am having a problem with a form and a query. When I open the form (called
> Paper), it runs a query that adds a row to a table called Time. If Paper is
> open and I try to run a query to see my total time on the form, I get a 2950
> error. If I close the Paper form, then I have no problem calling the total
> time query. I tried doing an explicit close of the Time table in the macro
> that sends the row to the Time table, but that did not solve the problem. Any
> ideas?
From: relativehunter on 25 May 2010 13:53

The message specifically is "The expression is typed incorrectly, or it is
too complex to be evaluated." And gives an example.

The query is: SELECT Sum(Times.[Total time]) AS [Sum Of Total time],
[Forms]![Times]![Start] AS Start, [Forms]![Times]![End] AS [End]
FROM Times
WHERE (((DateValue([Start]))>=DateValue([Forms]![Times]![Start])) AND
((DateValue([End]))<=DateValue([Forms]![Times]![End])))
GROUP BY [Forms]![Times]![Start], [Forms]![Times]![End];
I have a form to select the beginning and ending dates.
From: relativehunter on 25 May 2010 13:54
I tried to insert both the start and end times (just made end time = start
time so that there was not a null in the end time, but that did not seem to
work either).

"Wayne-I-M" wrote:

> Does your query have a start time and end time.
> If so, you can't run the query to see your time on Paper with Paper still
> open as you will not have an end time and the query will (when you try and
> open it) try a half calculation (that like say 1 + = intead of 1 + 1 =).
>
> Maybe I am not understanding.
>
> Can you post the sql so we cna see it
>
>
> --
> Wayne
> Manchester, England.
>
>
>
> "relativehunter" wrote:
>
> > I am having a problem with a form and a query. When I open the form (called
> > Paper), it runs a query that adds a row to a table called Time. If Paper is
> > open and I try to run a query to see my total time on the form, I get a 2950
> > error. If I close the Paper form, then I have no problem calling the total
> > time query. I tried doing an explicit close of the Time table in the macro
> > that sends the row to the Time table, but that did not solve the problem. Any
> > ideas?
 |  Next  |  Last
Pages: 1 2
Prev: Galatasaray, Çağlar'ın transferinde sona yaklaştı
Next: Please help direct me to the right forum