Search results

Greetings~ I wish to create a form that will launch a report based on a user's input for particular fields. One of the fields is from a list box I have created which lists the options available. The other field would be a date range. e.g. I would like to see all the sales of Laura Smith from...

Thank you ever so much! Had I allowed the use of the Primary Key in the beginning, I wouldnt have pulled out my hair :: cheers :: ~Deirdre

Greetings~ I have created a database to store information regarding number of donations and dates by each patient. I have created a List Box to quickly look up a patient's information in order to update it. I used [LastName], [FirstName], [M], [BloodType] as identifying information based on a...

Excellent - Progress is made! That definitely records the date as wanted. Thank you very much for your patience and time. It is very much appreciated. My teeth thank you as well - no more pencil biting! ~Deirdre

I am running Access97 and do not see an On Current() option for my event. I've tried it with After Update and On Change with no success. I am not sure if thats (On Current) is a new feature with 2000, or an add-in - but I do not see that. :: grinds teeth ::

:: still biting pencil ::

Thank you very much for the expeditious reply. I've entered the information as you suggested, however it is still not working for me. I even tried the event procedure to work "On Change" Basically, I have a check box [AddaDonation] that when checked adds +1 to the [NumberofDonations] text box...

Greetings~ I have created a database which tracks the amount of pheresis donations of a patient. I have a text box to record the date of the last donation [LastDonation]. I have a text box to record the number of donations [NumberofDonations]. I also have several text boxes to record the dates...

:: smile :: Alexandre, I sent you an email at the email address you have listed in your profile. ~Deirdre

Pcs: Thank you for taking the time to assist me in this endeavour. Unfortunately I am a beginner to ACCESS and will need more time to 'play' with your method. Alexandre: I've tried following your 'recipe' and have come to a stumbling point. I created a form per your instruction, however when I...

..please bear with me. I have created a database for storing injury and reaction information. The form and queries and reports are functioning just fine. My organization's fiscal year starts on July 01 and ends on Jun 30. Alexandre was wonderful to show me how to change the "Quarter"...

^^ Snoopy Dance =) [This message has been edited by Deirdre Marie (edited 09-18-2001).]

:: snoopy dance :: It worked! Thanks ever so much!

Hello~ I wish to sort information from a query in a report by Quarter. I am aware of how to do this normally, however my problem is my organization's fiscal quarters are not the same as usual yearly quarters. For example, all dates in September for my organization are Q1 as our fiscal year...