[gopherjpmp]

I am not a programmer, but can figure out enough to hurt myself...

I am trying to out put some files I run through access into a folder on our network drive. The problem is all the users have the drive as a different letter (too big of company to be able to change that!)


The Access mdb pulls information from a ODBC and does its thing. Before they click the button to do all of this, I created a combo box (drop down) that has a-z to choose their drive letter...

Here is the code past that which I am trying to have spit out the info..

_______________
Dim strdrvltr As String




Public Sub Combo14_Change()

Set strdrvltr = Combo14.Value

End Sub

Sub deleteme()




DoCmd.OutputTo acOutputTable, "22+ Red Tab", acFormatXLS, strdrvltr & ":\engquasn\patterson\inspection inventory\data\22+.xls", False


End Sub
__________________

it comes back saying "UCO Data can't save the output data to the file you've selected.

I am positive it has to do with my string in there?

any help would be great as right now I have to creat a different macro for every drive letter known in the department to output the files =\

[Advertisements]

Wow, I am sorry, I quite didn't understand exactly what you wrote, but sure I can see one error.

strdvltr is a string and you don't use Set to store a value into it, so just strdrvltr= Combo14.Value is enough (what's more, give your controls more appropriate names, it helps alot )

That's all I can advise right now.

[Hai Mac]

Wow, I am sorry, I quite didn't understand exactly what you wrote, but sure I can see one error.

strdvltr is a string and you don't use Set to store a value into it, so just strdrvltr= Combo14.Value is enough (what's more, give your controls more appropriate names, it helps alot )

That's all I can advise right now.

[gopherjpmp]

Normally I do give proper names, I just tried this really quick. Normally I will go back and rename when finished.

What I am trying to do is have a combo box available on an Access form that will allow a user to choose a-z and store that value as strdrvltr (string drive letter).

After that is stored, they will click a button to run various queries to d/l and modify the data and then spit it out to a directory on our shared drive where an excel spreadsheet will further modify the info.

The problem is I get an error on this line of code:
DoCmd.OutputTo acOutputTable, "22+ Red Tab", acFormatXLS, strdrvltr & ":\engquasn\patterson\inspection inventory\data\22+.xls", False

The error is
UCO Data can't save the output data to the file you've selected.

Like I mentioned, I know very little programming as I haven't done any since college (7 yrs ago) and I mainly set-up simple databases to save time.

I did remove the set command, thanks for that now if I could just get the rest figured out

[stu_design]

The problem is I get an error on this line of code:
DoCmd.OutputTo acOutputTable, "22+ Red Tab", acFormatXLS, strdrvltr & ":\engquasn\patterson\inspection inventory\data\22+.xls", False

umm sometimes they dont like for you to use spaces when saving (shouldnt matter) sometimes it does .... and also 22+.xls ---sometmes they dont like extra symbols as a plus (shouldnt matter) but ....
u are using VBE or just normal vb?