Search results for query: *

I have a bunch of stored procedures that I call from my vb6 app and they work great. The problem is that some new ones may be very long. Is there a way to open the connection, call the proc using ado and then finish and let the proc run in the background? I'm not finding much at all when I...

I have one main stored proc that sets a table variable and then loops through the records. After setting the vars I call my other proc that has an output param I need. As I perform the loop...the input to the 2nd proc changes and I expect the output param to change was well. I can verify...

Can anyone help me understand why the following is failing? '--- Dim fso as object Set fso = CreateObject("Scripting.FileSystemObject") fso.CreateFolder "H:\data\temp" '--- I get a 76 - path not found error every time If I change the above code to run this it works... fso.CreateFolder...

I am trying to utilize the same functionality I built in VB6 in access and i'm finding that the MSFLEXGRID seems different? I can't seem to find any information on using an MSFLEXGRID in access either via google or here. I'm just trying to figure out why certain events are not available in...

Just a quick question...trying to understand why someone used "global" instead of "public" to declare a public var... I have a var declared as public in a standard module/declarations section...that means this variable should be visible throughout all modules (even a form's module) correct? I...

Just looking for a little tip as to what is a better way to go...Is it better to open one global connection to the Current Project Connection or open and close the connection as needed? I have always done it where I open and close the connection as needed but I was curious if one single open...

I have a generic question that I am looking for some guidance on...here is the situation... The main goal is to remove out extra commas (within double-quotes) and trim leading/trailing spaces from each field in a comma delimited file. sample data row: CODE," Name, Name ", CODE2, CODE3,#...

I have a public function that processes some data manipulations. I wanted to create a new sub that does the "data conversions and checks". My sub is not returning the correct data and I cannot figure out why. Here is a snippet...minus all the middle junk...

Well second question in as many days...but I had to. I have googled and read all morning and can't find a good answer that works in VB6. I have some basic Enums that I'm trying to return the String value associated with them. I cannot seem to get anything to work. I am trying to NOT have to...

I have created a simple disconnected recordset in one of my apps that just tracks record processed and some other data on the fly. I'm wondering if there is a way to assign a primary key value to the first field I appended in the recordset. I have searched and searched and cannot find any...

I have a strange problem that I cannot seem to figure out. Here is the setup: I have a form that is opened from the main menu. On this form there are a few combo boxes. If the user selects a value from the combo box it calls a sub that will attempt to enable/disable fields on that same form...

Did a search and cannot seem to find any information...I have a bunch of citrix servers that we need to do periodic maintenance on. I can successfully map a drive to each server amd delete the folder under "Documents and Settings" but I cannot seem to find any code that will allow me to do the...

I have a vb routine that uses a ADODB command to run a sql stroed procedure. This routine has been running fine for a long time now but we have a new wrinkle. They modified the SQL stored proc to have a "Print" statement in the first few lines of the proc and this is causing my VB routine to...

I have a simple little application that I am using to check a folder for files and if any are found, it moves them to another location. The program has been set up to stay running and use the Sleep API. There isn't much complexity to it and inside the Sleep loop there is a DoEvents. There is...

I have a simple msflex grid that i created to be used as a dialog box for a user to select a record. I have it all working very nicely but I noticed my mouse scroll wheel doesn't work in this control. Is there a setting I'm missing or is it not compatible? I know it will work if I click in...

I've been using a nine little winsock smtp set up for a while but now wish to try to use cc and bcc but I cannot get the syntax to work. I can get the lines to show up in the CC: etc but I cannot get the send to work. If I add the cc's to the RCPT TO: calls then they show up in the sent to...

I have an ms flex grid that I am trying to figure out how or if I can get the right click event to move the col/row position to the cursor. What I have now is a floating menu that popups up when the user right clicks on the flx grid col 0. The menu opens at the cursor point. The idea being...

I have developed many Access 2000 databases that are distributed as .mde files. I have a user that upgraded their PC to 2003 and now says they cannot open it. Just did a search here and found some info but I am a bit confused. Shouldn't Access 2003 be backwards compatible? Is there anything...

I have a quick question that I am not having any luck getting past. I have a tabbed main form and check boxes on one form. If the check box if checked I want to disable all the fields on a form on another tab. The problem is that in a few cases this means 'all' the fields that can possibly...

Trying to use a string variable to create a form name reference and i just can't get it to work. Found some help here on the boards and tried this but I generate an error. The error is "...can't find the form 'MasterdataSplitInd' referred to in a macro or expression or visual basic code."...