Recent content by APS

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

Any chance of getting a quick example? I've never used it before. Thanks, Anthony

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

Can give me more detail on what you did to resolve it. I think I'm having the same issue and I'm new to ISA. What 4 definitions and rules did you set up? I set up the packet filtering also. 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 attempting to avoid having to set up the ODBC source on all the machines. Which I will have to do first to use the SqlStringConnect command, correct?

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