Recent content by barry2004

Hi guys how do you remove the focus from an object. In other words, the opposite of SetFocus?

I'll see if that helps

Not really sure i get what hey are trying to do on http://www.mvps.org/access/forms/frm0031.htm

WORKS, NICE ONE DUDE!!

Hi guys i have search form on my database which searches for results from a query called qry_searchBK and this query is derived from a table called tbl_bookings. I have a search button on the form which has on OnClick event as seen below. When i click on the search button i get an "Run-time...

Or See: - www.baybie.clara.net/Calendar.mdb

Hello it's: Private Sub Signed_In_DblClick(Cancel As Integer) DoCmd.OpenForm "frmCalendar" End Sub frm_calendar is a freeware calendar form which you find around on the internet...

Hi guys, I have a datasheet form called "frm_bookings" which has 2 Date fields called "Date In" and "Date Out". Each of these fields has a On_Double Click event which then Opens a calendar form called "frm_calendar", this works just fine. Here's the problem, if "frm_bookings" is used as a...

Hi guys, i would like to know how to Run a Macro when a certain condition has been met. I have a table called "tbl_inventory" and a query called "qry_CountofInventory", the latter being a count of how many items (lapptops) are in our inventory. Just like conditional formatting i would like to...

Hi guys i have a database used for tracking equipment loaned out to staff. It is comprised of a form called frm_loan derived from tbl_loan which has "Date Out", "Due Date" & "Date In" Fields. The "Date Out" Field has a Default value of "=Date()" and the "Due Date" is derived from formula "Due...

Thanks Robert.

Hi guys i have a problem but one which i believed you have encountered and answered before. I wish to create a form (frm_lapstock) which has buttons on one side which when clicked on would open and display other existing forms on the right-hand side of this new form. See :-...

THANKS PAMPERS & THEACEMAN YOU GUYS R GREAT!!

Hello guys the subject is self explanatory, is it possible to create forms with curved edges instead of the straight ones and can you also change the colour of "Page" Forms??

Thanks all of you and for those who have benefited from this post all the better. I had already used the Mod 2 <> 0 control ages ago but was only able to get the specific field formatted. Will take what RoyVidar said into consideration. I really had no significant need for it, was more for...