Search:

Patt and John,

THANKS! ! ! Yes, you are able to "Add" multiple tables into the same XML file. Very sweet. I seem to always look for and find the hard way of doing things. That is why this is...

I use the ExportXML command in VBA to create the two files. Is there a way to find a specific line in a text file using the File Input/Output you mention? If so, I could create the large xml file...

I am trying to create a single xml file with two tables as the source. One table has a single record, and the other table has lots of records. The table with the single record is to be the header...

Bender,

thanks. will try to get it to run in VB.NET, which I am brand new to.

Ken

Boyd,
THANKS ! ! What an excellent tool! I will give it a shot. It looks really well done.

Ken

Thanks for the information. I will research the third party libraries and see what works.
Thanks!

I am seeking a method of copying files from and ftp location using VBA. I have a batch file that does what I need, but prefer a VBA solution. I have tried using VBA to call a batch file that calls...

I have an mdb that runs on three workstations. All workstations are running Windows 7 Enterprise and Office 2007. On one of the machines the user is prompted for the SQL Server Login every time a...

I have a legacy program that transitioned from Access backend to SQL Server a few years ago. *Then we added and ASP.net page for data entry, but continued to use the Access front end for reporting. *...

Rory,

Thanks for your help. *I don't know what I would do without help from the experts on the boards.

I will post when I figure it out the final disposition. *




Ken

Actually, this is an Access database that creates the spreadsheet, then via VBA creates the pivot table. *So initially, there is only the tab with the data, and the pivot table gets created to an...

Rory,

Thanks for asking. *The values for Final Row and FinalCol are 85 and 28 respectively.




Ken

With help from here, I was able to create pivot tables via VBA in Excel using Access to automate the process. *Until recently, the following code worked fine, and now I get an error on the line :
...

Wendell,

Thanks for the note. *I am just trying to "clean up" some inconsistent naming conventions in a some Access tables prior to upsizing the tables to SQL Server. *I will be creating queries,...

Awesome Andrew! *I am going to use the loop through the fields approach.*




THANKS!

Is it possible to read the names of the fields in an Access table and rename the fields? *I have three tables, one with several fields, and I need to change the name of the fields. *I would prefer to...

Thanks! *Using your suggestion I came up with:




Dim strPath As String


strPath = Application.CurrentDb.Name
If UCase(Right(strPath, 3)) = "MDB" Then

Sorry for what may seem as silly, but I can't find anything by searching here. Probably using the wrong syntax.

Is there a way to determine in VBA is the program executing is an mde vs. mdb?
...

Wendell,

Thanks for the followup. *Yes, there is VBA Code. * I have 7 references in the VBA project, and all appear to be there. *For the sake of expediency I added a module in VB to update the...

Wendell,

Thanks for the followup. *Yes, there is VBA Code. * I have 7 references in the VBA project, and all appear to be there. *For the sake of expediency I added a module in VB to update the...

Wendell,

Thanks for the followup. *Yes, there is VBA Code. * I have 7 references in the VBA project, and all appear to be there. *For the sake of expediency I added a module in VB to update the...

Wendell,

Thanks for the followup. *Yes, there is VBA Code. * I have 7 references in the VBA project, and all appear to be there. *For the sake of expediency I added a module in VB to update the...

Wendell,

Thanks for the followup. *Yes, there is VBA Code. * I have 7 references in the VBA project, and all appear to be there. *For the sake of expediency I added a module in VB to update the...

Wendell,

Thanks for the followup. *Yes, there is VBA Code. * I have 7 references in the VBA project, and all appear to be there. *For the sake of expediency I added a module in VB to update the...

Wendell,

Thanks for the followup. *Yes, there is VBA Code. * I have 7 references in the VBA project, and all appear to be there. *For the sake of expediency I added a module in VB to update the...