Search results

  1. R

    Bar chart with line graph, and two Y axis

    I've never used a chart in Acces (but I would like to). See if this link helps. http://www.access-programmers.co.uk/forums/showthread.php?t=121431
  2. R

    Formatting telephone numbers

    I have used the North American telephone input mask, but I have to be able to display other conventions. I have a separate field for other phone numbers TELEPHONENOTUSCAN. If an input mask is used for telephone numbers, can it be overridden? I would like to do something like this in an...
  3. R

    hide row in a report based on value in a field

    That explains why it wouldn't work (something to add to the Access wish list). I went with the KISS (Keep It Simple Stupid) principal and eliminated the label altogether: ="GST Exemption Number " & [GSTEXEMPTION] I added enough spaces before the end quotes to make the [GSTEXEMPTION] field...
  4. R

    hide row in a report based on value in a field

    I am trying to accomplish the same thing. How do I get the associated label to change?
  5. R

    Getting value from query before report opens

    I found another work around. Not as elegant, but it does work, which is what matters.
  6. R

    Getting value from query before report opens

    I'm not sure how this helps. Can I put this on the on open-event of the report to make the value available to the report?
  7. R

    Getting value from query before report opens

    I have a text box in a report whose value changes depending on the date in the query. I can get the value from the query before the report opens from an open form. And then I open the report and get the date from the form. Is it possible to get the value from the query without opening a...
  8. R

    Case Statement

    OK - thanks for your help - it works.
  9. R

    Case Statement

    I noticed you have Case Is on the first line but not the subsequent one?
  10. R

    Case Statement

    Thanks for pointing out the gap. I thought of using a table, but if I can get this going, it would be a lot simpler for me to deal with. I use this value in only one field in only one report. The field GST is actually a text string. I use a text box to do the actual calculation. The GST is...
  11. R

    Case Statement

    My first Case Statement! I need to choose a value based on a date: Select Case DATERECEIVED < 01/01/1991 GST = 0 BETWEEN 01/01/1991 AND 01/07/2006 GST = .07 BETWEEN 01/07/2007 AND 31/12/2007 GST = .06 > 31/12/2007 GST =.05 I have no idea how to set this up (yes I have looked at...
  12. R

    Error '3008'

    Yes I had it turned off. This is a relatively simple form so I will rebuild it. This does get a bit frustrating though.
  13. R

    Error '3008'

    I am using A2003. I changed the name of a field from InvoiceNumber to INVOICENUM in a table called tblTransactions. It is used in a couple of forms and reports. On one in particular, based on a query called qryTowerLog (which is based in part on tblTransactions), I double click on a text...
  14. R

    Mystery fields

    Cool. I knew there must be a way to find all the controls on a form. Thanks.
  15. R

    Mystery fields

    Thank you! I've been looking at this form for half an hour and couldn't see it. I tried auto-order and few other things - like stepping through each label and text box. You also found an error for me - the Initial field data source was FirstName. I guess I am getting older faster than I want to.
  16. R

    Mystery fields

    A2003. Maybe someone has sharper eyes than I do. When I view the tab order on this form (it is actually the subform of another form) there are two text boxes that don't have names - text24 and text26. I can't find them. Can someone else?
  17. R

    Complex Query Question

    What's even weirder is I used a copy of the form from another copy of the db I am working on. THAT form worked. The only thing that changed was the unbound form. At least it works though. Thanks Access for adding to the mysteries of life!
  18. R

    Complex Query Question

    That's what I first thought - I will fix that and play around with it for while. The setup I have is a search menu that allows for a number of options - including a radial search. When the user clicks on "Radial Search" (a command button that runs a macro) an unbound form opens where the user...
  19. R

    Complex Query Question

    SELECT tblSites.SITENAME, tblSites.SITEPROVINCE, tblSites.SITELATDEG, tblSites.SITELATMIN, tblSites.SITELATSEC, tblSites.SITELONDEG, tblSites.SITELONMIN, tblSites.SITELONSEC, tblSites.ELEVATION, tblSites.UTMZONE, tblSites.UTMEAST, tblSites.UTMNORTH, tblSites.TOWERHT, tblSites.NBCC2...
  20. R

    OnFormat in a report

    Thankyou for the quote - I now realize I misspelled the fieldname! It is txtCustomerProjectNumber! Darn computers expect you to know what you're doing!
Back
Top Bottom