Recent content by EjS

Thanks. I know putting the data twice is crazy... The form I'm using is a data access page. I don't see the After update event anywhere on the properties there. Do you know where I would put the code for the access page??

Hi, I have a table and for a specific reason, a field is repeated. Is there a way for Access to automatically fill in the second field when the information is typed into the first field? A rule in the design table maybe? So the user doesn't have to type it twice. Thanks for the help!

I don't think I want to sort them... I would like two page headers. This is the format I have right now: TotalA TotalB TotalC Total D Option1 Option2 Option3 Name1 $$$ $$$ $$$ $$$ $$$ $$$ $$$ Name2 $$$ $$$ $$$ $$$ $$$...

Hi, I'm trying to build a report with the following format on the same page: TotalA TotalB TotalC Total D Name1 $$$ $$$ $$$ $$$ Name2 $$$ $$$ $$$ $$$ Option1 Option2 Option3 Option4 Name1 $$$ $$$ $$$ $$$ Name2...

Hi, I would like to build a form with several drop down options for different fields, and once the user picks different options, a report is generated from those picks. Sort of like picking different "features" and getting results based on what you pick. Is this possible within Access? Any...

Thanks Don-I'm still getting used to the functionality of the properties box.

Hi- I've used the look up wizard to create drop down menus for my forms. I'm wondering if there is a way to make a change to the drop down list without redoing the whole list through the wizard? Thank you!

Thanks! Actually when I placed the button on the form the wizard popped up and I assigned the command right away. One more question-how do I make it open when access opens?

I'm new to Access...would like to create a menu that opens when the database is opened. From here you would have choices (open form, run querie, etc) if a button is pressed. I know how to do the macros behind the buttons but can't figure out the menu part. Any help is appreciated!

Thanks for the help--I'm a beginner!:)

Thank you. I put that expression in and changed a record but it didn't put today's date.????

I have a date field that is set to automatically put the current date in when a new record is entered. Is there a way to make the date change to a new date if I update the record? Say I make a change today, and the date field automatically changes to today? Thank you!

Question: I have made several tables, with forms that correspond to the tables. I need to change/update the tables and am wondering if there is a way to automatically have the changes reflected on the corresponding forms. I've wasted time re-doing the forms to match the tables. Any...