Search results

Try Is Not Null

Can't you share it with us? :(

In plain words, can you explain what criteria you want to apply?

Good. Always glad to help if I can ;)

In that case, I would use the following expressions as calculated fields in the query: startOfDay: DateValue(Now()) endOfDay: DateAdd("s",-1,DateAdd("d",1,[startOfDay]))

Where do you want to use it? In a query, you could use each line as an expression to create a calculated field for each value. On a form, you could use: = GetCurrentDayDates()(0) and = GetCurrentDayDates()(1) as the Control Source properties of two unbound textboxes.

Welcome to the forum :). Yes, the curve is steep but there are many knowledgeable and helpful members.

Are using Tabbed Documents rather than Overlapping Windows?

Not sure why that would happen. Have you tried Docmd.Restore it in forms open event

Welcome to the forum :)

Then why would you need to know which are missing. They should have no meaning to a user.

Are the ID's of "Auto-Number" type

You may find some of the posts in the following link to be of some help/interest: https://www.accessforums.net/showthread.php?t=82044

So sorry. I misread that. I am unable to help with listview.

Strange behavior is often a symptom of corruption. Perhaps delete the list box and recreate it or even replace the entire form. I'm sure a search of the forum would give much advice on corruption.

I don't think that is usual behavior. What code are you using to disable listbox? Can you post a copy of the db?

Asuming Assuming that SiegesNom holds the number of seats available before any bookings, you could: Change the Record Source of frmBooking to SELECT tblBooking.BookingID, tblBooking.PassengerID, tblBooking.BaggageNum, tblBooking.FlightID, tblAvion.SiegesNom, tblAvion.SiegesNom FROM tblAvion...

You will need some validation code in the forms before update event. Can you show us your table relationships, or post a copy of the db.

Welcome to the forum :)

I created a textbox, Named txt1 and set its Height, Width and Top properties, all to 0. Set its Locked property to Yes. In the Change event of TabCtl257: Me.txt1.SetFocus