Thanks Mike. The sample database in that thread may come in handy in the future. Unforuntately, this doesn't really solve my problem.
My question to everyone out there is why does my using a dialog box to obtain criteria for a query that outputs to a report work fine, but does not work when...
Hello helpful Tekies,
I'm trying to create a user-friendly interface for a contacts database in Access. First, I'll describe what I want to happen and second, what works and what doesn't right now.
1. From a switchboard form the user clicks on a button "find contacts"
2. Unbound...
Hello,
We're running Quark XPress 5.01 on a PC. Periodically when we go to open a file, we receive an error message "Out of Memory [-108]" and we cannot get into the file and therefore have lost all of our work unless someone out there in helpful Tekland knows how to recover it...
Help.
I've created a database of information that can be viewed (but not modified) by anyone in the office. Because some computers are running Access 97 and others XP (and even a few on 2000), I created the database in Access 97. Everyone has an icon on their screen which they can click, and...
Thanks! I think this has gotten me on the right track
So if I understand the procedure:
1. I need to create FORM 1 in which the user selects the broader criteria that causes a MAKE TABLE query to generate TEMPTABLE.
2. I need a form that allows the user to select which records from...
Hi Everyone,
Here is what I'm trying to figure out how to do...
Currently: Via a form, a user generates a report from a query against the database (the user selects a date range and 1 or 2 other criteria).
Required: The users want to be able to decide which records from the list generated...
Thanks, that sort-of works. However, I still need two things to happen.
1. The user needs the option to change it when appropriate.
2. I need either the default or the user corrected data stored in the "End Date" field.
By putting a formula in the control source, it seems to...
In trying to make a data-entry form as idiot-proof and user-friendly as possible, I want the computer to calculate the end date for a lease, based on the user typing in the start date and the length in years.
I've figured out how to make the information display as text:
[start...
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.