Search results

Never mind I see my mistake now. strPath & "\

I am trying to export a query or table to a location that the user selects. So each time the export button is clicked the folder will change. But I want to be able to select the folder. The code I have below is saving but not to the folder I want it to. Private Sub CommandBtn_Click()...

Hi All, I was wondering if it was possible to link random external tables to the Active Database through VBA. I would like to run the code that would open up a dialog box that would let the user select the database as well as the tables within that database that the user can select to link...

Thanks for you help.

Here is the complete code that I have. The block above is what I just added. Without the block of code above it works fine. But with the code above I get the error message stated above.

Thanks everyone for your help. It works now.

Hello, I'm stuck once again. I would like Access to open an Excel file count the worksheets and then give each tab the name of the column heading in cell A1 of each worksheet. I had no problem with the code in Excel but when I tried to add it to Access I am getting an error on the WS_Count =...

Okay I tried to add a string for the select path but now I'm getting a run-time error '1004. Microsoft Excel cannot access the file C:\6D233000. The file name or path does not exist, The file is being used by another program...etx. Dim intChoice As Integer Dim strPath As String Dim fd As...

Correct, I will like to save it as the same path as the initial file. Is that possible?

Hello, I am trying to open an Excel Workbook from a FileDialog where the user can select the file, make changes (in this case formatting), then SaveAs a different name in the same path as the original file from a command button on an Access form. Everything works except saving the file as a...

I know this is a crazy request but I was wondering if this was possible or not. The excel worksheet that I am importing into my database has some formula's, for an example =2+2. I am importing this worksheets, then checking fields against the main table, then exporting back to Excel. But I...

I'll see if I can explain it better. Ok the user will import worksheets that will create new tables every time. The thing is that each import will be different and instead of having the table name to be the same as the tab I want the table name to be the same as the first column heading. Is...

I am importing different excel sheets into Access dB using a file dialog. The importing works fine however, I would like to rename the tables once they are imported to the name of the first column heading. Where exactly would I ad the name change at in this code? #' Open the EXCEL file and...

Well let me ask this. Can I use the OR in the IIf(InStr(qA.twoField, "time" OR "day" OR "week") <> 0, "Culprit", "Clean" (this doesn't work) If there is a way to use it like this it may cut down on the number of queries I have to write. If I do have to write multiple queries, my final query...

Paul, thanks again. This works but I have so many different IIf(InStr(qA.twoField, "time") <> 0, "Culprit", statements that I get a syntax error. So I guess I wll have to write two different queries with all the IIf(InStr statements and then write another query to combine the newColumn1 is...

I really wanted a new query (qB) to run off an existing query (qA) but I couldn't figure out how to add a new column in the new querty (qB) that populates if the description name in the existing query (qA) contains the word "time" anywhere in that field. So my logic was that qA would make a...

Hello, I made a query that makes a new table (NewTable). That works fine. However, I would like to add a new column that I will use an update query later to update the new column I created. Is this possible?

Thank you so much. It works with no issues. Thanks again all!

pr2-eugin quick question for you. I added some code to what you posted to change the column headings in the file but it's not working. Here is the code. Private Sub cmdTestButton_Click() Dim fd As FileDialog Set fd = Application.FileDialog(msoFileDialogFilePicker) With fd...

pr2-eugin Thanks so much. The code that I used before utzia1 post was twice as long. This is short and straight to the point. Thanks again for your help you all. What's a good book to learn VBA? One that starts at the very basic because after 10 years of not using this stuff you really forget...