Search results

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

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

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

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

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

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?

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

OK - thanks for your help - it works.

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

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

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

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

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

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

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.

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?

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!

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

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

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