Search results for query: *

Thanks for the information, this worked out great. I changed the colum index to zero and it did what I needed it to do. thanks a lot.

I copied and put the code in afterupdate just like you said. Nothing happened. The field stayed blank even after I selected C in STATUS field. This is what I changed in the code for the name of the combobox name. Private Sub STATUS_AfterUpdate() If Me.STATUS.Column(1) = "C" Then Me![Comp...

I have a combo box named STATUS in a form named TASK LIST with a dropdown selection to select either O, for open, or C for closed. The problem I am having is that I have been trying to use the IIF statement in another field called COMP DATE. This field is formatted mm/dd/yyyy. I am trying to use...

Thanks dRahme, and deduct. Its working like a champ! Thanks for all the help. This saves me a whole lot of time.

This is great! This is just "about" what I need. It generates the hyperlinks to the files but just one problem. Each file in FileName does not have a file extension associated with it. It generates a hyperlink to each file like P:\Maint\MaintDBase\DWFFiles\T-182124. but it needs the .dwf after...

Yes, I tried it with one of the filenames and made a hyperlink to the file in the Location Field and it worked like you just described, but I was trying to keep from doing this over 4000 times. Its close to 5000 DWF Files.

Ok here is an example of my table: PrintFile: Table ID E,M,T# DWG FileName Location 01 T-182124-01 C T-182124 Hyperlink 02 T-182124-02 C T-182124 Hyperlink 03 T-182124-03 C T-182124 Hyperlink E,M,T#: Represents the number assigned to a particular part DWG: Represents that there is a...

I have been trying to create hyperlinks in a field named Location. The field that has the actual File Name is in the previous field. These actual files all reside on a directory P:\MAINT\MaintDBase\DWFFiles\. There is over 4000 filenames in this table. This Table is called PrintFiles, and I also...

Well I tried with a hyperlink in the data type column and typed the hyperlink to the c:\data\dwg2pdf\ directory in a new "image" field name in the form.But you only got the directory where all the files are but not the single file I was wanting it to get that matches the filename and etm# record...

I have a table & form that is named ETList. In the table and form I have fieldnames ETM#, and FileNames. The FileNames field has the same information as the actual file names on my C:\data\dwg2pdf\ folder. I would like to view the current file that I need by a Command Button or some type of...

I copied this database to a U:\shared\ Novell networkdrive at work. Changed all the links in this folder to the current folder on U:\shared drive, from my computer. I then set new users in User level security wizard. One was for me to administer and another for others to use as read only, so...