Search results for query: *

vbajock - thanks for the reply. These 108 databases are not used by end users instead they are just kicked off at various times by either a TechSheduler or another Access database (Report Runner) that may run up to 50 Access databases synchronously. My concern was how would the Shared Code...

Greetings... I work in an organization that is using Access to generate both PDF and Excel reports. We have 3 report servers running and a total of 108 Access databases creating all of the reports. Most are pulling data from either Oracle or SQL server and manipulating the data and then...

Thank you both...I will look at these solutions this weekend. Both look better than the code I had doing this.

Greetings... We maintain a database for a client as a relational (one to many) database and the client would like us to provide a "flat" file of the data for them to have inhouse. Current data example ID ShowCode 10001 CH09 10001 LB09 10001 RN09 10002 CP08 10002 CP09 I...

If your not opposed to purchasing a third party tool we use PeopleSmith tools. You could use either Personator or RightFielder. This would require you putting your data into a "DBF" file first. Both products have tools to assist with this if needed. Personator $395 will split and genderizes...

Just an FYI that the Stored Procedure is working well... Thank you for your responses, I just wanted to see if there was a different way of handling this.

I need to execute an UPDATE query against SQL Server up to 7000 times and I wanted to use the SQLPREPARE command to speed things up. The problem is I need to know how many rows were affected by each update. Is there away to get this information? I can not use "SELECT @@ROWCOUNT AS affectedRows"...

In VFP if you hold down the shift key and click on the "Format" menu item the first option will be "Screen Font" which you can change to what ever you like. I use courier new - regular - 9 which fits every thing on one line like you are looking for. -Joe

I have a macro that calls several VBA modules along with a couple of queries. If I have an error in the first module I want to exit out of the Calling Macro. Currently if I have an error in the first module I exit that module but then it goes into the second module and so on. Any help would be...

Greetings... Is their anyway to base a remote view on an INNER JOIN with a local dbf? I have a local dbf (qty: 179) and I want to select only the records that match via "SUBS" field with a SQL table (qty: 500,000+). I've done it using a remote view on all 500,000+ records but I...