Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. RichardBarth

    Linked Tables - Modify Structure

    Thanks, that works. What a simple answer. Actually, I had thought about Alter Table but erroneously assumed that it wouldn't work based on the fact that I click on Design for a linked table I cannot change any of the structure. I guess I shouldn't have "assumed.
  2. RichardBarth

    Linked Tables - Modify Structure

    I have an application where all the forms/queries/reports/modules are in one .mdb ("main") and the tables are in another ("table") .mdb. Of course, the tables are linked in the "main" .mdb. This application has been distributed to many locations. I need to make a change in the software. Well...
  3. RichardBarth

    Access FoxPro via OLEDB provider

    Thanks, Jim. That's perfect. Works like a charm. (Why didn't I think of that. I used to program in dBase and Foxpro for years. But that was over 15 years ago. How quickly we forget.)
  4. RichardBarth

    Access FoxPro via OLEDB provider

    That's super, OlafDoschke. Do you know of any I can identify or bypass the deleted records in the table?
  5. RichardBarth

    Bypass deleted records

    I've finally managed to access Foxpro tables with the OLEDB provider. Using the code: dim Conn as new adodb.connection dim rst as new adodb.recordset conn.provider = "vfpoledb" conn.open "c:\foxprodata" rst.open "mytable", Conn, adOpenStatic, adLockOptimistic The problem I'm having is that...
  6. RichardBarth

    Access FoxPro via OLEDB provider

    I have an Access application in which I need to process several FoxPro free tables (.dbf's) in multiple directories. Rather then creating multiple ODBC DNS entries, I prefer to access the tables via ADO using the oledb provider. Can anyone help me with a sample of the code I need to create...
  7. RichardBarth

    Linking ODBC tables

    I found the answer to this one!!! It seems that Norton AntiVirus 2006 has a feature that addresses Office addins, and is turned on by defaut. This feature prevented me from accessing ODBC databases from the Access Link/Import dialogs. Once I turned off this feature, everything worked fine. It...
  8. RichardBarth

    Linking ODBC tables

    I have some Foxpro tables that I need to process with Access. I installed the FoxPro ODBC driver and set up a system DSN for foxpro tables. Now for the strange thing: When I go to File/Get ExternalData/Import and then select the filetype of ODBC databases, the window just closes. I don't get...
  9. RichardBarth

    Print to File

    This must be simple, but I've never coded this before. I have an application with a report. The user would like the option of sending the report as an attached PDF file. I'm able to launch Outlook and attach a file easily enought. However, how do I create the PDF file and now have the...
  10. RichardBarth

    Vertical Column Shading

    Ginger, I've tried your code and it's quite elegant. In fact, it works perfectly - sort of. The results appear perfectly shaded, even on the longer rows resulting from "can grow" in Print Preview. However, when I actually print the page, all of that shading is gone!! Any thoughts would be...
  11. RichardBarth

    Vertical Column Shading

    Michael is correct. The issue is not how to cause shading to appear that's easy. Even shading columns is not difficult. The issue is how to do it in selected colums where one of the columns (not shaded) is set to "can grow". When the data in that column is sufficient, it causes the entire row...
  12. RichardBarth

    Package Wizard - attaching script file

    I'm using the package wizard that came with Access Developer Extensions in the Visual Studio Tools for Office 2003 to distribute an Access application. As part of the installation procedure, I need to run a script. I've set the script up as a chained file with a type of .EXE (per the guidelines...
  13. RichardBarth

    Including fonts with package wizard

    I'm trying to create a distribution for an Access package. I'm using the package wizard that comes with Visual Studio Tools for Office 2003. I have a font that needs to be distributed (yes, I have distribution rights for this font). All I need to do is to have this font file (xxxx.ttf) copied...
  14. RichardBarth

    Vertical Column Shading

    I have a problem where I want to shade vertical columns. The obvious approach is to change the background color of alternate columns. That works, but my problem is that one of the fields on the row is "can grow". When that field expands to require an additional row, then there's a gap in the...
  15. RichardBarth

    Report Format: Vertical Shading

    I have a similar problem where I was to shade vertical columns, but my problem is that one of the fields is "can grow". When that field expands to require ad additional row, then there's a gap in the vertical shading. I've tried changing the height of the shaded fields in the print format event...

Part and Inventory Search

Back
Top