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
|
|||
|
|||
Can I derive Import file name from form inputs ?
I have a form where the user selects a date range for which to run some
reports. Currently there is a separate menu option to process the monthly imports to prep the data for reporting. The excel files that are imported into Access are manually named each month with the month and year as part of the file path and name (the rest of the file path and name are consistent.) Can I take inputs from the form where the user defines the date range to run the reports for to feed the import statements the proper path and file names, rather than having to manually change those each month prior to running the import process ? Thanks ! |
#2
|
|||
|
|||
Can I derive Import file name from form inputs ?
Yes. Are you using TransferSpreadsheet? If yes, you can use "string
concatenation" expressions that incorporate the values from controls on a form. Provide us with more details about your exact setup for the import -- including whether you're using VBA code or a macro, the form name, the controls' names, the data type in each control, etc.. -- Ken Snell MS ACCESS MVP "Eric @ CMN, Evansville" wrote in message news I have a form where the user selects a date range for which to run some reports. Currently there is a separate menu option to process the monthly imports to prep the data for reporting. The excel files that are imported into Access are manually named each month with the month and year as part of the file path and name (the rest of the file path and name are consistent.) Can I take inputs from the form where the user defines the date range to run the reports for to feed the import statements the proper path and file names, rather than having to manually change those each month prior to running the import process ? Thanks ! |
#3
|
|||
|
|||
Can I derive Import file name from form inputs ?
I'm still developing the form....as of now I have text boxes on the form that
break out the peices of the dates (converted to text with leading zeros added if necessary) input by the user that I need for the path and file names. My standard operating procedure is to use macros (at first....to develop a prototye and test out logic) and then switch things to VBA code. Can I use [form]![textboxname] logic in the file name parameter of a transferspreadsheet action in a macro ? Or will I have to go straight to VBA for this one ? I seem to recall doing something similar at a previous employer, but like a good employee, I left all my work from that employer at that employer....."intelectual property" of the company, not mine...I was an employee, not a contractor. "Ken Snell [MVP]" wrote: Yes. Are you using TransferSpreadsheet? If yes, you can use "string concatenation" expressions that incorporate the values from controls on a form. Provide us with more details about your exact setup for the import -- including whether you're using VBA code or a macro, the form name, the controls' names, the data type in each control, etc.. -- Ken Snell MS ACCESS MVP "Eric @ CMN, Evansville" wrote in message news I have a form where the user selects a date range for which to run some reports. Currently there is a separate menu option to process the monthly imports to prep the data for reporting. The excel files that are imported into Access are manually named each month with the month and year as part of the file path and name (the rest of the file path and name are consistent.) Can I take inputs from the form where the user defines the date range to run the reports for to feed the import statements the proper path and file names, rather than having to manually change those each month prior to running the import process ? Thanks ! |
#4
|
|||
|
|||
Can I derive Import file name from form inputs ?
In the File Name argument of the TransferSpreadsheet action in the macro:,
for example ="C:\MyFolder\" & Forms!NameOfForm!NameOfTextBox & ".xls" -- Ken Snell MS ACCESS MVP "Eric @ CMN, Evansville" wrote in message ... I'm still developing the form....as of now I have text boxes on the form that break out the peices of the dates (converted to text with leading zeros added if necessary) input by the user that I need for the path and file names. My standard operating procedure is to use macros (at first....to develop a prototye and test out logic) and then switch things to VBA code. Can I use [form]![textboxname] logic in the file name parameter of a transferspreadsheet action in a macro ? Or will I have to go straight to VBA for this one ? I seem to recall doing something similar at a previous employer, but like a good employee, I left all my work from that employer at that employer....."intelectual property" of the company, not mine...I was an employee, not a contractor. "Ken Snell [MVP]" wrote: Yes. Are you using TransferSpreadsheet? If yes, you can use "string concatenation" expressions that incorporate the values from controls on a form. Provide us with more details about your exact setup for the import -- including whether you're using VBA code or a macro, the form name, the controls' names, the data type in each control, etc.. -- Ken Snell MS ACCESS MVP "Eric @ CMN, Evansville" wrote in message news I have a form where the user selects a date range for which to run some reports. Currently there is a separate menu option to process the monthly imports to prep the data for reporting. The excel files that are imported into Access are manually named each month with the month and year as part of the file path and name (the rest of the file path and name are consistent.) Can I take inputs from the form where the user defines the date range to run the reports for to feed the import statements the proper path and file names, rather than having to manually change those each month prior to running the import process ? Thanks ! |
#5
|
|||
|
|||
Can I derive Import file name from form inputs ?
Thanks Ken !
"Ken Snell [MVP]" wrote: In the File Name argument of the TransferSpreadsheet action in the macro:, for example ="C:\MyFolder\" & Forms!NameOfForm!NameOfTextBox & ".xls" -- Ken Snell MS ACCESS MVP "Eric @ CMN, Evansville" wrote in message ... I'm still developing the form....as of now I have text boxes on the form that break out the peices of the dates (converted to text with leading zeros added if necessary) input by the user that I need for the path and file names. My standard operating procedure is to use macros (at first....to develop a prototye and test out logic) and then switch things to VBA code. Can I use [form]![textboxname] logic in the file name parameter of a transferspreadsheet action in a macro ? Or will I have to go straight to VBA for this one ? I seem to recall doing something similar at a previous employer, but like a good employee, I left all my work from that employer at that employer....."intelectual property" of the company, not mine...I was an employee, not a contractor. "Ken Snell [MVP]" wrote: Yes. Are you using TransferSpreadsheet? If yes, you can use "string concatenation" expressions that incorporate the values from controls on a form. Provide us with more details about your exact setup for the import -- including whether you're using VBA code or a macro, the form name, the controls' names, the data type in each control, etc.. -- Ken Snell MS ACCESS MVP "Eric @ CMN, Evansville" wrote in message news I have a form where the user selects a date range for which to run some reports. Currently there is a separate menu option to process the monthly imports to prep the data for reporting. The excel files that are imported into Access are manually named each month with the month and year as part of the file path and name (the rest of the file path and name are consistent.) Can I take inputs from the form where the user defines the date range to run the reports for to feed the import statements the proper path and file names, rather than having to manually change those each month prior to running the import process ? Thanks ! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Requerying a pop up form to display in the main form | Jennifer P | Using Forms | 13 | April 5th, 2005 06:59 PM |
Design help, please | SillySally | Using Forms | 27 | March 6th, 2005 04:11 AM |
Upgrading Outlook XP to Outlook 2003 | Rosemary | Installation & Setup | 2 | March 1st, 2005 04:35 PM |
You do not have exclusive access... ERROR | Robin | General Discussion | 1 | July 6th, 2004 01:18 AM |
Import the Address Book from Palm Desktop to Pocket PC | jdramosgo | Contacts | 1 | May 27th, 2004 11:55 PM |