Dialog box

[Guest]

I have a form "specify dates" in which a user enters "startdate" and
"enddate". I then run a macro which has about 15 update queries depending on
the dates. >=[form]![specify dates]![startdate] and <=[form]![specify
dates]![enddate]. This is where I am running into problems

1. I am still being asked for the form.specify dates.startdate and enddate.
2. Some of the queries remain open. I would like the user to only see the
end result which is a report.

Thanks for your help

 

[Lynn Trapp]

Change [form] to [forms]

 

[Guest]

Lynn

Thanks...it works. But now, I have another problem. When I specify start
date of 1/1 and end date of 12/12 in the form, the queries do not work. But,
if I individually type the same info when I run the query by itself, it
works. The fields in the form are formatted to short date. What should i be
doing?

Thanks

Change [form] to [forms]

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

I have a form "specify dates" in which a user enters "startdate" and
"enddate". I then run a macro which has about 15 update queries depending on
the dates. >=[form]![specify dates]![startdate] and <=[form]![specify
dates]![enddate]. This is where I am running into problems

1. I am still being asked for the form.specify dates.startdate and enddate.
2. Some of the queries remain open. I would like the user to only see the
end result which is a report.

Thanks for your help

 

[Lynn Trapp]

when you say it doesn't work, what do you mean? Are you getting no results?
Are you getting unexpected or "wrong" results?

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

Lynn

Thanks...it works. But now, I have another problem. When I specify start
date of 1/1 and end date of 12/12 in the form, the queries do not work. But,
if I individually type the same info when I run the query by itself, it
works. The fields in the form are formatted to short date. What should i be
doing?

Thanks

Change [form] to [forms]

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

I have a form "specify dates" in which a user enters "startdate" and
"enddate". I then run a macro which has about 15 update queries

depending
on

the dates. >=[form]![specify dates]![startdate] and <=[form]![specify
dates]![enddate]. This is where I am running into problems

1. I am still being asked for the form.specify dates.startdate and enddate.
2. Some of the queries remain open. I would like the user to only

see
the

end result which is a report.

Thanks for your help

 

[Guest]

Lynn

I created another form and now it works. I am not sure why the other form
did not work. I am using the same macro with the same queries. But, the
problem I have now is that all the queries I run are open. I would like to
close all the queries and only show the end result, the report. How do I
close the queries?

Thanks

when you say it doesn't work, what do you mean? Are you getting no results?
Are you getting unexpected or "wrong" results?

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

Lynn

Thanks...it works. But now, I have another problem. When I specify start
date of 1/1 and end date of 12/12 in the form, the queries do not work. But,
if I individually type the same info when I run the query by itself, it
works. The fields in the form are formatted to short date. What should i be
doing?

Thanks

Change [form] to [forms]

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


I have a form "specify dates" in which a user enters "startdate" and
"enddate". I then run a macro which has about 15 update queries depending
on
the dates. >=[form]![specify dates]![startdate] and <=[form]![specify
dates]![enddate]. This is where I am running into problems

1. I am still being asked for the form.specify dates.startdate and
enddate.
2. Some of the queries remain open. I would like the user to only see
the
end result which is a report.

Thanks for your help

 

[Lynn Trapp]

Is your Macro opening those queries? Are you using multiple queries in your
final query that the form is calling?

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

Lynn

I created another form and now it works. I am not sure why the other form
did not work. I am using the same macro with the same queries. But, the
problem I have now is that all the queries I run are open. I would like to
close all the queries and only show the end result, the report. How do I
close the queries?

Thanks

when you say it doesn't work, what do you mean? Are you getting no results?
Are you getting unexpected or "wrong" results?

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

Lynn

Thanks...it works. But now, I have another problem. When I specify start
date of 1/1 and end date of 12/12 in the form, the queries do not

work.
But,

if I individually type the same info when I run the query by itself, it
works. The fields in the form are formatted to short date. What

should i
be

doing?

Thanks

:

Change [form] to [forms]

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


I have a form "specify dates" in which a user enters "startdate" and
"enddate". I then run a macro which has about 15 update queries depending
on
the dates. >=[form]![specify dates]![startdate] and <=[form]![specify
dates]![enddate]. This is where I am running into problems

