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 TouchToneTommy 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: *

  • Users: gleeb
  • Content: Threads
  • Order by date
  1. gleeb

    CheckedChanged event firing on form open

    Hi all, I know I have seen this discussed somewhere, but cannot find it for some reason. I'm using VB.NET 05. Inside the CheckedChanged event for a checkbox on my form, I have some code to perform. I check the state of the box, and if it is checked I add a flag to a patient class...
  2. gleeb

    Bind Variable with Null value

    Hi all, I am developing in vb.NET using ODP and Oracle 10g. I've set up a SELECT statement using bind variables, and up until now it hasn't been a problem. Example: SELECT dts_mbr_no FROM mbr_labs WHERE dts_mbr_no = :mbr AND dts_lab_id = :lab AND dts_lab_val_txt = :result The problem occurs...
  3. gleeb

    Bind Variable with Null value

    Hi all, don't know if this is the correct forum, but here goes . I am developing in vb.NET using ODP and Oracle 10g. I've set up a SELECT statement using bind variables, and up until now it hasn't been a problem. Example: SELECT dts_mbr_no FROM mbr_labs WHERE dts_mbr_no = :mbr AND...
  4. gleeb

    Weird problem with Access and CR

    I am using CR 10 with Access for some simple reports. I have setup an ADO connection and added my tables. When I get to one table in particular, no fields show up in the field list but all the other tables are fine. If I try a DAO connection, I get the following error on the table in...
  5. gleeb

    For Each Question

    Hi I am cycling through text boxes on a form with For Each HoldText As Control In Me.Panel1.Controls If TypeOf (HoldText) Is TextBox Then If HoldText.Modified Then PatientHasChanges = True I get an error that 'Modified' is not a member of...
  6. gleeb

    Group Selection for MaxDate

    Hi, Im using CR 10 connecting to an Access Db. I am wanting to select appointment records only if the maximum of one persons records fall within a certain date. Example: 1 Gleeb 12/01/2004 2 Gleeb 02/05/2005 date parms = 12/01/04 thru 12/31/04 I have grouped on name then date and put...
  7. gleeb

    Trying to connect to Oracle and Access

    I am having the hardest time trying to pull related records from an oracle database and an access database. I tried at first to link the oracle table inside of Access and that worked for a while. Now I am getting timeout problems with ODBC. Preferrably without cycling thru one recordset to...
  8. gleeb

    Finding out if a query is used

    I have a select query that I use in another query. I want to change it to a make table query so that I can access the table from a VB app, but I want to make sure no other queries are linking to the current select query. Does anyone know if I can easily search to see if a query is being called...
  9. gleeb

    Combo box Change Event - Mouse vs Keyboard

    I have a combo box that fills other fields based on the changes event of a combo box. It works great when the selection is made by a mouse click, but not at all when the user types in part or all of the selection. Does anyone know how to get the change event to fire from a keyboard selection?
  10. gleeb

    8.5 vs 9.0 Set Location

    I am in the process of converting from CR 8.5 to CR 9.0 using ODBC to various SQL 7 datasources. In 8.5 a user was able to click set location, pick their DSN, log in, and then remap the first table. CR would then ask if you want to propagate the changes to the other tables. Pretty Easy. When...

Part and Inventory Search

Back
Top