Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Keidran

    VBA Code linking to explorer

    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.
  2. Keidran

    Multiplying a field by a constant

    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...
  3. Keidran

    Multiplying a field by a constant

    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).
  4. Keidran

    Multiplying a field by a constant

    [# 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...
  5. Keidran

    Multiplying a field by a constant

    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...
  6. Keidran

    Multiplying a field by a constant

    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?

Part and Inventory Search

Back
Top