Search results for query: *

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

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

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

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

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

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

Hi guys, i need to be able to display today's date on a form called "RealTime", date to be taken from my computer's clock. I already have a mini calendar form (one of the freebie ones floating around on the net)It shows you all the days and dates for the current month from which you can pick a...

Hi guys, i have an append query as seen below: INSERT INTO ozekismsout ( receiver, status, msg ) SELECT wompromo.SMS, message.Status, message.Message FROM ozekismsout, purchase, message, wompromo ORDER BY wompromo.SMS; Problem with this query is that when it appends to the table "ozekismsout"...

Hi, I have a Marketing database in which are 2 tables, one called "Purchases" and the other called "smsout". I have a query called "promo" which extracts all records from the cellular number field called "SMS" from the "purchases" table. The query as seen below is based on those customers who...

Hi guys, i have 2 queries "sendpromomail" & "sendpromotxt" which select either the email addresses or cellular numbers of customers from a particular table only. I would like to create a SendObject macro or something similar which would take the numbers or email addresses from either queries and...

Hi guys, i have 2 queries "sendpromomail" & "sendpromotxt" which select either the email addresses or cellular numbers of customers from a particular table only. I would like to create a SendObject macro or something similar which would take the numbers or email addresses from either queries and...

Hi guys does anyone know of a way to send SMS text messages from Access. I found one product called OzekiSMS but was wondering if you might know of another?. I am trying to send SMS messages to a "group" of numbers which have been drawn up from a query. 'SendObject' will not do it as it will...

Hi guys does anyone know of a way to send SMS text messages from Access. I found one product called OzekiSMS but was wondering if you might know of another?. I am trying to send SMS messages to a group of numbers which have been drwan up from a query.

Hi guys, anyone know of a way of changing the form icons within a Tree Control Form?. For those who know about Tree Controls, for each item you add to your list there appears a form icon to the side of it, it's those icons that i want to change. For example download sample form at the following...

Hello guys, i have a customer Order database. My question is in regard to 2 of the forms, one called "Sender" the other called "Recipient". SENDER FORM (fields) ------------------------------ Customer ID Customer FirstName Customer LastName Address1 Address2 PostCode RECIPIENT FORM (fields)...