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!

Register Log in
  • Congratulations derfloh 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. racerboy

    Not allowing users to view tables/queries/macros etc.

    Hey Dustin, Yeah, there is a Startup menu in A97 as well and there is a Switchboard Manager. I'm really new to Access (but having a lot of fun with it) so I apologize if some of my questions seem stupid! :o) -Frank
  2. racerboy

    How do I set a field on a form to verify another?

    Here's one that may help: <HTML> <HEAD> <TITLE>Password Check</TITLE> <SCRIPT LANGUAGE=JAVASCRIPT TYPE=&quot;TEXT/JAVASCRIPT&quot;> <!-- Hide script from older browsers function validForm(passForm) { if (passForm.passwd1.value == &quot;&quot;) { alert(&quot;You must enter a...
  3. racerboy

    Combo boxes

    Can I jump on the bandwagon too? :o) frank.bosley@roche.com
  4. racerboy

    Grayed out text box &amp; Flash Movie in form header

    Good morning! I have two questions: 1. Is there a way to have text boxes disabled (grayed out) until another box is filled in first? I.e., you can't enter a Closed Report Date until the Pending Report Rcv'd Date has been entered. 2. As I was messing around, I saw that you could insert a...
  5. racerboy

    Not allowing users to view tables/queries/macros etc.

    OK, now it seems to work. It seems that all I had to do was get completely out of the db after unchecking the Display Database Window. I would still be interested in knowing how I would go about setting the StartupShowDBWindow property to false. Thanks again! :o) f.
  6. racerboy

    Not allowing users to view tables/queries/macros etc.

    I looked in the A97 help index on how to set it up so that when a user opens the db, all they see is my Switchboard. This is what it said: You can set the StartupShowDBWindow property to False to hide the Database window so the user can't see the tables, queries, macros, and modules within...
  7. racerboy

    Using record in another field as Criteria in a SQL Statement

    Rick, Thanks so much! Here's how I incorporated your suggestion, and it worked out beautifully! WHERE (((DateDiff(&quot;y&quot;,[PendSent],Now()))>15) AND ([PendRcvd] Is Null)); I am really new to Access and SQL and you are going to see a lot of me around these parts. :o) Thanks again! f.
  8. racerboy

    Using record in another field as Criteria in a SQL Statement

    I have a report based on this SQL statement: SELECT Information.[Inspection Number], DateDiff(&quot;y&quot;,[PendSent],Now()) AS DaysElapsed FROM Information WHERE (((DateDiff(&quot;y&quot;,[PendSent],Now()))>15)); Basically, it tells me how many days have passed since I sent out a pending...
  9. racerboy

    Linking to an image problem

    I'm new to RDBMS, so go easy on me. :o) I have a report based on this SQL statement: SELECT Information.[Inspection Number], DateDiff(&quot;y&quot;,[PendSent],Now()) AS DaysElapsed FROM Information WHERE (((DateDiff(&quot;y&quot;,[PendSent],Now()))>15)); Basically, it tells me how many days...

Part and Inventory Search

Back
Top