Search results

I am getting a syntax error using this: =IIf([COUNTRY] <>"CANADA" Or "USA", [TELEPHONENOTUSCAN], Replace(Format([TELEPHONE] "(###)-###-####"))) I am trying to use the same text box for North American conventions, and everyone else. The text box is not formatted, but I want North American...

I have set up a report that allows a contact to have a different mailing address than the company's. I have an invisible text box that controls an IIF statement: =IIF ([txtbox] = "Y", [CompanysAddress], [ContactsMailingAddress]) This works, but is there a more elegant way of doing this in a...

http://www.databasedev.co.uk/disable_mousewheel.html

I have a distance function that is part of a radial search functions that was developed by my department within a dbIII program. I adapted those functions to Access. So that's not an issue. The cool part is the direct link to GoogleMaps. That really helps with what we do.

This is going to blow my manager away! Thanks for your hard work. I will be linking all code I got from this site into my documentation. So this location will be included as well.

Re: Mapping Tools I Can Use With Access AWESOME! First of all, do I have permission to use this in my existing database? Secondly (assuming the answer is yes), to do so, do I simply import all the db objects as they are? Finally - can more than one waypoint be viewed at a time?

I use a simple approach - I save my access queries results as excel files and then open them from within MapInfo.

Thank you - two sets of eyes are always better than one!

I think I am missing something here: I have an unbound form frmGetTwoDatesIncome. There are two unbound text boxes txtBeginDate and txtEndDate. There is also a command button that opens a report. The report calculates totals based on the range between two dates. In the DATERECEIVED field of...

I have followed up on a couple of ideas, but they won't work for what I want. The main problem is I would need two separate details sections. I will simply suggest doing it manually for now.

I have a report that is printed in either English or French. Right now if the client wants the report in both languages they get separate printouts. What they want is to have the obverse side of a page in English and the reverse in French. Since the pages are the same length I know we can do...

Works like a charm - as always - you're the man!

That gives me a syntax error. With the quotes as in "Is Null" I don't get a syntax error or the expected result. I've attached a SnagIt image to show what I have. I should this is on a continuous form.

I now have the background colour set to white. I want the colour to change to yellow when there is no data. So I am trying Field Value Is equal to "IsNull" I tried dkinley's variation - that looks right, but what event would fire it?

Back style is set to normal.

It doesn't work on either Expression or Field Value. This form is not used for entering data - just for displaying it. I've even tried code: Private Sub Form_Open(Cancel As Integer) 'BackColor field property changes to white when data is entered If Not IsNull(txtDATESENT) Then...

I have taken a look around for this, but all I've found, so far, are examples for dates and date ranges. I want to use conditional formatting to change the background colour of a date field when no date has been entered. How do I specify if the field data for a date field has no value? I...

Once I added the second bracket and changed the zeroes to #, it did. Thanks for your insight.

On Me.TELEPHONE.InputMaskI'm getting a "Method or data member not found" error on the .InputMask string.

Thanks Wayne - this is on a report. Would this be in the OnOpen Event of the report or on the OnFormat Event of the detail section? Out of curiosity - why am I getting the syntax error?