I have a form that requests from the user a start and end date and then a device type. When the user enters the information, then clicks "View Available" - I would like to display devices available for the request timeframe. It should display all devices that either have no reservations...
I got this to work by using the following in the Row Source field -
SELECT tblClientMatter1.matter, tblClientMatter1.matter FROM tblClientMatter1 WHERE (((tblClientMatter1.client)=forms![tblInvoice]![ClientID]));
This works for the first record - but I need to have it requery for this field...
I am using MS Access 97 & have a form with two look up fields (Client List and Matter List). They both look up values from a separate table. Each record in the separate table contains a Client Number and Matter number.
The user will select a "Client" number & then I would like the...
I have an Access database that was developed originally in 97, I converted it to 2000, made changes. Then converted it to 97 per the client's request.
I received the error message that "at least one of the 97 object libraries is missing" I followed instructions on Microsoft's...
Ginger - thank you - I had typed it in wrong - tried to do it quickly & noticed my mistakes after I sent it.
Anyway - it worked perfectly! I had looked all over for this & hadn't been able to find it.
Ginger - I was browsing for some help on the DMax function when using 2 fields as criteria & saw your above example. I'm trying to number a field, sequentially, where it checks for previous records w/ the same Index # and Year. I keep getting error messages when trying to do this - could you...
I have a similar database & was able to get everything to work except we want to add a second criteria to the DMax function (not sure how to do this or if it can be done). It currently reads as shown below (I used the code from jfgambit above as a guideline)
**Notes: Index number (will be...
Lonnie - thanks so much. I am familiar with the DSum function enough to select the field (PaymentAmount) from my table [tblDonations] - however it's the criteria part that I'm having a hard time with now. First - how do I apply the filter for the year - is this part of the DSum statement? And...
I am working on a database for an organization that wants to track contacts & donations for each contact. I have a form for donations with a subform that displays Donation Amount, Date, Payment Method etc. for the current contact I would like to display on the main form the total donations for...
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.