Search results

  1. M

    Forms Questions...

    I have a form that returns some fields for me... However, I have this format for the page that I like.... but sometimes one or 2 of the fields are to long and get cut off.... is there a way to Wrap Text on these forms. I want it all to still print on 1 page.... so not extend to the...
  2. M

    Adding, event hours together... without duplicates

    I have a database... with 3 tables.. tblEvents tblPeople tblPeopleAtEvents In this database I have a report... This report displays each person and each event they did... In the events, i saved a varible called... Detail Hours I Currently have my adding together total events(without...
  3. M

    Not showing duplicates?

    Hello all, I have a database I'm working. In this data base I have 3 tables, tblPeople, tblEvents, and tblPeopleAtEvents. I have most of my reports working kinda how I want them.... I need 1 of them to work a little different. My overall goal, is to display events, (count these...
  4. M

    Count(not duplicates)... HELP!?

    Ok, I have searched this, and I have tried some of the things that where shown(most for 2003) and it hasn't worked yet or I didn't understand what they ment. I am using MS Access 2007. I have a report that prints out peoples names, which events they went to and the type of events... on the...
  5. M

    Pass "EventID" to other form and open Record ??

    Hi all, I have a simple, formUpdateWhichEvent form... this form basically just has a date Textbox, I select the date the event was on, then It has a combo box populated by which events were on that date, (this also populates the current form with the Eventtype from that event) then I...
  6. M

    Main form, edit value on Subform (all records) HELP!

    OK, So I have a 3 Tables, Events, People, PeopleAtEvents I have a form to create people(works great) I have forms to create Events - formCreateEvent, On this form I have a subform so that you can add which people attended this event- subformPeopleAtEv If the event is a certain...
  7. M

    Pull report by dates... and PersonID.... HELP!

    Ok, I have a database, 3 tables, tblEvents, tblPeople, tblPeopleAtEvents(Junction) I want to have a form where I pick the person Using the following Row Source (This just lets me see the first name and last name vs PersonID). SELECT [tblPeople].[PersonID]...
  8. M

    How to count EventType, to display # of This type...

    Hello, Ok, I have a database that has Events, People, and PeopleAtEvents(junction table). On the Events, I have 2 Differnt Types of events EventType = Party or Duty So, I want to pull a report for 1 person... I can do this already, that shows each event the person was apart of...
  9. M

    Assistance w/ BeforeUpdate() when closing form

    Ok, I have a form where a member can update a users information. I don't want the updates to save unless a user presses the btnUpdateMemeber, or clicks Yes on the msgbox when clicking home(it ask if they want to save or not). I pretty much have all the buttons and everything...
  10. M

    Database, ready for Launch... umm HOW?

    Ok, I have a database... its almost done... I have done this in the past about 2 years ago... I want to basically prepare my database for launch. I only want 1 form to open, when the database opens... and I want to ensure when I open a form (from clicking a button on the Home form) that...
  11. M

    Can you auto(Update) everything in the form when open?

    Basically, I have a form... on this form I have a check box(LongDistanceTrip), if the checkbox is selected another combo box field (cboPerdiem) becomes visible. The combo box visible is set to No, orignally... that way its not visible until the person says that the trip is long distance by...
  12. M

    open form, to record selected in other form.

    I have a form, formCreatenewEvent on this form I can create new events... I want to be able to update events as well. So, I have main home form... on there I have a button to update form... then 2 combo boxes and a text box.. The first combo box you select the date of the event...
  13. M

    Run report for last 30 days?

    Ok, I am just looking for a starting point on how to get my report to only look for and display events that took place in the last 30 days(or what ever days). Anyone have a link or something? I know its out there somewhere but my searches are comming up empty.
  14. M

    Subform View Help...

    Ok, I have a 3 forms, 1 for Events, 1 for People and one for PeopleAtEvents(Junction). So, on my CreateNewEvent Form I have a subform for PeopleAtEvents... Currently it works fine... I just don't like the view(Datasheet). I am aware I can change the default view to Single Form, or...
  15. M

    If then/ ensure not Null... Help?

    OK, I have a combo box, when I load the form, its empty... If the member wishes to run a certain report, then they will choose this combo box, and pick a members name... then click the Run Report button. After that it needs to check if the combo box had anything in it... if so then run report...
  16. M

    Report for only (select Group) of people? HELP!

    basically, I am trying to run a report... I have an allmembers report and seperate it by "HG_Flight" ... Alpha, Bravo, Charlie.... Now, I want to run a report that only shows the members that are in the selected "HG_Flight" So I have a form, formMemberReports , On this form I want a...
  17. M

    Need Report button on form(for current Record only)

    Basically I have a report that I want to run( I made it look like a form I usually have to hand write with the information) So I have this Form, on the Form, i create an event, I input dates, times, locations.... blah blah... now I want a button so I can "Print" this form in a better...
  18. M

    Help plz, Can't get combo box to find record/populate

    I have an Update event form... Oh this form, I want to have a "what date was event ComboBox"... then have a "Which event on that day?" Combobox... (I have this part working).... I have the cascading box working. What I need is, once I select the event on the second box, i need it to...
  19. M

    last cascading box, findRecord and populate form?

    Hello all, I am using cascading combo boxes, my first one looks up the date. the second looks up events on that date. currently the cascading combo boxes seem to work properly. but when I click on the event I want it to populate the form... currently it doesnt. I know I need to have an...
  20. M

    Cascading combo box help?

    Ok, I have 3 tables, event, person, and personat event... I have a junction table linking it all .. . All that works, Currently I am working on an formUpdateEvent. I want to start out by choosing the date of the event, cboDate (I need the date to be selected from DetailDate...
Top Bottom