Search results

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

Worked thanks a bunch...

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

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

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

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

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

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

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

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

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

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.

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

Sweet thanks.

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

Here is my current code. ' So that when the form loads, it automatically makes Cancel false... this ' way when you Close the form via, tab / right click /close it will cancel ' and undo Private Sub Form_Load() Cancel = False End Sub ' -------------------------------- ' So unless...

OK, So what code could I use, to ensure that it cancels when needed. How do I make so I can have a .... like this... Cancel is normally... Cancel = true Unless I click a button that is supposed to save, then Cancel = False BeforeUpdate() If Cancel = True Then Me.Undo...

Agreed... hehe, Sorry didn't explain .. I changed it to that code, to see if it would work for me when I right click, closed the tab... DIDN"T ... so if you right click tab and click close.... it just bypasses the BeforeUpdate()?? thats what it seems anyway.

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

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