Replies

I continued to play with it and was able to get this code to work.

(CASE WHEN ((InStr(CBP,’~’,2,2))-(InStr(CBP,’~’,2)))>0
THEN SUBSTR(CBP, (InStr(CBP, ‘~’, 2))+1, ( (InStr(CBP, ‘~’, 2, 2)) – (InStr(CBP, ‘~’, 2))-1 ) )
ELSE NULL
END )

That seems to be working.

THANK YOU!

Try this

IIF(IS NULL([DOB], “”, Mid([DOB],5,2) & “/” & Right([DOB],2) & “/” & Left([DOB],4))

Shareing the workbook so far is working graet.Thanks to all for your help.

Named Range worked. For some reason Access converter the following from “‘Region 33′” & “!A1:T900” to ‘Region 33’$A1:T900. Of course Excel could not find that range.

But named rangeds worked like a dream.

Thanks for your help.

I will try this and see how it goes.

Thanks Wendell.

This is GREAT. Thank for your help.

Thanks to all for your help

Can you help with the syntax for using the PDF. I had come to the conclusion that was the way to go, just having a hard time figuring out the correct syntax.

Thanks for your help.

Exactly what I was looking for. THANK YOU

If you have both version installed on the machine, you should be able to point your 2003 database back to the correct library. If you open the code window, look in the Tools menu for References…

Open this dialog box and check the item listed. the checked items are the ones associated with the database you have open. If you see the 14 library, uncheck it then look down the list for the 11 library. Check that item.

Hope this helps.

Try something like mid([Description], instr(1, [Description], “(” ) +1, 10) This assumes the Invoice number is always ten characters.

Can you post the results of the Debug.Print statement?

What you are looking for the Debug.Print statement to do is show you the full SQL statement before Access trys to produce the recordset. This will allow you to double check field and table names. Most of the time that is where the ‘Too Few Parameters. Expected 1’ error originates.

Hope this helps.

The compact and repair does run correctly in 2003. The db ends up about 175 meg. I did run the compact on the db in 2010 and it took the database from 325 meg down to about 225 meg, so it seem to be working now.

Not sure what I did different, but HEY it is working.

Thanks