Search results for query: *

I have a scheduled task that runs in Access 2010. It reads a .dbf file and creates an Excel file that is used by other processes. It works fine on my old PC, a 32-bit XP machine. I am not able to get it working on my new 64-bit Windows 7 machine. Both are running Access 2010, but my old PC...

I have a batch job to rebuild about 100 files. The batch job ran successfully on a test server, but not on the production server. Three of the files got an error 3 during the rebuild. One of the files is very large, with 17 extensions. Another is large with one extension. The third file is...

I posted this in the Access - Tables section, but have not had a response, so I thought I would try here. I have several Access applications that use 3rd party software. One of the databases is Visual Fox Pro, another is Pervasive (btrieve). As far as I know, there is no 64-bit driver for these...

I have several Access applications that use 3rd party software. One of the databases is Visual Fox Pro, another is Pervasive (btrieve). As far as I know, there is no 64-bit driver for these two databases. I am able to set up the ODBC on a 64-bit laptop using the odbc32ad.exe in SysWOW64...

I have set up the ODBC connection to our Pervasive database on many PCs. I had one PC that got the error "The setup routines for the Pervasive ODBC Client Interface ODBC deiver could not be found. Please reinstall the driver." This error was displayed as soon as I clicked on the Pervasive...

I recorded a macro in Excel 2010 to run a saved query and return the data. When I run the macro, I get a run-time error 5, invalid procedure call or argument. This is the code generated by the macro recorder: Sub Macro5() ' ' Macro5 Macro ' ' Workbooks.Add With...

I am trying to export a table to a comma delimited file in Access 2010. I am getting quotes around every field, which I don't want. I have read about exporting it manually and selecting the Advanced options to get rid of the quotes, but I can't figure out how to export manually to comma...

We have an Outlook form designed by a former employee that we are trying to maintain. It has a print button on it that executes a script when clicked. If I have the form open in design mode and click on 'Run this Form', and click on the print button, it prints. However, when the form is...

We will be converting from Office 2003 to Office 2010 within the next couple of months. Ideally, I would like a 10-15 minute video that gives an overview of how Office 2010 is different. This would be for our accounting department initially. Does such a thing exist?

I have four .dbf files that I set up an ODBC for, using the VPF driver. When I selected the path in the ODBC setup, it showed me all four files. However, when I try to use it in Crystal Reports or Access, it only shows three. I am able to open the fourth file in Excel, so I don't think it is...

I have a table that looks like this: ResNum Room DischDate 001004 1139 10/03/08 001004 30 01/01/09 001007 208 03/03/08 001007 1335 12/17/08 001012 16 07/13/08 001012 1144 07/29/08 001012 1127 12/02/08 I want to find out what...

I have an application on the network shared by several users. It has a form where the users select a date using DTPicker. I am having a problem with one user. On his PC, the date field looks like a text box rather than a combo box. There is no way to select a date because there is no...

I am writing an application for a nursing home environment. I have a form that allows a user to select a resident number, and all the 'incidents' for that resident are displayed. The basics of the incident (date, time, place) are displayed for each incident for that resident. The user can...

I have Access 2000 Professional version. I am able to put an Inet control on a form, but I can't get it to do a Get or Put to the FTP site. Do I need the developer version, or am I doing something else wrong?

We have many files on our network that are maintained by multiple users. We have always gotten a warning message when one person tried to open a spreadsheet that someone else already had open. Since we have been upgrading the PCs to Windows XP and Excel 2002, we are not getting the message...

I have a Crystal version 8 report that I am exporting to a csv comma delimited file. Any time there is a negative number, it exports it as (50000, without the right parenthesis. (This occurs for any negative number.) I have expanded the field to be 4 inches wide and that doesn't help. I have...

We have several compiled reports that run on different workstations on different printers. The reports are set up as landscape, but when they are run on the workstations, they print portrait. I am using version 8.0. I followed the instructions on the web site for the same problem with version...

I need to print a number of labels based on a quantity field in the database. For example, if there were 50 of an item ordered, I want to print 50 of the same label. I don't really want to do separate detail sections. I am using Crystal 8. How do I use looping to print multiple labels?

I have a database of race participants. I want to enter their race times by entering race number and finish time. I am doing this with a continuous form. The race number field in unbound, and is used to verify that it is a valid race number and to update the record. It updates the record...

I want to delete a record with VBA in Access 2000, but I don't want the user to have to confirm it. I tried using Application.SetOption "Confirm Document Deletions", False before the delete and then setting it back to true afterwards, but I am still getting the confirmation message...