Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: julie67
  • Order by date
  1. julie67

    date now stamp on field

    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!!!
  2. julie67

    date now stamp on field

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

    Record Count of a Sub form

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

    Record Count of a Sub form

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

    date now stamp on field

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

    Run a report from a form based on the current record

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

    Run a report from a form based on the current record

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

    Run a report from a form based on the current record

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

    Excluding records from the drop down list in a combo box in a subform

    Where do I enter that code?
  10. julie67

    Run a report from a form based on the current record

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

    Run a report from a form based on the current record

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

    Changing the search field in combo box in a subform

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

    Excluding records from the drop down list in a combo box in a subform

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

    Excluding records from the drop down list in a combo box in a subform

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

    Changing the search field in combo box in a subform

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

    Create a new table based on an event procedure

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

    How do I set up a parameter query for a Y/N field?

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

    Add new records that have info linked to other tables

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

    Remove a record from a table that is linked to other tables

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

    Remove a record from a table that is linked to other tables

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

Part and Inventory Search

Back
Top