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 Wanet Telecoms Ltd 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. TruthAndBeauty

    Make an MDE file

    SUGGESTION- DON'T HAVE A DB OPEN AT THE TIME YOU SELECT TOOLS/DATABASE UTILITIES/MAKE MDE
  2. TruthAndBeauty

    Adding All to a combobox list

    I thought of using a option group with the combo box the apporach seems so bulky. I understand what you're suggesting but then I would be depending on my user to infer that a blank value means something (ALL, None, etc.) unless I use up addtional space on the form to explain the concept rather...
  3. TruthAndBeauty

    Adding All to a combobox list

    I want the list to include an "All" option to my combo box listing. My combo box source is a select distinct EmplType from tbl_Emp. I want the combo box to capture type from a table rather than hard code the listing. I prefer not to use a list box but perhaps it's a limitation...
  4. TruthAndBeauty

    Is there a TREE listing object/funtion

    Does anyone know the structure an/or properties of the tree levels (branches)? I've got the tree working (data/expand/collapse) with 3 levels (parent/child/grandchild) ad now I'm trying to work with the selections. I can see the vaue of the selected item (mytree.selectedItem). There is a...
  5. TruthAndBeauty

    Rearrange tabular frm/rpt on the fly

    Thanks, I'm going to give it a try.
  6. TruthAndBeauty

    Rearrange tabular frm/rpt on the fly

    Not sure what" concept shown in hte ref thread to create a report" your referring to unless it's the "Tools / Office Links / Analyze". I havenot played with this before and I'm exploring the Office link idea now. ---------------------- I work with recordsets; however, I...
  7. TruthAndBeauty

    Is there a TREE listing object/funtion

    I found the MS Tree View (6.0) in the insert ActiveX control. I inserted it on a new form. There are no instruction and the property screens don't give me a clue how to implement it. My 3" thick MSAccess book don't address how to use OCX. Hmmmm. I'm heading out to microsoft.com and...
  8. TruthAndBeauty

    Is there a TREE listing object/funtion

    I know Access has switchboards and tabs, but is there a tree (expandable/collapsible) I can provide the user to navigate around the application. I've searched on "Tree" in Help and Tek-tips but nothing come up. Thanks
  9. TruthAndBeauty

    Rearrange tabular frm/rpt on the fly

    Say I have a canned, 20 column tabular form/report. The user wants a simple GUI that allows them to rearange the report. The users doesn't want to design or create a newform/ report they just want a subset or different view of this one. The users get .mde or .ade files. Simply letting the...
  10. TruthAndBeauty

    Putting A Document In A Form

    "Hyperlink" is a datatype for a table field. I know it's not your first choice but perhaps you can simply store several hyperlinks and let the user go to the document or a thousand other places. This can help make your application one-stop-shopping. good luck
  11. TruthAndBeauty

    Execute code prior to leaving subform

    --------------------------------------------------------- Don't overlook the On DIRTY event. The Dirty event occurs when the contents of a form or the text portion of a combo box changes. It also occurs when you move from one page to another page in a tab control. Examples of this event include...
  12. TruthAndBeauty

    Well, I'm looking at using Crystal

    kenhamady, 30 days is a short time to learn and test and yet I have to face fiscal year funding and waiting customers. It took a lot of time to evaluate other products (Business Objects, Cognos, Web focus, Proclairty, MSAccess, ASP, etc.) to the point we could select one for testing. I've...
  13. TruthAndBeauty

    Well, I'm looking at using Crystal

    Sorry for the delay- I'm been away. I read about the different configuration and found it interesting reading. Here where I'm at. I'm looking at getting: - CE Professional - unlimited users This will give my audience canned reports, parameter driven reports and drill down...
  14. TruthAndBeauty

    Well, I'm looking at using Crystal

    Thanks Chris. I appreciate the feedback. Ii wish 25 CAL = 1 process license; however, after "discounts" the processor cost is the same as 12 CAL. I'm not sure if CAL is high or processor license is low. the price I asked Crystal about a benchmark for a single processor and he...
  15. TruthAndBeauty

    Well, I'm looking at using Crystal

    Well, I'm looking at using Crystal Reports for my web reporting too within my organization (1000 staff). It will be on an intranet, not and internet. I'd like some opion on my strategy. -10 true report developers ( not users) -The reports are targeted at the 150 managers but accessable to...
  16. TruthAndBeauty

    continuous frm - value determine cntrl bkcolor

    Thank you! Thank you! Thank you! It couldn't be simpler or a better fit.
  17. TruthAndBeauty

    continuous frm - value determine cntrl bkcolor

    Afternoon, I need for each record in a continous form to dispaly a color (1 of 4) reflecting a value associated with the record. I've research and experiemented but ...no go. Perhaps you know a solution. Scenario: Table1 has only three fields: rec_num (value:autonumber)...
  18. TruthAndBeauty

    How to print label in a report?

    labels are "Columnar" reports. 1. In MSAccess use can use the report wizard. After you respond to a couple wizard screens prompts identifying table and field names you will be prompted to choose the layout: columnar, tabular or justified. Sselect columnar and play with it. 2. Another...
  19. TruthAndBeauty

    disable to close button

    Why not eliminate the problem by disabling the X option and force the user to use the CLOSE button you provided.. Simply go to the FORM property (not the control property) and set the FORM Close Button property to NO. This way the user will use your CLOSE button and it's code. You might...
  20. TruthAndBeauty

    Increment numbers for month, restart on new month

    Thereare multple approaches, here's one Use the DatePart function to get a count of records associated with the current month/year. DatePart function description: OrderDate DatePart Function This expressionReturns 3-Jun-93...

Part and Inventory Search

Back
Top