Search results for query: *

Is there a way to reference a function by use of a variable. For example, function name is "MyFunction" and it takes parameter "A". If I set a variable (type variant??) named "myVar" to equal "MyFunction", will this work? x = myVar("A") I know it won't work the way I've shown it, but is there...

Quick question for you gurus out there: We have Ver 7 Pro and want to upgrade to Vers 10 Developer. a: Can we buy the upgrade package or do we have to buy the full monty? Thanks.

We have a VB app that is deployed to about 10 sites, with about 60 users, all connected via T1. Now, a new site is coming online and they will not be connected on the T1. The only way I will be able to reach them is via TCP/IP. Does anyone have any experience with this? Thanks.

We use a "update" app to update the db in a VB app. The update app applies db patches as needed, such as ALTER TABLE, CREATE TABLE, etc. We also use it to CREATE PROCEDURE. This all works well until our new procedure contains quotes to handle varying params, such as: CREATE PROCEDURE...

Here's the current code, where "@Parm1" is the passed table name: BEGIN SET @stg1 = "UPDATE " + @Parm1 + " " + "SET dteLast = " + "(SELECT MAX(tblHealth.dteDateEntry) " + "FROM tblHealth " + "WHERE...

In a VB6 app, we have a module that updates the db when necessary with new/modified fields and tables. Basically, we use ADO and it works just fine. However, we will probably have to edit or add some SPs as well. How can this be done thru VB? Thanks

We distribute an app that allows users to use either Access or SQL Server as the database. From time to time, we may have to modify the database. Since "ALTER TABLE" will not work with Access, can someone give me a way to do it? BTW, the Access db is password protected. Thanks

I am trying to construct an SP that will allow me to pass a fieldname (always a boolean/bit field) as well as a value for that field. Here's what I've got: CREATE PROCEDURE write_calendar_value_boo /* @Parm1 not used */ @Parm2 varchar(50) , -- The Field Name @Parm3 bit , -- The Field Value...

We've been tasked with developing a "dictation" module for physicians that allows them to record patient notes through their computer mic. Problem is, they have to be able to begin, pause, playback, append, etc. just as if it were on a tape. By "append", I mean that they will...

This code is taken straight from MSDN. However, when it tries to execute the Append method into an Access XP database, I get "Err 3251, Object or provider is not capable of performing requested operation.": Dim cat As ADOX.Catalog Dim usrNew As ADOX.User Set cat = New...

When adding a new user under Access97, the following code always worked: Dim NewUser As User Dim NewWorkspace As Workspace Set NewWorkspace = DBEngine.Workspaces(0) Set NewUser = NewWorkspace.CreateUser(txtUserName, txtPID, txtPassword1) NewWorkspace.Users.Append NewUser...

We have an app in VB6 that is running on a number of Win2K boxes. Only those users who have Admin rights can run the app successfully. The others get "xxxx.ocx not found" or similar errors, even though we can see the files in their System32 folders. I think the network administrators...

We created a VB6 app into a SQL Server database and designed the CR reports. They all worked fine. Then, when I ported the app to my client's machine, the reports would not work. The 20599 (Cannot open SQL Server) error appears. On the CR KB, I found an article that says to use File Location...

We created a VB6 app into a SQL Server database and designed the CR reports. They all worked fine. Then, when I ported the app to my client's machine, the reports would not work until I went in and changed each one to reflect the name of his SQL Server. With my Server name in, the report would...

This is our first SQL Server based app, written in VB6. Our client is a govt agency and purchased SQL Server7 w/10 client licences, but no documentation whatsoever came with it. I installed SQL Server on their server. I want to have one of the clients be able to run Query Analyzer and...

When I used to program in FoxPro, there was a function named "On Key Label", which, when defined, would make a keystroke combination execute a particular piece of code throughout the app. You would declare it in "sub main" and it would work everywhere. For example: "ON...

When I install an app developed with VB6 and Access97 on a Win2K machine, I get the following at the very end of the installation process. The install package is developed with MS Package & Application Wizard. *** ERROR: The file...

A client of mine was installing a VB6 app on his NT4 box and got the following error in the install log: *** ERROR: LoadLibrary() failed while registering file 'C:\WINNT\system32\msadox.dll' *** DURING THIS ACTION: DllSelfRegister: "C:\WINNT\system32\msadox.dll" Anyone knw\ow how to...

I'm trying to update an Access97 table (tblA) with data from a 2nd table (tblB) using an INNER JOIN statement. This is what I'm using: UPDATE tblA INNER JOIN tblB ON tblA.ID_field = tblB.ID_field SET tblA.Field1=tblB.Field1, tblA.Field2=tblB.Field2 Can't get it to work. Anyone??