Search results for query: *

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

Hi guys, trust me i have tried everything one can think of. Not even conditional formatting has the above mentioned capabilities.

Hi guys, this question has been asked in various guises but not in this manner. Are there ways of changing the colours of all the rows whose ID numbers are either Odd or even? E.g. rows with record ID's 1,3,5,7,9,11 etc. would have a different colour to the even numbered rows which would remain...

Hi Guys, i have a call logging database for which i would like to have a date & time stamp included on a form called "History". The form has 4 fields: Comment, Hrs, mins, Date. The "Date" field will be the one to contain the Date/time stamp. I have tried using =Now() but that's not going to help...

Hi guys i once asked this question at another forum 2 years ago. Is it possible to view icons/images on a datasheet just as you would on a TreeControl in Access?. So in other words have a field on your datasheet that would just display either a .bmp or .ico image and it would display the same...

Hi guys, I have a form similar to the Microsoft Outlook window (tree control on the left and subform on the right). Like the Outlook window I would like the subform to change each time you clicked on an item in the tree control without opening in a separate new window. Ideas…Know this would be...