Recent content by rocco

My apologies for the confusion. I have set up Form1 to have a listbox that is able to select multiple entries. So, if the listbox returns 10 items then the user is able to select/highlight 3 items (Sample1/Sample2/Sample3) When I save the data to my master table the field with this data for the...

I am trying to populate a listbox with values from a master table. 1. User selects multiple selection from listbox and clicks save. The values will be save to master table: Tbl_Main_Clinical field: CL_resp_consult The values will be save to the table field as - sample1/sample2/sample3 I am...

I have created a form that has to two subforms inbedded. 1. I enter a name in a box to search for user location, designation, etc and the 1st subform shows the result. 2. The 2nd subform shows two check boxes that are link to the master table that I am updating and if the user is found it will...

Thank you for all your help dhookom... It works like a charm and I was using a diff control name in the Main form which made things a little more confusing but all is good.

ooh...Looking at the code for to long. Great news let me give it a try...and thank you for looking at the post.

Sample that works... SubFrm_Incident_InProgress - Data - Qry_Incident_InProgress (this will give me a list of incidents) Field Incident_No found in SubFrm_Incident_InProgress List has and event - On Click - do this. DoCmd.OpenForm "Frm_Incident_Detail_InProgress" (I can click any line to...

I will supply the code...but that is what I am using. It is curious that it works from calling from one form to the other but not when the subform is used.

I can't figure this one out....need HELP! Very interesting however as I thought it would work. 1. I have a main form (A) with a subform (B) 2. In the subform (B) I am clicking from a list created to open an other form with detail info form (C) Problem: The variable is not passed and no results...

Drop table and recreate table to reset column value.

I have a couple of related tables that an identity value overflow occurred for a particular field x. I need to reset the column back to 0 but not sure what the command is...help is needed. I am running Adaptive Server Enterprise 12.5.4 The tables have no data as I have truncated the tables to...

Thank you very much AvayaTier3... It works beautifully, I will create a job so that I can get a daily email with the info.

Does anybody know how to sum file sizes for a particular file type. Sample ls -l -rw-r--r-- 1 sun6 ultra 56086528 Feb 17 03:00 DBSmaria -rw-r--r-- 1 sun6 ultra 3504128 Feb 17 03:00 DBSanna -rw-r--r-- 1 sun6 ultra 500766720 Feb 5 03:00 DBSdebbie Whatever magical command would give...

The disks are hardware raid and I don't care if I loose everything.

I have sun box V445 with solaris 10. We had several power outage an the box has problems booting now. The main error is Corrupt label - bad geometry label says 143359488 blocks; Drive says 143112591 blocks /dev/rdsk/c0t2d0s0: I/O error. I tried fsck and fsck with boot cdrom -s but the same...

we ran the job for backup using a cronjob. We had solaris 7 and migrated to solaris 10. Now my backup job does not run. This is the error I get if I try to run the file manually. ksh: ./.backup: cannot execute If I enter each line manually it work so I know it has nothing to do with the code...