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 Chriss Miller 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. Bandenjamin

    How Can I Disable Specific Proofing Option in Word

    I'm approaching this from a backwards angle, but basically I need to get a grayed out option in Word 2007 to no longer be grayed out. The option is under the Proofing section of Word Options and is "Hide spelling errors in this document only". There are a couple others that are also checked...
  2. Bandenjamin

    Dividing time by number

    Hey all, I've seen this question posed a couple of different ways but I still can't seem to get it to work using the forumlas I see. First here is what I'm trying to get at. I have a cell that has a number of hours, Minutes seconds (h:mm:ss) This is a total of work time for a week. Ie...
  3. Bandenjamin

    Field Validation on Day of week

    Hey all, I've got a table that has a date field that I need to be an "end of week" date (basically Saturday). I need to make sure that no one enters anything in to that field other than a day that is a saturday. I've tried setting up a validation rule Weekday(7) But It did not work. I...
  4. Bandenjamin

    Adding HTML signature with Javascript to Notes 7.0.2

    Hey all have a somewhat tricky one. I've got an html file with the following script <span><script type="text/javascript"> var d=new Date() theDay=d.getDay() switch (theDay) { case 1: document.write("Before the first year nobody gave it a chance. Now, 36 years later, everybody knows...
  5. Bandenjamin

    Count Yes, No, exempt in Form

    Hey all, I have a form with 21 combo boxes that you can choose 3 options in (Yes, No, Exempt). I would like to have a box on the form which reports the percentage or "score" of "Yes". How can I get a count of Yes/Yes+No? I tried using text box with =Sum(IIf([combobox1]="Yes",1,0)) which kept...
  6. Bandenjamin

    Some Help on Changing IT Positions

    Hey everyone. I'm in need of some serious help on deciding the next steps in my career. I'll layout what i've already done/got. Degree: Completed AA in business w/ concentration in IT ***Do have plans to continue education, either at Portland State University for AIU Online (leaning toward...
  7. Bandenjamin

    If then Else statement in Report on Open

    I have a report where i want the report to look at field1(pulled from QueryZ) and if Field1 = x then Field2 (set as a parameter) = y What I've tried so far in the on open event If [field1] = "x" Then [field2] = "y" ElseIf [Field1] = "y" Then [Field2] = "z" Elseif [Field1] = "z" then [Field2]...
  8. Bandenjamin

    Accessing Records using a Data Access Page Across Network

    I've got a Database that resides in server X and can't be moved. There are two tables in this database that need to be accessed by people that don't have access to server X. I have tried creating a seperate db that links to those two tables, then making a Data access page and posting it on the...
  9. Bandenjamin

    Variable Report Name

    Hope this one is easy. I have a report called "AnalystReviewReport". It runs off a query with a parameter for "Analyst" and "ReviewDate". I would like the name of the report to change to reflect a combination of these two names...ie "BillGeorge022807" would be the report on Bill George for...
  10. Bandenjamin

    Spellcheck that ignores other fields

    I know there are already a hundred posts about spell check here but I couldn't find an answer for the last part of my issue. I have a form that has multiple text boxes. On exiting a particular box I want to have it spell check that box, but ignore the others. Right now I have the following code...
  11. Bandenjamin

    Accessing VBA Code without Opening Database

    Ok here's an interesting problem. We have a database that opens with a password. One of the users of this database had the idea to set up a macro to automatically close the database and put in in the OnTimer Property of a hidden form. They set the interval for the timer to be 1000 not...
  12. Bandenjamin

    Trying to get a running sum that excludes negative values in a report

    Ok this is a little weird and I hope easy. I have a report where certain items are counted and totaled. To make a long story short I have a text box that will occasionally generate negative numbers. What I am trying to get is a total of all the positive numbers, ingnoring the negative ones. The...
  13. Bandenjamin

    Getting an Average to display on a report

    I have a report where there are T/F fields. In the Group footer these fields are totaled and a percentage is calculated(ie if all 11 are checked for group it will report 100%). The report will consist of about 25 of these records. I am trying to add an "average" percent at the bottom of the...
  14. Bandenjamin

    Creating a &quot;Search&quot; Form in Access 2000

    I am experiencing the same problem as discussed in thread 181-780031. I would like to create a form that leaves open text boxes where a user can input criteria (ie last name) and it will pull up all of the records with that last name. I have been able to come close to the desired result by...
  15. Bandenjamin

    BCM Basics

    My company is currently beginning to add the BCM system to some of our locations. They are installing BCM 3.7. I am wondering if anyone has a good resource for information on this system from a support standpoint. Known issues/fixes and other things of that nature. Any help is appreciated...

Part and Inventory Search

Back
Top