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
  #1  
Old October 19th, 2004, 02:43 PM
ria
external usenet poster
 
Posts: n/a
Default Dialog box

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

  #2  
Old October 19th, 2004, 03:16 PM
Lynn Trapp
external usenet poster
 
Posts: n/a
Default

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



  #3  
Old October 19th, 2004, 03:16 PM
Lynn Trapp
external usenet poster
 
Posts: n/a
Default

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



  #4  
Old October 19th, 2004, 03:47 PM
ria
external usenet poster
 
Posts: n/a
Default

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




  #5  
Old October 19th, 2004, 03:47 PM
ria
external usenet poster
 
Posts: n/a
Default

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




  #6  
Old October 19th, 2004, 04:27 PM
Lynn Trapp
external usenet poster
 
Posts: n/a
Default

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






  #7  
Old October 19th, 2004, 04:27 PM
Lynn Trapp
external usenet poster
 
Posts: n/a
Default

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






  #8  
Old October 19th, 2004, 05:11 PM
ria
external usenet poster
 
Posts: n/a
Default

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







  #9  
Old October 19th, 2004, 05:11 PM
ria
external usenet poster
 
Posts: n/a
Default

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







  #10  
Old October 19th, 2004, 05:36 PM
Lynn Trapp
external usenet poster
 
Posts: n/a
Default

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









 




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 03:44 PM.


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