Search results

Hi, What I do is link the GAL to my DB and run a query against the linked table to create a table that I later work with. When you want to update it you can either overwrite the table or loop through the linked table and add/modify the entries as needed. HTH, Simon B.

Oh! I thought your code was inside an Access app... IF it is in the workbook, why do you want to make it dynamic? It will always look for the same thins anyway no? To edit it again, just rename the "Source" workbook temporarily, the on open will crash, and you'll be able to modify it...

Sorry I didn't close the objects... ObjXLBookDest.Close ObjXLBookSource.Close ObjXL.Quit But I don't see how it can flood your task manager... 1 application opens 2 workbooks... Is your sub called in a loop??

Hi, Here is how I made it work: Private Sub Workbook_Open() If WorksheetExists("Summary") = False Then Dim ObjXL As Excel.Application Dim ObjXLBookSource As Excel.Workbook Dim ObjXLBookDest As Excel.Workbook Dim ObjXLSheet As Excel.Worksheet Set ObjXL = CreateObject("Excel.Application")...

Hi, You need to make sure the form is open in normal view. Other than that, check your spelling or something because it should work (I use it quite often myself...). Simon B.

Hi, I think that when you open a document (.doc, .xls, etc) from a website a copy of it is saved in a "temporary" location. With that location you could probably used docmd, as long as the file name is always the same... But honestly, if you are to write to the Excel file, you're most...

Hi, In your match criteria you could use Format(SSN_Field, "000000000"). It will add leading zero's as required. Simon B.

Hi, I suggest you create a VBA procedures that will loop through a recordset. You will then be able to write the output file exactly as you need it. I did that a lot and that's the best way to get a "custom" output. Simon B.

Hi, Do you need the data in real-time? If not, you could create yourself a copy of this table (minus the indexes) and update it as needed with the "master" table. Or maybe you can create a view and link to that? Simon B.

Thanks Banana! That worked using the "minimum code" to create it with VBA. However, I did try the same thing earlier by including the connection string and table name in the CreateTableDef method arguments, and for some reasons that won't work... Simon B.

Hi, What method do you use to send the email? If you use DoCmd.SendObject, there is an option (in the argument list) named EditMessage that you will need to set to false, this way, the message will not show on screen and be automatically sent. If you use the Outlook object, it is not as...

Hi, Try Me.lstData1.Requery after changing the rowsource... Simon B.

Hi, Does anyone know how I can change the connection string on a linked table (Exchange). I did attach the Exchange GAL as a table with the wizard. It works except that it looks for a Schema.ini file in C:\DOCUME~1\bousi8\LOCALS~1\Temp\ which is MY folder. The problem is that multiple users...

Hi, Try splitting strBuffer instead of strFile :) BTW, you have two strange characters at the beginning of strBuffer that dont show up when opening the file... insert a Debug.Print strBuffer to see them... Simon B.

Hi, If use = '*' in SQL, it will look for the character * (ascii 42) If you want tu use the wildcard you'll have to use: field LIKE '*' Simon B.

Well... the .Attributes method will work for "real" tables but not linked ones. I've checked the vPPC thing and it looks like a very nice solution, but WAY to much work for what I need... In fact, I don't really need security, I was more interested in how far I can protect my db... Thanks to...

Sounds interesting... I'll give that a try and let you know next week... Thanks, Simon B.

Finally, not exactly what I wanted... If the "Show hidden object" is on in the blank DB you can see the hidden tables... Simon B.

Thank you David! That does exactly what I wanted!!! Simon B.

but that would be a pass-through query, which is executed on the back-end... not executed by Access...