Search results

That was exactly what I wanted, although I had to change my concept slightly. Since the results are perfect for my needs, this is a perfect solution!!!! Thanks. Gary

"from a form", sorry.

How can I create a recordSource for a Form using an SQL String that I build manually for a form?

Forgot to mention, If ReturnValue = 0 Then is valid, because the return value is not a string. The filename is a member of an object of type OPENFILENAME Dim MyFile As OPENFILENAME GetOpenFileName(MyFile) I don't remember where I got this info. I can not find anything about it now! ;-(...

Thanks. The work-around is: If ReturnValue = 0 Then MsgBox "Cancel Button was pressed" Else path = "#..\" & Mid(MyFile.lpstrFile, 33) & "#" pos = InStrRev(MyFile.lpstrFile, "\") newName = Mid(MyFile.lpstrFile, pos + 1) theLen = InStr(newName...

I have a table where I use a field that is a hyperlink to hold a file name. The user gets an open dialog box to pick the file to use. That works fine. Then I want to strip the path and the file extension off to store in another field. It kind of works. It strips the path, but does not work...

I know databases, having worked on Oracle, Sybase, and DBase to name three. Access has so much more, especially the graphical user interface. So far, I find it has a lack of documentation that I am used to. Gary

Forgot to mention that I would like a Access 2003 answer, but can go up to 2010.:eek:

I have a table with a hyperlink field that is a relative pathname to a PDF file that I want to display in the form. The database is on the desktop and the path is relative to the desktop. How can I display it? Any help would be appreciated

My name is Gary Burt and I am teaching myself Access. I am building a database of my recipes. I am learning a lot about Access and getting to respect it a lot.