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

    Cross-Tab with Combining Formula

    I believe my situation is similar to thread767-1136986. I have a cross-tab that is giving me the status of records in a special sort order (@my order) that I made; and I want only one status, that is DISPOSED records for the last year only. Here is what I have so far; the last else if gives me...
  2. theshadowknz

    Catalog Listing

    Would like to create a catalog of items in db where total items are in excess of 13,000. For instance, inventory database lists all computers within department. Would like to make a catalog listing of particular types of computers and the total count of each--ie, Dell Optiplex GX450 is a model...
  3. theshadowknz

    Counter

    Being new to Crystal Reports I am trying to understand what was just said: If I want a total count of records instead of any details contained in the records themselves, which formula would I use? For clarification, I have 13,0000 records that contain information by region and status. I want...
  4. theshadowknz

    CR Asking for Password

    You Said--You may need to upgrade the MDAC components--Howq or where do I go to update the MDAC--and did you say that will cure the problem or Access2000 is the problem regardless and updating MDAC won't cure the problem?
  5. theshadowknz

    Database-??

    Okay--I think I understand better now--I have two separate tables, one named Tech and one named Vendor. The database in each table is named the same also. The Combo box is in two separate frames--cboTech and cboVendor. In Frame 1- Clicking on cboTech--you get a drop down list of all our tech...
  6. theshadowknz

    Database-??

    Single table-Access 2000; DAO control; followed coding from address/phone book. Here is code: Private Sub cboTech_Change() datTech.RecordSource = _ "SELECT * FROM Tech WHERE TechSupport ='" & _ cboTech.Text & "'" 'datTech.Refresh...
  7. theshadowknz

    ? Removing 'Selected Text' Highlight in Combo Box ?

    I designed it full screen not realizing about resolution settings, etc. It is a one page purchase order form. I can break it into two or more forms--one for vendor's address, one for ship to address, etc., but don't know how I would keep that data together and then have a "preview&quot...
  8. theshadowknz

    Database-??

    I have a combo list box (vendors names) that when vendor is selected would like remaining data from database (address, phone, city, state, etc)., to fill in labels on form for thaqt vendor. Have looked at a few other and "made" my dat the same,etc, but it just doesn't seem to work for...
  9. theshadowknz

    Right Place?--Form

    In project run form is cutoff--how do I add scroll bar, or fix this--I'm sure this wasn't in my Basic 101 class and I haven't had Basic 201 yet!
  10. theshadowknz

    CR Asking for Password

    Loaded Crystal Reports that came with my VB for the first ime (didn't know it was there--VB6). Opened it up to "get a feel" and tried to load a couple of Access 2000 db that I have for other projects in the report wizard--it asks me for the db password--none of these db's are password...

Part and Inventory Search

Back
Top