Runtime Error 3075 Function is not available in expression 'Trim(IIf(.

[TrademarksAustralia]

Help please: An access converter has been developed. When I try to run on my pc, i get the above runtime error.

So I try to figure it out and find the following link, and try to carry out the instructions from:

http://support.microsoft.com/default.aspx?scid=kb;en-us;194374

Using Microsoft Access to Refresh a Reference
You can use Microsoft Access to refresh the references on a target computer manually. To do so, follow these steps: 1. Open the database that causes the errors mentioned in the "Symptoms" section.
2. On the Modules tab, click New.
3. On the Tools menu, click References.
4. In the References dialog box, pick any single reference that is not already selected, click to select it, note which one you selected, and then click OK.
5. On the Tools menu, click References again.
6. Click to clear the reference that you selected in step 4, and then click OK.
7. Run the query, the form, or the report on which you saw the errors mentioned in the "Symptoms" section. No errors occur.


HOWEVER, when i click modules tab, where is the NEW button, I click the shortcut up the top for new and it doesnt do anything.

In addition, I click TOOLS but cannot find the REFERENCES either. I run ACCESS 2003.

I am stuck and not very pragrammer orientated.

 

[jedraw]

Are you
1. clicking Tools on the Database window, or

2. did you click on modules, new and the Tools on that menu?

You must do 2. to get to References.

Modules is on the main database window just above GROUPS

click modules, then click New, Then click Tools at the top of the new screen that opens. References should be the top entry in the drop down list.

 

[TrademarksAustralia]

I click modules, but dont see any NEW, I have done a screen dump for you to take a look at so that we are talking about the same thing here.


I've made a screen dump for you:

http://www.geocities.com/daaussie/screendump.html

 

[PHV]

And what about Alt+F11 ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[dhookom]

When I want to open a module window, I generally press Ctrl+G which gets me in a debug window in the VBA Editor.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[TrademarksAustralia]

ok, both of those commands worked.

I then click TOOLS in the module that comes up, and now i have a further problem, REFERENCES is greyed out so I can't select this option.

What is going on?

 

[PHV]

What is going on?
You probably have some running code.
Click the square (reinit) button.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886