Search results for query: *

Can anyone suggest a way to do this in access? any help is much appreciated! Thanks!

Hi there, cna any one tell me how to go about creating a progress bar in a form, and triggering it so that it shows progress while the mail merge is loading? thanks!

Hi, is it possible to add the automatic playing of a welcome sound file to an autoexec macro? IThe macro presently opens the password form, and on entry of the correct password, opens the main menu page. Would it be possible to play a welcome sound when the main menu form is displayed? If so...

I have an order form on my system, and the order numbers are set to be five digits starting with the letter O. Can I set the text box on a form or something to increment the number? I.e if record O1234 has just been entered, and the user wishes to add another record, can the system automatically...

Hi there. I have several forms on my database, but the problem concerns frmDelivery and frmItem. On the Delivery form, there is a sub form called subDeliveryDetails. On this form there is a text box (txtQuantityReceived), which contains the quantity of a particular item which has been recieved...

I want fdlgExitNonUse to be displayed when the user is idle for fifteen minutes. I have created a form called frmDetectIdleTime, and set the timer interval to 5000 for this. I have the following code behind the on timer function of this form: Private Sub Form_Timer() Const IDLEMINUTES...

I want to run a macro which in turn runs a macro every saturday. I have the following as a module. it finds the nearest saturday. Would it be possible to amend this code to include a few lines to run the macro only if today is saturday? Function GetSatDate(CurrentDate) If...

I have three switchboards on my system, and when I try to edit the second or third, any changes I make apply to all switchboards. Is this normal, and if so can I prevent this from happening?

Is it possible to run two events on the on timer section of one form? i have tried naming both procedures Form_Timer() but when viewed in form view an error message appears which says I cannot have an ambiguous name. Any suggestions?

I have a form which I have made into a report. On the form is a list box containing the names of all of the reports on the system. The user selects a report from this list and chooses view. How can I make the dialogue box dissappear when the report is loaded?

Hi, I have a code that makes a the text on a button go bold on mousemove, and default when the mouse moves away. It works when the user moves the mouse over the button, as the text goes bold, however, when the user moves the mouse away from the button, the text does not return to default. the...

Hi I have a module which performs a calculation, and I am told that I can use it by typing in certain criteria into the immediate window. How Do I show the immediate window, and how would I use it? Thanks!

Hello. I want to create an autoexec macro which will check if today is saturday each time the system is opened. If today is saturday, then I want it to run a query(qryLowStockLevels). However, I do not know how to refer to the date? I understand that dates are stored as mnumbers i.e. 578932...

Hi there, I want to create an autoexec macro which will check if today is saturday each time the system is opened. If today is saturday, then I want it to run a query )qryLowStockLevels). However, I do not know how to refer to the date? I understand that dates are stored as mnumbers i.e. 578932...

Hi, i have a message box that pops on the screen after the computer has been idle for ten minutes to tell the user that they have been idle and the system will close in five minutes if there is no action. Is there a way to make the message box make a noise or perhaps the title bar flash or...

Hi there, I have a few sales reports, but I want to have an input box whereby the user enters the month and year, and a report is shown/generated including a graph. is there any way to automate this process or am I asking too much?