Recent content by julie67

I think it is working... I went to the code builder like you said on the BeforeUpdate property in the Names form, and typed: me.[TimeStamp]=Now() where TimeStamp is the name of the field in the Names table and it worked. Cool beans!!!! Thank you so much!!!

is the mytimestampcontrolnamehere the name of the field i am storing the date in?

I think I'm realizing that I may have to use the DCount function, as I want to count the number of attendees that are attending a function. That is...any record where Attending=Yes.

Silly question...where do you put this code?

I have read these posts and i do not understand how to write an event procedure in the before or after update field. I am just trying to put a date stamp on the record if any field has changed. I have a fmNames form and user can change Names, addresses, etc as well as add new records. I don't...

Thanks for the tip, however I figured it out by reading the link to the code you provided.

I think I figured it out...I forgot to add the strWhere in the part of the code: DoCmd.OpenReport strDocName, acPreview, , strWhere It seems to be working...thanks for the help Jules

I added the code in the event procedure for the command button, but it is not working....obviously I'm not much of a VBA programmer...any help would be great...thanks,julie

Where do I enter that code?

I need a little more guidance. Should I build the report off of the original query and not put in a parameter requirement? Where on the command button do I insert this code? I also do not understand this code. It is important to use the current record since the user could type in the event...

How do I run a report, for example to show the attendees for a particular event that I have selected in the form? I want to add a parameter query to select that particular event and run the report based on that parameter all in one shot. any suggestions? thanks, Julie

Thanks--I already figured it out, but it is nice to know I'm on the right track.

Thanks--I just figured it out...I must not have saved the query, but it works now. However, I can't figure out how to cancel adding a forbidden record. Tbis subform is in a datasheet view, so when I add a command button to Undo the operation, it doesn't come up. For example, I put in a...

I have a subform to add names to events and I want to exclude the names that are no longer active so that they are not inadvertently invited to an event. I went to the Row Source field in the combo box properties and changed the query to include the Active? field, but it is not working. Any...

I have a subform that allows the user to select names to attend events. The form, fmevents, has the subform, fmAttendees. The record source for the subform, fmAttendees, is a query linking the table, Names, and the table, tblAttendees by the fields, AttendeeID & NameID. The combo box for...