Search results for query: *

What is the preferred way to set an inital folder for the SHBrowseForFolder API function? Jim Varco jimv@varcconsulting.com

Can someone point me to a source for VB code to build a list of currently attached SQL DB's. This would be the same list as shown in ODBC Administrator in the "Change the default database to:" dropdown list for SQL Server connections. Jim Varco jimv@varcconsulting.com

For use internally to my VB apps I sometimes create disconnectd recordsets, using the column properties of the connected recordset, then copy the desired data. The problem I have is that if the data is anything other than character, I get a "Multiple-step operation generated errors" error when...

Can anyone point me to code to build a list of currently attached SQL databases, using Visual Basic? Thanks Jim Varco jimv@varcconsulting.com

Does anyone know how to delete all of the values under a specific Registry key, leaving any sub keys alone? I have code to delete a Registry key if you know the value name. I may not know the name, I need to loop through all of the values and delete them. Thanks, Jim Varco jimv@varcconsulting.com

I need to do some testing that requires me to be able to use both a DB with a trusted connection and also with SQL Login, not necessarily on the same DB. I am testing using a system running MSDE and am not seeing how to setup a SQL Login with user ID and password. Can anyone point me in the...

After running MSDE without issue for many months, it will no longer connect. I have tried reinstalling it, the install progresses to where it displays the "Starting Service" message and then reports an error. The error is "Setup failed to configure the server. Refer to the server...

I am having trouble removing tables that I no longer need from a report in v9. If I go into Database Expert and have tables "Table1", "Table2", "Table3" listed on the right and select "Table3" to remove it, I always get the first table, "Table1&quot...

What is the preferred way to create and set environment variables within a VB app? I need a VB app to create & set some environment variables that will then be available to another app executed from within the VB app. After this app closes I want to destroy the environment variables previously...

I have a VB6 app that uses MAPI. Do I need to distribute any MAPI related files, and if so which ones? From time to time I have someone inform me the app is erroring out due to the lack of a MAPI file. Any help will be much appreciated. Thanks, Varco Jim Varco jimv@varcconsulting.com

In Crystal v9, can grouping be created based on calendar dates, with the date range being entered via parameter? There may or may not be data associated with each date in the range, the group still needs to be displayed. Thanks. Jim Varco jimv@varcconsulting.com

Is MAPI the "preferred" way to allow users to send emails to me from within my apps? I have it working well on my development system, still need to test on another system. Jim Varco Varco Consulting jvarco@varcconsulting.com

Does anyone know how to disable the mouse right-click ability, say before a form is loaded, and restore after the form closes? Jim Varco Varco Consulting jvarco@varcconsulting.com

I am trying to retrieve data from multiple tables in a FoXPro DB, using ODBC and VB. The tables may be joined using either an equal or left join, and may have several of each type of join. I have queries that work fine for any number of equal joins, or a single left join. Where I run into...

A VB app that I created and that reads data from a Visual Fox Pro database using ODBC, works fine on my system and on my test system. When installed on another system it failed, with the following message: ODBC error [Microsoft] ODBC Visual Fox Pro driver- not enough memory for file map. In...

I need to be able to use one of two different CR v8.5 DSR's from within VB using RDC, depending on the DB the user has. The reports are identical, except configured for the respective DB's. Any suggestions on a clean way of doing this? The VB app will have a flag to determine which report to...

If a report is created in V8.5, and using the RDC is compiled into VB, a distribution files set is created and then installed on a machine that has V7 or V8 installed. Will there be a conflict with the older files if the user is still using V7 or V8? Jim Varco Varco Consulting jimvarco@att.net

I have a situation using V7 of Crystal that I need to display dates in the report, however they are stored in the DB as a numeric field using the format 20010702.00 to represent July 2, 2001. I have worked out several different ways to convert this value and use it with the date command, most...

I have a Crystal V8 report compiled int VB6 that when it has been installed from the distribution file set and the report preview window is displayed, will generate the "Program performed an illegal operation and will be closed" error message as you try to exit the preview screen. One...

I have a Crystal V8 report compiled into VB that is running against a SQL database. A valid ODBC connection has been established and tested, however when the report runs we get the message "Server has not yet been opened". Any thoughts? Jim Varco Varco Consulting varco@compuserve.com