Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. JeffCarlin

    Referring to a Procedure By Reference

    Inside a bas module, which runs the routine.
  2. JeffCarlin

    Referring to a Procedure By Reference

    Thanks Joe. It's a little more complicated than your example, unfortunately. We won't be working off a form or data input of any kind; we'll be reading values from an ini file and calling various functions based on the value's, uh, value. So, I tried the CallByName function, using "Me" as param...
  3. JeffCarlin

    Referring to a Procedure By Reference

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

    Upgrade to Vers 10

    Thanks.
  5. JeffCarlin

    Upgrade to Vers 10

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

    VB Connection to SQL 2K via TCP/IP

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

    Create Procedure with quotes thru VB

    It's the creation that fails. If I were to manually create the SP, it works fine. The error message is a syntax error. I'm pretty sure it has to do with the "plus" characters or the quotes. I've played around a lot, but can't seem to find the answer. The code shown above is the actual...
  8. JeffCarlin

    Create Procedure with quotes thru VB

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

    Trouble with MAX in Stored Procedure

    Works like a charm. Many thanks Mukund.
  10. JeffCarlin

    Trouble with MAX in Stored 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...
  11. JeffCarlin

    Creating Stored Procedures in VB

    Great, thanks. Guess I treat it like any other "create" statement. Just execute the damned thing! Thanks again.
  12. JeffCarlin

    Creating Stored Procedures in VB

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

    Using ADO to append an Access field

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

    Using a 'bit' vs 'int' in a Stored Procedure

    Thanks, Angel...works like a charm.
  15. JeffCarlin

    Using a 'bit' vs 'int' in a Stored Procedure

    ...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 @Parm4 varchar(11) , -- The Patient's SSN...
  16. JeffCarlin

    Audio Control

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

    ADOX and Adding Users

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

    Access XP and System.MDW

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

    Installing VB App on Win2K

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

    Help with CR7 and SQL Server7

    Here's the latest on this problem: Is it possible there is a DLL somewhere that he needs for CR that the P&D Wizard didn't pick up? When I use the P&D Wizard to create the install pkg, it wants 3 files that I don't have: "Crystal", "u25Total.dll", and...

Part and Inventory Search

Back
Top