Recent content by morfusaf

  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

    Worked thanks a bunch...
  3. 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...
  4. 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...
  5. M

    Count(not duplicates)... HELP!?

    Well, I beleive I did what you said... and no luck... just get "#ERROR" I created the qry... copied exactly what you had... then created a Dcount in the footer... but just get an error. DO YOU HAVE AN EMAIL ADDRESS SO I CAN EMAIL THIS AND YOU CAN CHECK IT OUT... file is to large for...
  6. M

    Count(not duplicates)... HELP!?

    I am trying to count ... well both. First, i need to count the total events so I need to count the total actual events(EventID would probably be best for this... I guess, make an invisible eventID section???) Then I also want to count the 2 different types... I have 3 differnt types of...
  7. M

    Count(not duplicates)... HELP!?

    Attached is 2 databases ... a 2003 version and a 2007 version, incase you don't have 07. I am currently using 2007 and would hopefully like an answer in the 2007 version. The databases don't work properly because of some missing stuff but I figured this might help a little. On...
  8. M

    Count(not duplicates)... HELP!?

    I am sorry but it isn't working at all... I don't understand what your telling me to do. I do not wish to create a new group(if its possible not to)... as I have 3 differnt things in the Detail section, that I need to count like this.... Also on the report there is no onformat...
  9. 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...
  10. 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...
  11. 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...
  12. M

    Assistance w/ BeforeUpdate() when closing form

    Is it possible to not allow a member to close if changes has been made.. For example, If Me.Dirty Then Close = False or something that you can check if it hasn't been saved... then the form can't be closed? That might help me as well.
  13. 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]...
  14. M

    Assistance w/ BeforeUpdate() when closing form

    OK, my updated code... Still not working.. After doing more research... i changed to the follow Private Sub Form_Current() Dim CancelUpdate As Boolean End Sub To create CancelUpdate Private Sub Form_BeforeUpdate(Cancel As Integer) If (CancelUpdate = True) Then Cancel =...
Top Bottom