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 |
#21
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
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 |