I am trying to create a text box that will open up Windows Explorer and be able to map say: C:\WINDOWS\occache\file.exe
I was wondering if it were possible to write code to open up Windows Explorer and link that file location to the text box as either a link or just text.
I have been able to get this to be calculated in a query, I also have had no luck in getting it to populate on my table.
I changed my validation rule to: [ManHours]=[Photos]*0.5
It accepts the change but does not auto populate. If I try to add the expression to [ManHours] default value or...
This may sound a little juvenile, but can you be more specific as to what you mean? [Photo Request] is the name of the Table in question, the fields in question are [Photos] (formerly [# of Photos]) and [ManHours] (where I am trying to get [Photos]*0.5).
[# of Photos] is the field name and the caption. I have tried to change it to Photos with the same results.
I also realize [Time] is a poor choice of name for a field when its only value was going to be (0.5), I was just trying something that may have worked, it didn't but I wanted to try...
I have and the error I get is as follows:
The database engine does not recognize either the feild '# of Photos' in a validation expresion, or the default value in the table 'Photo Request'.
That is what i get when I put that expression in Default Value. If I put it in Validation Rule I get...
I am having a bit of trouble. There is a field [# of Photos] that I am trying to multiply by a constant (0.5). Any form of equation that I attempt to use is rejected. Is there anyone that is able to help me out here?
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.