Search results for query: *

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.

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...

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.)

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

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...