Search results for query: *

Thanks. AddHandler worked like a charm and more elegant. I had used it elsewhere but couldn't remember that. I'm getting old I guess. Thanks again,

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

You are correct. The variable in question is an empty string. If I use the empty string or assign NULL to the parameter value instead, I get the same result. No selection. The only time I get results is if I change the select statment to: SELECT dts_mbr_no FROM mbr_labs WHERE dts_mbr_no =...

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

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

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

Thanks for the recommended books. I do have a patient object which I instantiate upon opening the form. I assume I would need to bind the objects members to the textboxes to detect changes in the object and update the Db if necessary.

Ok, thanks for the help. Now I'm curious what's MVC? I am having a hard enough time learning the fifty million ways to accomplish something and narrowing it down to the 10 that work best depending on who you talk to or what you read in any given day. "Don't bind", "use datasets and data...

Very nice. Thanks.

Hmm That really doesn't work. I get this error: Unable to cast object of type 'System.Windows.Forms.Label' to type 'System.Windows.Forms.TextBox' on the If line This is the code: For Each HoldText As Control In Me.Panel1.Controls If CType(HoldText, TextBox).Modified Then...

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

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

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

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

Thanks much. I moved the code to the AfterUpdate event and it worked great.

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?

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

Nevermind Answered my own question. Instead of RecordNumber > (?Show_N_Records) use a running count of records that get rest upon group change. Ex: {#RecCount} > {?Show_N_Records} Thanks

The above referenced thread works fine if you have no grouping. I am trying to group by user id and then show a random selection of N records for each group. On the suppression formula no records will print after the first N for the first group. Example: ID 1 Detail - 15 records here ID...