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

  1. LOSERMANN

    Chart reports

    would it be possible if i could email a copy of the dbase to you? regards, Milk
  2. LOSERMANN

    Chart reports

    heres a thought!! i didnt know poo poo about crosstab qrys but have managed to create one that gives a glimmer of hope. TRANSFORM Count(qryClients.[ID#]) AS [CountOfID#] SELECT qryClients.EmploymentStart, Count(qryClients.[ID#]) AS [Total Of ID#] FROM qryClients, qryStatsClientCount GROUP BY...
  3. LOSERMANN

    Chart reports

    Duane, ive tried to type them into this forum but when I preview the message it looks very disjointed and mixed up, ive tried to do a screen capture and then paste that, didn’t work. I so much appreciate the time you have given me, it’s much more than one can reasonably expect. Im not sure what...
  4. LOSERMANN

    Chart reports

    i tried to put together a tbl of records, but when i previewed it it came out all disjointed. i tried to do a screen capture and then crop it to paste it in here and failed...short of that here is something that may or may not help. tblClients fldID# - Primary Key ReferalDate - Date/Time...
  5. LOSERMANN

    Chart reports

    unfortunately i cant share the records. i do have fields for ReferalDate and CaseCLosedDate, though i havent done a qry to compare them. regards, milk
  6. LOSERMANN

    Chart reports

    oops, i just realized i left something out. im still working on getting the little chart thing to display this data over a period of months as they go by, adding bars as time passes. as it is now i get a 'snapshot' view of the stats. regards, milk
  7. LOSERMANN

    Chart reports

    got it working. ive been tinkering with it some more and here is what ive gotten to work. i created three qrys, one that counts the total client records. another that counts the records that meet a certain criteria. in a third qry i have combined these two counts and built an expression that...
  8. LOSERMANN

    Chart reports

    im finished. thanks again for taking the time to look into this for me. regards, milk
  9. LOSERMANN

    Chart reports

    yes one bar but as the months go by im hoping to have one bar for each month. thusfar ive not been able to compute the percentage and have it displayed in the chart. regards, milk
  10. LOSERMANN

    Chart reports

    Thanks for your quick reply. i hope this helps. in the end im looking for 3 bar charts -percentage of clients that obtained employment in last 60 days -percentage of clients that show an earning progression -percentage of clients cases closed with earnings thusfar i have been able to...
  11. LOSERMANN

    Chart reports

    to expand on my earlier posting; my source date looks something like this... qryClients (the Fields) ClientID ReferalDate (date refered to services) EarningsStart (starting salary) EarningsEnd (salary at end of case) CaseClosedDate (date case closed)
  12. LOSERMANN

    Chart reports

    good day all, im trying to create a report that will display some stats. to begin with i have a qry that contains client information for a good many clients. here is what ive got so far. here is what im aiming for; percentage of clients that obtain employment in last 60 days. percentage of...
  13. LOSERMANN

    Access ListBox selection to launch other form

    musta been something i did to the form at an earlier time to mess it up. i just fixed it. what i did was create a new form and copy all the controls from the old 'frmclientinformation' into the new one, now the selection from the list box works wonderfully!!!!!! thanks so much for your...
  14. LOSERMANN

    Access ListBox selection to launch other form

    the allow filter is set to yes. the form opens to a new record. id rather it opened to the record im dblclicking on in the listbox. cant thank you enough. hats off to ya. milk
  15. LOSERMANN

    Access ListBox selection to launch other form

    thanks...that took care of the error. the second form still opens to a blank form though. the field [caseNumber] is numeric. the record source for the second form is the same qry that the listbox pulls data from. should i have placed anyhting in the filter property, or some other property...
  16. LOSERMANN

    Access ListBox selection to launch other form

    so sorry for not 'getting it'. ill try not to bother you all with this much more. the second form opens wonderfully but i get an error... run-time error 3075 syntax error(missing operator) in query expression 'CaseNumber=60000112 'that case number is the number something we generate ourselves...
  17. LOSERMANN

    Access ListBox selection to launch other form

    Thank you both for your quck reply. absolutly wonderful. the post from wemeier worked to open the form, thank you as well Jeff, like you said there seemed to have been a comma issue. still cant thank you enough. now that i have to form opening nicely, ill have to beg one more thing from you...
  18. LOSERMANN

    Access ListBox selection to launch other form

    hello all, i need a bit o'help with this. i have a form that contains three listboxes. each list box shows a listing of clients that are working with a particular job developer. the list box info is just the name of the client and the date refered to us. i have a second form that contains a...
  19. LOSERMANN

    is it possible to create a hot spot on a picture?

    Here is a thought..... ...create a cmd button that does what you want ...place it on top of the picture area you want to be a hotspot and change the buttons transperancy property to yes ive done this a couple of times and it works wonderfully. i use the hidden buttons as hotspots to launch...
  20. LOSERMANN

    VBA help

    Hello everyone, i need a bit of help. i have a form (dont we all) that ive built this rather lengthly iif statement expression into the after update property of a textbox control. works great, but.....id like to play a bit with the idea of limiting the number of controls on my form. hence the...

Part and Inventory Search

Back
Top