Search results for query: *

I need to open a find file dialog box to allow users to navigate to a different directory and select a file. The dialog box then needs to return the location of the file selected. Does anyone know how to do this within VBA? Many Thanks.

the reason that I have used Len as a way to check the length of the variant is because none of the is null operators where working, SO..... the only way I could get anything to work was to convert the recordset value into a variant, (i tried then checking if that variant was null - but that...

Well, ive fixed the problem (incase anyone else has the same errors) it seems that access has problems checking if the length is = 0 so i just reversed the logic and used the following syntax varSQL51 = myRS![asset type] If Len(varSQL51) > 1 Then varSQL51 = "=...

that is similar to the code I have been using before, the problem is that it is not triggering on the null values.

im creating a recordset from a table in access, then going through each field trying to ascertain whether it is empty or not, all of the following have produced errors if myRS!Field1 is null varHolder = myRS!Field1 if len varHolder = 0 if myRS!Field1 = "" Does anyone have any...