Search:

Type: Posts; User: Clunietp

Page 1 of 13 1 2 3 4

Search: Search took 1.45 seconds.

  1. Replies
    9
    Views
    715

    Awesome, thanks Marco! Tom

    Awesome, thanks Marco!

    Tom
  2. Replies
    9
    Views
    715

    Thanks Marco, that information may come in use...

    Thanks Marco, that information may come in use some day. Do you know if the same applies to ADO as well?

    Tom
  3. Replies
    2
    Views
    462

    You have to use a query! If you don't want to...

    You have to use a query! If you don't want to create a query object, you can manually type in a SQL statement for the form's recordsource
  4. Replies
    1
    Views
    1,736

    Take your pick ...

    Take your pick

    http://google.yahoo.com/bin/query?p=Error+10050+Network+subsystem+failed&hc=0&hs=0
  5. Replies
    20
    Views
    937

    From that article: Well, since MySQL is free...

    From that article:


    Well, since MySQL is free and Oracle costs a bundle, and you are limited by cost, which one would you choose? :)

    I suppose when they compared free databases, they found...
  6. I would say the easiest way is after you populate...

    I would say the easiest way is after you populate the combo box with the locations, set the combobox.text = the first item in the combo box. Then call the combobox_click event, which will fire your...
  7. Thanks Mongo, I do know better :) I was...

    Thanks Mongo, I do know better :)

    I was considering using TRUNCATE TABLE but then the user would require admin privledges on the database, and I wasn't sure if that would be acceptable for IJ --...
  8. Replies
    9
    Views
    715

    I suppose you could use DAO/ODBC to read from an...

    I suppose you could use DAO/ODBC to read from an Excel sheet. I don't know if you will have similar problems or not to those in ADO. Additionally, if you don't mind making an app that is obsolete...
  9. Replies
    8
    Views
    491

    Do you have any other fields that will magically...

    Do you have any other fields that will magically appear later or is this all of them? :)

    The SQL statement took me about 20-30 minutes to create. If I break it down into smaller pieces and put...
  10. Yes

    Yes
  11. Thread: Sql

    by Clunietp
    Replies
    1
    Views
    323

    Looks ok to me, but I would try it on an access...

    Looks ok to me, but I would try it on an access database or something first, especially if it is important to your career :)
  12. oh, ok, no problem! assuming RS is an open...

    oh, ok, no problem!

    assuming RS is an open recordset that holds the contactinfo data for that person. We'll keep it simple and not use any recordset functions (like seek/find/etc.)


    ...
  13. Replies
    6
    Views
    523

    Actually you can just download and install MDAC...

    Actually you can just download and install MDAC 2.0 from here onto your work PC (its free) and your app should work fine. VB not required

    http://www.integrade.com/downloads/mdac.html


    Tom
  14. Replies
    6
    Views
    526

    actually he could use the...

    actually he could use the Application.CurrentProject.AllReports collection to enumerate through all of the reports in the database, open or not. If he wanted to manipulate the data source of the...
  15. Replies
    1
    Views
    484

    basically, use the replace function. Here's a...

    basically, use the replace function. Here's a small example for you

    strSQL = "insert into mytable (myfield) values ('" & replace(strUserInputVariable, "'", "''") & "')"
  16. Replies
    6
    Views
    523

    Do you have VB installed on your Work PC?

    Do you have VB installed on your Work PC?
  17. Replies
    17
    Views
    886

    No problem, best of luck Tom

    No problem, best of luck


    Tom
  18. Thanks for the clarification, I now better...

    Thanks for the clarification, I now better understand what you need.

    If I were to build it, I would retrieve a recordset of all contact info for a person when they click on the name. I would then...
  19. Replies
    17
    Views
    886

    I believe it would be your @PrimaryFieldName...

    I believe it would be your @PrimaryFieldName variable
  20. Replies
    3
    Views
    444

    Well, looks like you have this one wrapped up. ...

    Well, looks like you have this one wrapped up.

    Wyoming county? So you must keep your computer in a barn? (or chicken coop?) :D :D just kidding. My grandma lives in North Java -- nice and wide...
  21. Replies
    17
    Views
    886

    what was wrong with this statement? delete from...

    what was wrong with this statement?
    delete from Table1 where UniqueIdentifierField not in (Select UniqueIdentifierField from Table2)


    just create a SQL statement like this using your parameters...
  22. Replies
    17
    Views
    886

    What do you need to do with the data that needs...

    What do you need to do with the data that needs to be removed after you select it?
  23. Replies
    19
    Views
    1,369

    I hope this helps ...

    I hope this helps

    http://msdn.microsoft.com/library/psdk/sql/ac_8_qd_14_3unn.htm
  24. Replies
    1
    Views
    534

    I've never heard of this being done, but the only...

    I've never heard of this being done, but the only (known) way you could do this is if the o/s already has ADO installed (for example, windows 2000 comes with ADO 2.5 preinstalled)

    This probably...
  25. Replies
    6
    Views
    526

    Correct, but then you cannot programmatically...

    Correct, but then you cannot programmatically manipulate the report object (you need the Access object model to do that) and you then have a dependancy on DAO (which is a pain to distribute)
  26. Replies
    17
    Views
    886

    You should have just said this in the first place...

    You should have just said this in the first place :)

    a simple SQL statement will do it

    delete from Table1 where UniqueIdentifierField not in (Select UniqueIdentifierField from Table2)

    This...
  27. What database are you using? I suppose you...

    What database are you using?

    I suppose you could cache the data locally be selecting all data from the contactinfo table for that particular person. If you keep this in a recordset you can use...
  28. Replies
    20
    Views
    937

    How is it as "powerful as oracle" if it does not...

    How is it as "powerful as oracle" if it does not support subqueries, stored procedures or db logging (to name a few features)?
  29. Replies
    5
    Views
    373

    Explictly declaring items in your code actually...

    Explictly declaring items in your code actually makes it process faster.

    For example: declaring Language, EnableSessionState=False and Option Explicit speed up your output by approximately 5-10%...
  30. Replies
    6
    Views
    523

    How are you connecting to your database? Are you...

    How are you connecting to your database? Are you using a querystring somewhere, or maybe a data designer of some sort?
  31. Replies
    17
    Views
    886

    Well, it looks like you're up sh*ts creek without...

    Well, it looks like you're up sh*ts creek without a paddle :D

    SQL Server isn't letting me dynamically create the sql statement for the OPEN CURSOR procedure. Maybe we can try to accomplish your...
  32. Replies
    4
    Views
    369

    Have you tried anything like an Insert Into...

    Have you tried anything like an Insert Into statement with a NOT EXISTS subquery? If you'd like to send me your database (a small, zipped version please) I'd be happy to see what I can do
    ...
  33. Replies
    2
    Views
    928

    Since your recordset is at module level scope, it...

    Since your recordset is at module level scope, it will always point to the current record. You can then just use rs.MoveNext to point to the next record. Will this work for you?
  34. Replies
    17
    Views
    886

    Well why didn't you say so in the first place? :D...

    Well why didn't you say so in the first place? :D

    You can't call a SP and get its resulting recordset from another SP (you can do it with single return values though), so we have to create a...
  35. Replies
    3
    Views
    444

    The only way you can do this is to trap the error...

    The only way you can do this is to trap the error on the client


    What part of WNY are you in BTW? I'm in Tonawanda. Small world :)
  36. Replies
    6
    Views
    487

    Do you know how to read a text file and/or use...

    Do you know how to read a text file and/or use INSERT sql statements (or the AddNew method of a recordset)?
  37. Use the PersonID and the value in the combo box...

    Use the PersonID and the value in the combo box to query your contactinfo table. This should retrieve the appropriate information

    example

    "select * from contactinfo where PersonID = " &...
  38. Replies
    17
    Views
    886

    Apparently not! I put your code in a SP called...

    Apparently not! I put your code in a SP called spu_Test and ran this code



    Dim objcn As ADODB.Connection
    Dim objrs As ADODB.Recordset

    Set objcn = New ADODB.Connection
    ...
  39. Replies
    6
    Views
    526

    Per the MS Access help file, the Reports...

    Per the MS Access help file, the Reports Collection contains a list of currently open reports. So we just have to open one first



    Dim objAxs As Access.Application
    Set objAxs = New...
  40. Replies
    17
    Views
    886

    Is this code in a stored procedure?

    Is this code in a stored procedure?
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width