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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
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 |