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

  • Users: rocco
  • Order by date
  1. rocco

    How to populate listbox with multiple values from a table

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

    How to populate listbox with multiple values from a table

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

    Resetting Checkbox to blank in a subform

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

    I can't figure this one out....need

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

    I can't figure this one out....need

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

    I can't figure this one out....need

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

    I can't figure this one out....need

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

    I can't figure this one out....need

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

    Reset Table Column Back to 0

    Drop table and recreate table to reset column value.
  10. rocco

    Reset Table Column Back to 0

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

    How to Sum file sizes for a particular File type

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

    How to Sum file sizes for a particular File type

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

    corrup labe - bad geometry

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

    corrup labe - bad geometry

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

    cronjob in solaris 10

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

    export tab delimeter - date problem

    Thank you very much Max for your suggestion. I was trying to format it using the txt created and export delimeter. The query worked fine and the exported file looked good saving me some extra steps. Cheers, Alexander
  17. rocco

    export tab delimeter - date problem

    Wondering if somebody can help me guide me in the right direction. I am trying to export a file to txt by using the export delimeter in a macro - (access 2003). The problem that I am having is with dates. In the parameter delimeter I tell it that I want YY/MM/DD with year having 4 numbers...
  18. rocco

    Updating sysindexes table

    I am trying to change the status for one of the fields in the sysindexes table but I am hitting a wall. select * from sysindexes where name = 'csysservers' and status =146 For this query I get only one line back, what I want. Then I run my update sql but I am getting an error. update...
  19. rocco

    Solaris 10 DNS setup

    Trying to setup DNS for solaris 10. I was looking for the file resolv.conf but could not find it. What files do you set this up with 10 ??? Thank you for looking at my view. . .
  20. rocco

    Sybase Open Client Library

    Wondering if anybody had the same problem I am having. I have solaris 10 with sybase 12.5.4 working fine at the server. The client however is a headache. We had 12.0 before and it was so easy to install. Now my ODBC just does not work at all. I noticed that I do not have the Net-Libary tab when...

Part and Inventory Search

Back
Top