1. I am still being asked for the form.specify dates.startdate and
enddate.
2. Some of the queries remain open. I would like the user to

only
see

the
end result which is a report.

Thanks for your help

 

[Guest]

yes the macro is opening some 15 queries, some are updating tables that are
later used by the main macro.

Is your Macro opening those queries? Are you using multiple queries in your
final query that the form is calling?

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

Lynn

I created another form and now it works. I am not sure why the other form
did not work. I am using the same macro with the same queries. But, the
problem I have now is that all the queries I run are open. I would like to
close all the queries and only show the end result, the report. How do I
close the queries?

Thanks

when you say it doesn't work, what do you mean? Are you getting no results?
Are you getting unexpected or "wrong" results?

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


Lynn

Thanks...it works. But now, I have another problem. When I specify start
date of 1/1 and end date of 12/12 in the form, the queries do not work.
But,
if I individually type the same info when I run the query by itself, it
works. The fields in the form are formatted to short date. What should i
be
doing?

Thanks

:

Change [form] to [forms]

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


I have a form "specify dates" in which a user enters "startdate" and
"enddate". I then run a macro which has about 15 update queries
depending
on
the dates. >=[form]![specify dates]![startdate] and <=[form]![specify
dates]![enddate]. This is where I am running into problems

1. I am still being asked for the form.specify dates.startdate and
enddate.
2. Some of the queries remain open. I would like the user to only
see
the
end result which is a report.

Thanks for your help

 

[Lynn Trapp]

It's pretty difficult, since I can't look over your shoulder, to see exactly
what you are doing. Could you describe what your macro does in a bit more
detail?

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

yes the macro is opening some 15 queries, some are updating tables that are
later used by the main macro.

Is your Macro opening those queries? Are you using multiple queries in your
final query that the form is calling?

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

Lynn

I created another form and now it works. I am not sure why the other form
did not work. I am using the same macro with the same queries. But, the
problem I have now is that all the queries I run are open. I would

like
to

close all the queries and only show the end result, the report. How do I
close the queries?

Thanks

:

when you say it doesn't work, what do you mean? Are you getting no results?
Are you getting unexpected or "wrong" results?

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


Lynn

Thanks...it works. But now, I have another problem. When I

specify
start

date of 1/1 and end date of 12/12 in the form, the queries do not work.
But,
if I individually type the same info when I run the query by

itself,
it

works. The fields in the form are formatted to short date. What should i
be
doing?

Thanks

:

Change [form] to [forms]

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


I have a form "specify dates" in which a user enters

"startdate"
and

"enddate". I then run a macro which has about 15 update queries
depending
on
the dates. >=[form]![specify dates]![startdate] and <=[form]![specify
dates]![enddate]. This is where I am running into problems

1. I am still being asked for the form.specify

dates.startdate
and

enddate.
2. Some of the queries remain open. I would like the user to only
see
the
end result which is a report.

Thanks for your help

 

[Guest]

Lynn

The macro has about 15 queries which update different fields in a table.
Some also make a table. THe last one uses data from these and other tables
and queries to give the end result. The queries that remain open are the
select queries that are used later for Dlookup to populate a field in the
tablle. The rest make table and update queries do not remian open.

Thanks for your patience and advice. I greatly appreciate it.

It's pretty difficult, since I can't look over your shoulder, to see exactly
what you are doing. Could you describe what your macro does in a bit more
detail?

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

yes the macro is opening some 15 queries, some are updating tables that are
later used by the main macro.

Is your Macro opening those queries? Are you using multiple queries in your
final query that the form is calling?

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


Lynn

I created another form and now it works. I am not sure why the other form
did not work. I am using the same macro with the same queries. But, the
problem I have now is that all the queries I run are open. I would like
to
close all the queries and only show the end result, the report. How do I
close the queries?

Thanks

:

when you say it doesn't work, what do you mean? Are you getting no
results?
Are you getting unexpected or "wrong" results?

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


Lynn

Thanks...it works. But now, I have another problem. When I specify
start
date of 1/1 and end date of 12/12 in the form, the queries do not
work.
But,
if I individually type the same info when I run the query by itself,
it
works. The fields in the form are formatted to short date. What
should i
be
doing?

Thanks

:

Change [form] to [forms]

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


