Search results for query: *

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...

I have finished this, but the client does not like that you have to add attendeess to the events table by NameID. He wants to look up by last name with a view of the full name in case there are multiple people with the same last name. I have fiddled with the subform, fmAttendees, and if I...

Dumb question I'm sure....but how do I set up a parameter query for a yes/no field? Thanks, Julie

I have a "Names" table and I have a "Property Information" table. I have a third table "Property Names Association" table. The Names table has information on people. The property information table has information on specific properties. These are not in the same table since multiple people...

The only problem is that they may quit one association but still be a member of multiple other organizations. I can add the deceased field easy, but I don't know about the other one.

I know this is probably an easy one, but I am pressed for time. I have a "Names" table with names in it. It is also linked to other tables such as "Property Names Associations" which indicates the properties each person owns. I also have it linked to Group affliations as well. If a person...