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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.