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