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 TouchToneTommy 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: *

  • Users: Jelloshot1
  • Content: Threads
  • Order by date
  1. Jelloshot1

    ListBox Question.....

    Hello All, This should be an easy one. At least that's what I thought. Here goes.... I want to generate a report based on the items selected in a ListBox. The ListBox contains Names. The report should put the names in order of Seniority. In the query that the report is based on I have the...
  2. Jelloshot1

    Multiple Logons in .LBD file?

    Hello all, I've inherited an Access97 DB that shows anyone that is logged on as logged on twice in the .LDB file. The DB is delivered to those who have access to it through their Novell Logon. (The DB icon that appears in the Novell Delivered Applications window is actual just a shortcut.)I...
  3. Jelloshot1

    Function Not Available???

    Hi all, I have a "small" problem that I hope someone can help me with. I'm running and access '97 application on windows 95. I discovered that some of the queries that the program ran were too "complicated" unless the full version (not typical install) was installed on all...
  4. Jelloshot1

    Current Year??

    Hi all, In my database (Access 97) there is a table for employee sick time used. I was wondering if there is a way to filter records in a form and report to show only those with a date in the current year? I've tried using **/**/01 in the criteria line of the query that runs the form. It...
  5. Jelloshot1

    Combine IIf Than Statements?

    Hi All, Would like to say first that I have found this site and it's Q&A very helpfull! I'm learning more everyday. My question today is about If Than Statements and can they be combined as in If (IsNull(Forms!MyForm!FRI) And If(IsNull(Forms!MyForm!SAT) Then RDO="F/S" End If I...
  6. Jelloshot1

    Compacting Error...Please Help!

    Hello All, I'm running an Access 97 database that is used for staff information as well as tracking time & attendance. We have over 1300 staff members already in the database and are adding more almost daily. The problem I am having is with compacting. The database had grown to 978MB. When I...
  7. Jelloshot1

    Can an InputBox be Formated to show **** instead of text ????

    I'm using Access 97 and have a need for some security (passwords) within the database. I am using an InputBox that promts the user for their password before it opens another form. I have the passwords stored in a table with the Imput Mask set to "Password" thus when viewing the table...

Part and Inventory Search

Back
Top