Search results

What do you mean? They are Yes/No values themselves.... is that what you mean?

It was in the pictures attached but here it is anyway: Private Sub Form_Current() Call AirTravel_Click Call Hotel_Click Call Rental_Click End Sub The three "Clicks" are my three check boxes.

Hi! Ok, this was working - and does work in another database I made, however it is no longer working and starting to piss me off! :mad: I made a form where when a check box is checked, all relating fields will become visible on the form. There are three of these on the form, each making...

Well the code you just gave gives an error saying there is no operator. And as for the dates, mostly there are only two people entering information. Everyone else is only going to enter dates to search for information... and I just can't seem to stick with one way of entering dates. I had...

Ok, you only have to enter it once now... but I don't understand what you mean by Format() function. I tried formatting the text box but that doesn't make a difference. I don't want to have an entry mask for the date since everyone I know enters dates differently so I don't want that to change...

By doing that it only makes you enter the criteria twice. It does display but twice is not fun - also it displays however you type it in - not in an actual date format. (I mean you can type any of the following and get results but all look informal and not right on a report with words...

I made a query to pull records by their date. (Criteria: Between [Start Date] And [End Date]) Now I was wondering if on the report I am making for the data pulled by the query if I could somehow make the data entered into the criteria (pop ups before the report is loaded) appear on the report...

Nevermind. Stupid computer not doing what it should... *grumble grumble*.... working now.

This is so stupid... grr.... Ok... I am trying to make a simple query to pull records with dates between the start and finish date specified by the user. In the date column under criteria I put Between [Start Date] And [End Date]. It does nothing! I enter say the first of this month and...

Thank you. I have it working now.

Where is it. I can not find the option for the "OnLoad" Event.

This is what I have: Private Sub Form_OnLoad() If Not Me.NewRecord Then DoCmd.RunCommand acCmdRecordsGoToNew End If End Sub

Sorry for the long wait between replying. I had other priorities to take care of first before the end of the month. So here is what happened: I tried this but no matter what I do, it always comes back with an error with the If Not Me.NewRecord highlighted. This doesn't work either. What am...

Is there a way to have a form open to a blank record so that way you can skip the step of either going all the way to the end or hitting the [>*] button? I still want to be able to access the other files but it would be easier to have it automatically upon opening go to the step that most...

OK... it is official. I have been out of school for far too long! Thank you! I can't believe I mistyped that :o You are right and it is working now. I will add the code to the other forms as well.

Well not so much. I entered that in and the problem is still there.

Does that mean I should add this: Private Sub From_Current() Call ChangedHotel_Click Call CanceledHotel_Click End Sub Both are check boxes that are causing the problem.

I forgot to attach pictures!

The check boxes are bound.

Ok... I am making a database with four forms that record details about changes and new bookings different from our original schedule that we make for hotel bookings, rental car bookings, taxi/limo bookings, and airline ticket bookings. Each form has 3 check boxes: Is this booking new? Was...