Search results

Thanks ashleedawg for that detailed explanation, but unfortunately that won't work for me. I am trying to export data from an Access Table to an Excel Spreadsheet so that I can send that spreadsheet to clients who would then edit or append data to that spreadsheet and then send it back to me...

OK - So you mean I should use the DoCmd.TransferSpreadsheet acExport to the template instead of the .xls file? I tried that but am getting a Run-time error 3274 "External table is not in the expected format" Any other suggestions?

I'm using VBA to export an Access Query to an Excel Spreadsheet DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, WbSheet, CurrentProject.Path & "\" & WbName, True But before exporting, I need to clear the contents of the spreadsheet as it may contain data that is outside the named...

Thanks all - you guys are amazingly fast!!!

I have a button on a form that will import data from excel and run an update query. In order to do this without all the warnings, I turn the warning off. This works fine but I still would like to give the user a chance to back out after clicking the button. Is there a quick yes/no...

I think I may have found an article that explains how to this. It's by Doug Steele. Here's the link http://www.vb123.com.au/200311_ds_aa.htm Now I just have to see if I can get it to work with the guidance he provided.

I don't want to link the file as the file I'll be getting back is only a small subset of the data that is in the entire table. So I can't delete the table and just add the new one either. The file being returned could be the same name and I could even store it in the same location. So for...

I am using the following VBA to export data to an Excel Spreadsheet so that users can update the spreadsheet and send it back to me. Then I'd like to import it back into the table called tblProduct. Dim WbName As String Dim WbSheet As String WbSheet = "qryUpdate" WbName =...

Thanks, I guess I'll do the two entries for now since its only happened once in countless years. But it does bother me, so I may do the junction table if I get bored one day and can no longer live with it...

I have a database that is a typical contact database where my table design has a one to many relationship for companies and contacts. That is, one company has many contacts but one contact can only be in one company. This has worked great for years and never had an issue. Now I'm looking at...

So for anyone who may need this in the future, I figured out how to get this to work. 'From Access, Writing the file path to a text file Dim fn As String fn = Application.CurrentProject.Path & "\TempFilePath.txt" Open fn For Output As #1 Print #1, strPath; Close #1...

OK I found a way to store the path to a temp txt file. I thought this would be easier than trying to get Outlook to get the path from Access. Dim fn As String fn = Application.CurrentProject.Path & "\TempFilePath.txt" Open fn For Output As #1 Write #1, strPath Close #1...

Do you have a sample mdb or VBA of how to do that? I am already writing the folder location to an Access table when I create it in Access. The reason I use Access to create the folder is because I just use Outlook for email. My Access database is more of a CRM tool that does it all. So I'll...

Thanks pbaldy That did it.

Sure, It's actually the same as the one in Allen Browne's site with a listbox instead of a textbox

So now I'm getting and error 2448 "Can't assign a value to this object" when picking from the list box and still getting an invalid procedure call if I select any of the other boxes

I've tried many different ways to try to adapt this to work. But I keep getting errors. This last one in the baldyweb example, I tried to replace just If Not IsNull(Me.lstFilterCity) Then strWhere = strWhere & "([City] = """ & Me.lstFilterCity & """) AND " End If with Dim ctl...

I'm using Allen Browne's search criteria to filter a continuous form - found here: http://allenbrowne.com/ser-62.html But I'm struggling in changing one of the text boxes to a list box. For instance, Allen had the txtFilterCity as: 'Text field example. Use quotes around the value in the...

In Access 2003, I’m creating a directory in Windows. Dim strPath As String strPath = Application.CurrentProject.Path & "\Reference\" If Len(Dir(strPath, vbDirectory)) = 0 Then MkDir strPath End If Shell "EXPLORER.EXE " & strPath, vbNormalFocus In Outlook, I have a macro that...

You're right. I wasn't looking at the actual code. I was reading the remarks section. Here's an excerpt from the third paragraph of that section. "...There is no limit to the number of bookmarks you can establish. To create a bookmark for a record other than the current record, move to...