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!

  • Congratulations strongm 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. Rob7412

    Dynamic Flash Embedding?

    I Use Telerik RADControls with VB .NET I would like to assign a tooltip value to a RAD Control and use that Value to Dynamiclly Embed a Flash file to a Multipage here is a static embed code I use that successfully embeds the file <OBJECT CLASSID="CLSID:D27CDB6E-AE6D-11cf-96B8-444553540000"...
  2. Rob7412

    Get Part of URL?

    I need to get part of a URL so I can do a DB lookup on it for example I have the following url: https://my-site.com/WVP720/step1.asp?frmSiteCode=3BB15618&frmMachineID=CE9F-1EF3-E968-6ED6&frmVersion=V5 I need to get the "WVP720" part of the url so I can match it up from a db lookup. Anyone tell...
  3. Rob7412

    Conditional Merge ?

    I have a colum "A" that list a group number for a user and I have another column that list the lastname of a user. What I want to do is for evryone that is in the same group merge all the last names into another field Is this possible? Example: GroupID Lastname Merged field 1...
  4. Rob7412

    Create and Update new field SQL 2005

    Fantastic Thanks If Knowledge were power I would be a AAA Battery!
  5. Rob7412

    Create and Update new field SQL 2005

    I have a script that adds a bit field to an existing table, Default value of 0. I would like the same script to also go in and update the field to a bit value of 1 after creating it but the server keeps giving and error saying field does not exist. If i refresh the db the field is there but the...
  6. Rob7412

    direct printing of document?

    I currently have links to documents on a asp page. I would like to give the user a print button so they can just press the button and print the document instead of having to download then print. Is there any way of doing this. All documents are microsoft word documents and they get links now...
  7. Rob7412

    Error Handling on SQL DB connection

    It still crashes if the connection cannot be made. I do However get the message box twice for some reason and After I click ok on both the app still throws the 3709 error and closes. I have checked my error trapping and it is set correctly. Hmmm this is a bit of a head scratcher. If Knowledge...
  8. Rob7412

    Error Handling on SQL DB connection

    The code is in a module which is called from the form load of the form. OpenDB() Below is the code in the module. Public Sub OpenDB() 'this procedure is to be called in every form under the Form_Load event If GetString(HKEY_LOCAL_MACHINE, "SOFTWARE\ License Manager", "") <> ERROR_SUCCESS Then...
  9. Rob7412

    Error Handling on SQL DB connection

    Sorry this is the correct code used On Error GoTo MyErrorHandler ... your code here conn.Open "Provider=SQLOLEDB.1;User ID=" & dbUser & ";Password=" & dbPassword & ";Database=" & dbname & ";Server=" & server1 & "" Exit Sub MyErrorHandler: If Err.Number <> 0 then 'Connection not...
  10. Rob7412

    Error Handling on SQL DB connection

    I used this below but still get a runtime error 3709 and the app crahes On Error GoTo MyErrorHandler ... your code here conn.Open "Provider=SQLOLEDB.1;User ID=" & dbUser & ";Password=" & dbPassword & ";Database=" & dbname & ";Server=" & server1 & "" Exit Sub MyErrorHandler: If Err.Number...
  11. Rob7412

    Error Handling on SQL DB connection

    I am pulling the connection values from the registry all works fine unless the login is incorrect or the server address is incorrect Basically have this connection string going. conn.Open "Provider=SQLOLEDB.1;User ID=" & dbUser & ";Password=" & dbPassword & ";Database=" & dbname & ";Server=" &...
  12. Rob7412

    Error Handling on SQL DB connection

    How can I bring up my login.frm if the app cannot connect to a SQL db so they can change their login credentials. I store the values in the registry and I change these values through my login.frm. I basically need it NOT to Crash and show the user the login.frm
  13. Rob7412

    Open specific form

    I have built a app that has several forms however I would like to have a specific form open if someone double click a file that is associated with my app. Open app up directly- I want the main form to show Open app by double clicking associated file- Have subform show Is there any way of...
  14. Rob7412

    Email contents of listview?

    Thanks I went out of town and just now am returning to the normal life. This worked like a champ...
  15. Rob7412

    Email contents of listview?

    any simple way of clicking a button and having the app bring up my default email handler and pasting the contents of a listview on my form called lv1 Thanks in advance.
  16. Rob7412

    Toggle Checkbox State Listview Checked/Unchecked?

    Thanks it worked like a champ
  17. Rob7412

    Toggle Checkbox State Listview Checked/Unchecked?

    Probably Simple but I can't seem to get it working. I need to have a button on a form that sets all items in my listview checkboxes to checked and another to uncheck. Any help would be appreciated. THX.
  18. Rob7412

    Timestamp query for day

    Thanks SQLDenis
  19. Rob7412

    Timestamp query for day

    OOps I should have said I have a timestamp field called timecreated I need to query records that were created on todays date before 4:00pm
  20. Rob7412

    Timestamp query for day

    How would I query records that have a timestamp before 4:00pm today from a table

Part and Inventory Search

Back
Top