Search results for query: *

I have scheduled task on a 2003 server that as long as the user the the task is setup to run as is logged on runs fine(takes about 30 seconds). If the user logs off the server the task does start but the status when we log back on to check it about 30 minutes after it started has a status of...

I need to export records from an Access table to a text file in fixed length format. I was going to use transfertxt but I need to append it to an existing file. I tried using the write command but it will only do comma delimited and the print command isn't working either. Is there a way to do...

I've taken over a project from someone else and the code was written using DAO. I prefer to use ADO but this is a huge amount of code and converting it all would take to much time. Can I start using ADO or would the mixed environment cause issues? Thanks, Anthony

I'm able to put PCAnywhere in host mode and connect to it using TCP/IP, but I can't remote out from it. I've setup the packet filtering for ports 5631 and 5632 which is what got me working in host mode, but I really need to get it going the other way also. Any suggestions? Thanks, Anthony

I've setup a system DSN to an access database (which is on a network drive). When I attempt to run a crystal report V7 logged on to the XP machine as the user I setup the DSN up as the report runs fine. If I log on as a different user and run the report I get the Cyrstal report parameter box...

Hi I know you can export a list to excel, but can you export one record from a list to excel or better yet do a mail merge to a word document from a record in a list. I hope I explained what I need clearly. Thanks, Anthony

Can anyone tell me where I can still download the service packs for version 7? Thanks, Anthony

Hi I have an Access 2000 Database that myself and someone also both need to develop in. If we uses VSS will it allow both of us to be in the database at the same time while working on different forms? And if so how do I set it up because I can't get it to work. Thanks, Anthony

Is there an easy way to use and save a Stored Procedure as the Data Source for an Excel Pivot table. Thanks, Anthony

I have problem when using the round function to round a calculation, for example; the value $433.125 rounds to $433.12. If I make the number $433.1251 or 433.126 it rounds correctly to $433.13. I can run it on two different machines with the same version of Access and service packs and it...

I have several running totals on a report that are printing blank when the value is zero. How can I get it to print a zero instead? Thanks, Anthony

I can create a new user DSN using the SQLConfigDataSource command, but what do I change to create a system DSN? DECLARE Integer SQLConfigDataSource in odbccp32.dll Integer, ; Integer, String, String settings="DSN=testing"+chr(0)+; "Description=VFP ODBC...

Does anyone have a way around this issue? I'm using Microsoft Access project or Access 2000. The problem has been around longer then this.

I am attempting to import pictures into a SQL 2000 database with the code posted below using a command button on a form. Before I run the code if I click on the picture object on the screen it tells me that it is empty. After I click the command button I get the following message (this is part...

I have a program that at night automatically runs and sends email notifications out. Periodically the exchange server will be down when the program runs and when I come in the morning the annoying outlook message about whether I want to work offline or cancel will be on the screen. My question...

I need to read the email address that an email was sent to from the sent items folder. I can only get it to pull the name and not the email address. Is this possible? Thanks, Anthony

I have a program that uses MAPI Controls. The program runs fine on every machine except one. I get an error message 'Class definition MAPI.SESSION is not found. The only things different about that machine and the others is that it had 98 and was upgraded to 2000 (the others came with 2000)...

I am exporting a report to an RTF file everything works great except the an export options box comes up and asks for the page range to export. What property do I need to set to get it to bypass this and export all pages. Thanks, Anthony

Hi I have two tables that are linked (class and enrollment). My report will only print records that are in both tables. For instance if I have a class and it does not have anyone enrolled it does not print just the class record. How can I get it to print the class information even if it does...

Question I have read all the discussion on the licencing for V8.5 and I am still confussed. If an office has 8.5 professional and the 5 free concurrent users that comes with Enterprise and an office has 75 employees that need to run the reports only on their LAN, but only a few people a day, I...