A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Dialog box



 
 
Thread Tools Display Modes
  #21  
Old October 20th, 2004, 02:01 PM
ria
external usenet poster
 
Posts: n/a
Default

Lynn

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

"Lynn Trapp" wrote:

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


"ria" wrote in message
...
yes the macro is opening some 15 queries, some are updating tables that

are
later used by the main macro.

"Lynn Trapp" wrote:

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


"ria" wrote in message
...
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

"Lynn Trapp" wrote:

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


"ria" wrote in message
...
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

"Lynn Trapp" wrote:

Change [form] to [forms]

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


"ria" wrote in message
...
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













  #22  
Old October 20th, 2004, 02:01 PM
ria
external usenet poster
 
Posts: n/a
Default

Lynn

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

"Lynn Trapp" wrote:

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


"ria" wrote in message
...
yes the macro is opening some 15 queries, some are updating tables that

are
later used by the main macro.

"Lynn Trapp" wrote:

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


"ria" wrote in message
...
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

"Lynn Trapp" wrote:

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


"ria" wrote in message
...
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

"Lynn Trapp" wrote:

Change [form] to [forms]

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


"ria" wrote in message
...
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













  #23  
Old October 20th, 2004, 02:01 PM
ria
external usenet poster
 
Posts: n/a
Default

Lynn

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

"Lynn Trapp" wrote:

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


"ria" wrote in message
...
yes the macro is opening some 15 queries, some are updating tables that

are
later used by the main macro.

"Lynn Trapp" wrote:

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


"ria" wrote in message
...
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

"Lynn Trapp" wrote:

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


"ria" wrote in message
...
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

"Lynn Trapp" wrote:

Change [form] to [forms]

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


"ria" wrote in message
...
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













  #24  
Old October 20th, 2004, 02:05 PM
Lynn Trapp
external usenet poster
 
Posts: n/a
Default

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


"ria" wrote in message
...
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.

"Lynn Trapp" wrote:

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


"ria" wrote in message
...
yes the macro is opening some 15 queries, some are updating tables

that
are
later used by the main macro.

"Lynn Trapp" wrote:

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


"ria" wrote in message
...
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

"Lynn Trapp" wrote:

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


"ria" wrote in message
...
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

"Lynn Trapp" wrote:

Change [form] to [forms]

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


"ria" wrote in message
...
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















  #25  
Old October 20th, 2004, 02:05 PM
Lynn Trapp
external usenet poster
 
Posts: n/a
Default

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


"ria" wrote in message
...
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.

"Lynn Trapp" wrote:

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


"ria" wrote in message
...
yes the macro is opening some 15 queries, some are updating tables

that
are
later used by the main macro.

"Lynn Trapp" wrote:

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


"ria" wrote in message
...
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

"Lynn Trapp" wrote:

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


"ria" wrote in message
...
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

"Lynn Trapp" wrote:

Change [form] to [forms]

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


"ria" wrote in message
...
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















  #26  
Old October 20th, 2004, 02:05 PM
Lynn Trapp
external usenet poster
 
Posts: n/a
Default

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


"ria" wrote in message
...
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.

"Lynn Trapp" wrote:

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


"ria" wrote in message
...
yes the macro is opening some 15 queries, some are updating tables

that
are
later used by the main macro.

"Lynn Trapp" wrote:

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


"ria" wrote in message
...
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

"Lynn Trapp" wrote:

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


"ria" wrote in message
...
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

"Lynn Trapp" wrote:

Change [form] to [forms]

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


"ria" wrote in message
...
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















  #27  
Old October 20th, 2004, 02:05 PM
Lynn Trapp
external usenet poster
 
Posts: n/a
Default

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


"ria" wrote in message
...
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.

"Lynn Trapp" wrote:

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


"ria" wrote in message
...
yes the macro is opening some 15 queries, some are updating tables

that
are
later used by the main macro.

"Lynn Trapp" wrote:

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


"ria" wrote in message
...
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

"Lynn Trapp" wrote:

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


"ria" wrote in message
...
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

"Lynn Trapp" wrote:

Change [form] to [forms]

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


"ria" wrote in message
...
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















  #28  
Old November 7th, 2004, 02:44 AM
StCyrM
external usenet poster
 
Posts: n/a
Default

Good evening

Your statement should look like this:

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


Maurice St-Cyr


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









 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Network Path/Excel Open Dialog Problem Nny :\) General Discussion 3 August 16th, 2004 08:57 PM
Access 2000: No events when hiding & reopening dialog box-a glitch in attempt to speed up app Matt Jaffey Using Forms 11 June 11th, 2004 09:09 PM
Access 2000 OLE Insert Object Dialog box Roger C. Bledsoe Database Design 0 May 28th, 2004 03:56 AM
How can I programatically supress "Select Table" dialog? RHNewbie Mailmerge 4 May 3rd, 2004 09:26 PM


All times are GMT +1. The time now is 12:34 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.