Search results for query: *

Hi Hohn(BoxHead), Thanks to you and others for the reply! The conflict list box is a one lean and fast SQL "Select" statment that compares the presence of other rooms with the same number, date and time! The First List Box selects all the Reservations done for the current Room No. and this is...

Hello PHV The code in the first list box is an SQL statment! Is there is a way to optimise it so it delays executing the code?? Thanks ANaguib

Hi Fransirvent, Dim a string flag (variable)Call it something like "RunCurrent" and give it a value = "yes" insert an if block in the start of the current procedure and allow the rest of the code to run only if the RunCurrent="yes" if RunCurrent = "yes" then <<< Put all your code here >> Else...

Hello Tom and John, Thanks for your thoughtful ideas, here is a bit more about the issue, and the reason why I am asking for some way to delay the execution of code in the Current procedure. The form allows the user to make a reservation of rooms (about 200) for certain dates and for certain...

Hello Jason, Highlight the control you want to bring in front of the picture, then cut it (Ctrl+X) and right away paste it (Ctrl+V) and place it in the same place it was in, you will find that it will be placed on top of the picture ... It will keep the same name, values and properties. I hope...

I have a big collection of records in an Access database and in "Current" procedure there is a big chunk of code that takes long when it runs. When I am just navigating from one record to another, the whole code in "Current" runs before I can move to the next record! This takes long time and...