Search:

Type: Posts; User: kwvh; Keyword(s):

Page 1 of 20 1 2 3 4

Search: Search took 0.04 seconds.

  1. Replies
    9
    Views
    1,530

    Patt and John, THANKS! ! ! Yes, you are able...

    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...
  2. Replies
    9
    Views
    1,530

    I use the ExportXML command in VBA to create the...

    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...
  3. Replies
    9
    Views
    1,530

    XML Primer for Access neophyte

    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...
  4. Replies
    8
    Views
    10,568

    Bender, thanks. will try to get it to run in...

    Bender,

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

    Ken
  5. Replies
    8
    Views
    10,568

    Boyd, THANKS ! ! What an excellent tool! I will...

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

    Ken
  6. Replies
    8
    Views
    10,568

    Thanks for the information. I will research the...

    Thanks for the information. I will research the third party libraries and see what works.
    Thanks!
  7. Replies
    8
    Views
    10,568

    Copying files from FTP location via VBA

    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...
  8. Replies
    1
    Views
    646

    I have an mdb that runs on three workstations....

    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...
  9. Replies
    1
    Views
    1,301

    I have a legacy program that transitioned from...

    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. *...
  10. Replies
    7
    Views
    1,331

    Rory, Thanks for your help.  I don't know what...

    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
  11. Replies
    7
    Views
    1,331

    Actually, this is an Access database that creates...

    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...
  12. Replies
    7
    Views
    1,331

    Rory, Thanks for asking.  The values for Final...

    Rory,

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




    Ken
  13. Replies
    7
    Views
    1,331

    With help from here, I was able to create pivot...

    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 :
    ...
  14. Replies
    4
    Views
    6,538

    Wendell, Thanks for the note.  I am just...

    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,...
  15. Replies
    4
    Views
    6,538

    Awesome Andrew!  I am going to use the loop...

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




    THANKS!
  16. Replies
    4
    Views
    6,538

    Is it possible to read the names of the fields in...

    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...
  17. Replies
    2
    Views
    458

    Thanks!  Using your suggestion I came up with: ...

    Thanks! *Using your suggestion I came up with:




    Dim strPath As String


    strPath = Application.CurrentDb.Name
    If UCase(Right(strPath, 3)) = "MDB" Then
  18. Replies
    2
    Views
    458

    Sorry for what may seem as silly, but I can't...

    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?
    ...
  19. Replies
    31
    Views
    2,101

    Wendell, Thanks for the followup.  Yes, there...

    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...
  20. Replies
    31
    Views
    2,101

    Wendell, Thanks for the followup.  Yes, there...

    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...
  21. Replies
    31
    Views
    2,101

    Wendell, Thanks for the followup.  Yes, there...

    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...
  22. Replies
    31
    Views
    2,101

    Wendell, Thanks for the followup.  Yes, there...

    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...
  23. Replies
    31
    Views
    2,101

    Wendell, Thanks for the followup.  Yes, there...

    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...
  24. Replies
    31
    Views
    2,101

    Wendell, Thanks for the followup.  Yes, there...

    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...
  25. Replies
    31
    Views
    2,101

    Wendell, Thanks for the followup.  Yes, there...

    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...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4