Re: Using variable name in transferSpreadSheet Method

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Thanks much. I see what I was doing wrong now. I was close but now this will
be me there and this does exactly what I need.
--
Westeral


"tina" wrote:

to build on Ken's example:

"c:\temp\" & Forms!NameOfForm!NameOfControl1 &
Forms!NameOfForm!NameOfControl2 &
Forms!NameOfForm!NameOfControl3 & ".xls"

hth


"Westeral" <Westeral@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:28C508A2-87C8-4CB0-A7D8-56EF1E2081B2@xxxxxxxxxxxxxxxx
Thanks, that will help me out in creating the name I want. How do I add
the
concatenated name I created to the transferspreadsheet command? Right now
the name of the file I want created is in quotes (ie "c:\temp\test.xls").
How
do I insert my variable (concatenated name) in place of the test.xls?
--
Westeral


"Ken Snell [MVP]" wrote:

See my website for various examples of TransferSpreadsheet with ACCESS.
http://www.accessmvp.com/KDSnell/EXCEL_MainPage.htm

As for concatenating values from controls of a form:

Forms!NameOfForm!NameOfControl1 & Forms!NameOfForm!NameOfControl2 &
Forms!NameOfForm!NameOfControl3

--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/


"Westeral" <Westeral@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7D5858EB-9B2F-4EF2-9E6F-34B2ACFF9FA9@xxxxxxxxxxxxxxxx
I am attempting to use variable names in the transferSpread sheet
method
instead of just putting in the name. I want to create a spreadsheet
name
based on the concatenation of several fields on a form to generate a
unique
name for the spreadsheet each time it is generated (area name, begin
date
field, and end date field). These spreadsheets are to be sent to a
central
state location where they will be imported into a central database. I
wanted
a way to create a unique name for the file from each area. Is this
even
possible or should I just use some other method to accomplish this?
Thanks.
(I will be on vacation all next week so I won't see any response until
6/8/09).
--
Westeral






.

Relevant Pages

  • Re: using lookup fields in queries
    ... MS Access MVP ... "Duane Hookom" wrote: ... Regarding you combo box on the subform, you might want to look at my ... I have pretty much imitated his form and subform for response entry. ...
    (microsoft.public.access.queries)
  • Re: Display only some fields from each record based on specific cr
    ... I do not want to display the data as a spreadsheet. ... Jeff Boyce response was for you to not use your spreadsheet but the database ... Under the ID, I want to show the Quest#, and Answ when the response ...
    (microsoft.public.access.reports)
  • Re: Copy Cat Aint Working
    ... it appears that I misread the original code. ... <MS ACCESS MVP> ... your response may help others as well. ... >>> a custom function in a module in the template. ...
    (microsoft.public.access.reports)
  • Re: Display only some fields from each record based on specific cr
    ... I do not want to display the data as a spreadsheet. ... "KARL DEWEY" wrote: ... Jeff Boyce response was for you to not use your spreadsheet but the database ...
    (microsoft.public.access.reports)
  • Re: USC athletics director apologizes to UA for Dillon Baxter claims
    ... tutor didn't read all those posts to you. ... other schools recently listed here, ... When it takes you 12 days to think up a response to a dead thread, ... So I have to get permission from you to go on vacation? ...
    (rec.sport.football.college)