I have a form "specify dates" in which a user enters "startdate"
and
"enddate". I then run a macro which has about 15 update queries
depending
on
the dates. >=[form]![specify dates]![startdate] and
<=[form]![specify
dates]![enddate]. This is where I am running into problems

1. I am still being asked for the form.specify dates.startdate
and
enddate.
2. Some of the queries remain open. I would like the user to
only
see
the
end result which is a report.

Thanks for your help

 

[Guest]

Lynn

I figured out a way... I tracked the queries that remain open and closed
them later in the macro using the close command.

It's pretty difficult, since I can't look over your shoulder, to see exactly
what you are doing. Could you describe what your macro does in a bit more
detail?

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

yes the macro is opening some 15 queries, some are updating tables that are
later used by the main macro.

Is your Macro opening those queries? Are you using multiple queries in your
final query that the form is calling?

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


Lynn

I created another form and now it works. I am not sure why the other form
did not work. I am using the same macro with the same queries. But, the
problem I have now is that all the queries I run are open. I would like
to
close all the queries and only show the end result, the report. How do I
close the queries?

Thanks

:

when you say it doesn't work, what do you mean? Are you getting no
results?
Are you getting unexpected or "wrong" results?

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


Lynn

Thanks...it works. But now, I have another problem. When I specify
start
date of 1/1 and end date of 12/12 in the form, the queries do not
work.
But,
if I individually type the same info when I run the query by itself,
it
works. The fields in the form are formatted to short date. What
should i
be
doing?

Thanks

:

Change [form] to [forms]

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


I have a form "specify dates" in which a user enters "startdate"
and
"enddate". I then run a macro which has about 15 update queries
depending
on
the dates. >=[form]![specify dates]![startdate] and
<=[form]![specify
dates]![enddate]. This is where I am running into problems

1. I am still being asked for the form.specify dates.startdate
and
enddate.
2. Some of the queries remain open. I would like the user to
only
see
the
end result which is a report.

Thanks for your help

 

[Lynn Trapp]

Ok, so help me understand what you are trying to do with these select
queries that are remaining open. You said they are being used to "populate a
field in the table", which suggests either an append query or an update
query. Is there some reason the select queries can't be replaced with one of
these kind? If not, then the best approach would probably be to open a
Recordset in code. Are you comfortable with writing VBA code?

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

Lynn

The macro has about 15 queries which update different fields in a table.
Some also make a table. THe last one uses data from these and other tables
and queries to give the end result. The queries that remain open are the
select queries that are used later for Dlookup to populate a field in the
tablle. The rest make table and update queries do not remian open.

Thanks for your patience and advice. I greatly appreciate it.

It's pretty difficult, since I can't look over your shoulder, to see exactly
what you are doing. Could you describe what your macro does in a bit more
detail?

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

yes the macro is opening some 15 queries, some are updating tables

that
are

later used by the main macro.

:

Is your Macro opening those queries? Are you using multiple queries

in
your

final query that the form is calling?

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


Lynn

I created another form and now it works. I am not sure why the

other
form

did not work. I am using the same macro with the same queries.

But,
the

problem I have now is that all the queries I run are open. I

would
like

to
close all the queries and only show the end result, the report.

How
do I

close the queries?

Thanks

:

when you say it doesn't work, what do you mean? Are you getting no
results?
Are you getting unexpected or "wrong" results?

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


Lynn

Thanks...it works. But now, I have another problem. When I specify
start
date of 1/1 and end date of 12/12 in the form, the queries do not
work.
But,
if I individually type the same info when I run the query by itself,
it
works. The fields in the form are formatted to short date. What
should i
be
doing?

Thanks

:

Change [form] to [forms]

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


I have a form "specify dates" in which a user enters "startdate"
and
"enddate". I then run a macro which has about 15 update queries
depending
on
the dates. >=[form]![specify dates]![startdate] and
<=[form]![specify
dates]![enddate]. This is where I am running into problems

1. I am still being asked for the form.specify dates.startdate
and
enddate.
2. Some of the queries remain open. I would like the user to
only
see
the
end result which is a report.

Thanks for your help

 

[StCyrM]

Good evening

Your statement should look like this:

Between [forms]![SpecifyDates]![StartDate] AND [forms]![SpecifyDates]![EndDate]


Maurice St-Cyr