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!

Register Log in
  • Congratulations derfloh 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: ConfusedNAccess
  • Order by date
  1. ConfusedNAccess

    need help-excel 2003 hyperlink in pivot

    Thank you for your response to my issue. As a novice to all this I will try to do my best in explaining the steps . . ok.. so data on sheet1 columns a-g= a: Name b: email address c: phone d: address e: state f: # of claims g: claim so when pivot data is grouped on "state", it will show all...
  2. ConfusedNAccess

    need help-excel 2003 hyperlink in pivot

    is it possible at all to have an active hyperlink in excel 2003??? i can not find anything anywhere.. completely frustrated.. my purpose is to open a word document from the excel pivot table.. the document associated with whatever corresponding cell... i know there is a miracle worker out here...
  3. ConfusedNAccess

    Automation / Validation 2 page fields single report

    This is Excel Question Pivot Report Question
  4. ConfusedNAccess

    EXCEL PIVOT 2 page fields single report validation/automation

    I reposted... i didn't clarify.. EXCEL 2003 pivot table.. Does anyone know if there is a way.. or code or something that exists.. that if my report has 2 page fields.. and one of the page fields is selected, it will prompt... or update / refresh the corresponding page field on the same...
  5. ConfusedNAccess

    Automation / Validation 2 page fields single report

    Does anyone know if there is a way.. or code or something that exists.. that if my report has 2 page fields.. and one of the page fields is selected, it will prompt... or update / refresh the corresponding page field on the same report???? for instance.. 2 page items are STATE, CARS, row field...
  6. ConfusedNAccess

    Inner Join Error

    i'm not sure how to define it.. what is the correct way? I'm new to this. Thanks for your help
  7. ConfusedNAccess

    Inner Join Error

    ok.. sorry.. sent the wrong one.. strSQL = "SELECT top 25 tbltemp.lso_id, tbltemp.lso, tbltemp.am, tbltemp.borrid, lastcalcs.lastcalcdate, lastcalcs.calctype, tbltemp.borrowername " & _ "INTO " & strTableName & " " & _ "FROM tblTemp " & _ "Where...
  8. ConfusedNAccess

    Inner Join Error

    Thanks, for that.. the where clause.. ok.. here's the whole code.. i'm trying get a total of 25 random records and of those 25 random records have 5 records for each lso-ID.. here's the code.. any idease? Sub PickRandomR() Dim db As Database Dim tdf As TableDef Dim fld As Field...
  9. ConfusedNAccess

    Inner Join Error

    anyone see what's wrong with this? 4: Sort the data by the random number and move the top 25 into a new table strTableName = "tblRandom_" & Format(Date, "ddmmmyyyy") strSQL = "SELECT tbltemp.LSO_ID, tbltemp.LSO, tbltemp.AM, tbltemp.BorrowerName, tbltemp.LastCalcDate, tbltemp.CalcType "...
  10. ConfusedNAccess

    Random Sampling

    Need help the module below works great for producing random records, however I have 7 users that I will need to match for, meaning.. i need top 3 random records for 5 different groups-i saw group because i read somewhere that i need to use a group statement.. so maybe group isn't a good term...
  11. ConfusedNAccess

    S/B Simple Nested IIF

    No i'm sorry.. maybe I can paint a better one though.. lets say.. query name is customercalculations Customer redcalcdate bluecalcdate lastcalc type john doe 4/12/2007 4/25/2007 4/25/2007 bluecalc jane doe 4/7/2007 4/1/2007 4/7/2007 redcalc joe shmoe 4/5/2007 4/5/2007 4/5/2007 both
  12. ConfusedNAccess

    S/B Simple Nested IIF

    ...last calc date in the current month.. which I got that fine, but not I'm looking to show what type of calc for each corresponding date or both... *example data* redcalcdate: 4/1/2007 09:23:15 bluecalcdate: 4/7/2007 08:35:25 Iif((datevalue([redcalcdate]=[lastcalc] and...
  13. ConfusedNAccess

    LIMIT parameter

    ok, got the input box to work, however when prompted, and user inputs number, it limits the results to that figure. I need it to limit the results to each individual. example- Joey has 20 records Tom has 10 records Lisa has 5 records when user inputs number, lets say... 3 then I want to see 3...
  14. ConfusedNAccess

    LIMIT parameter

    Love the quote by the way!! Silly question maybe.. but where do i put this? in the same module? or... other option?
  15. ConfusedNAccess

    LIMIT parameter

    I've created a query, and in a module formed a code to randomly select records for an audit sample from a query. I'm stumped on the next part... I'm trying to accomplish the following: The results contain various fields of data for 6 different individuals. Criteria for the query is if the parts...
  16. ConfusedNAccess

    Help!-Parsing Character Separated String

    OK, I just realized that the table field that has the string data in it, is a memo type field. Does that have anything to do with how i'm going to parse the data? I'm frustrated with this because i know that it is possilbe to do what i'm trying to accomplish. I know there is a way. the field...
  17. ConfusedNAccess

    Help!-Parsing Character Separated String

    I was so excited to get your response! Thank you! This is WONDERFUL!!!! I inserted your code into a new module is there a secret to making this work? Again, I'm a novice when it comes this stuff! I guess my question is, how do I "call" this code to my query? I guess that is the correct term.
  18. ConfusedNAccess

    Help!-Parsing Character Separated String

    What I need to tell is the difference between the Required and actual value.
  19. ConfusedNAccess

    Help!-Parsing Character Separated String

    if blank then there isn't one present. the info you have above is correct. sign off note is null.
  20. ConfusedNAccess

    Help!-- Parsing Character Separated String

    This is awesome! How do I got about doing this?

Part and Inventory Search

Back
Top