Is it possible to not show the dialog box that says outputting page 1 of ---. I am using an on timer event to send a report out as html every so many minutes. The box comes up when the function runs, I don't wish for my users to see this happening. Probably not possible!
I finally got the linked table manager to run at work and made a third copy of my frontend and placed this on another pc. I set the links with the manager and opened up the database OK. However when i closed it and reopened it says that the microsoft jet etc can not open the db because someone...
Is it possible to populate a field with its previous value. A record is added every hour, a product is chosen from a drop down. 98% of the time it stays the same but every now and again the product will change.
We have a machine where is is now routine maintenance to change the "suckers" on it every 8 days. I use a query to give me the amount of days since last sucker change. On a form I use the source below to show the result.
=DLookUp("downtime","suckers")
I use conditional formatting to display...
Is there a way to close an inactive form without running permissions/security. Basically if a person is not typing in a field, close the form after 5 minutes. If they are typing either wait and time again or close when typing finished.
Thanks
Stuart
I have a form "Main" which runs from 2 Front Ends which list tasks outstanding. If a record is added from 1 front end what code will refresh so that the number of records in the second front end increments and shows the new addition. The form refreshes itself every minute and this updates the...
I want to be able to search a field called problem for any word written in a combo box. The best I have been able to do is create the combo and run a parameter query that prompts for keyword. However I can only get it to work by adding the * i.e. *fault*, which means the user has to type in the...
I have several OLE links from Excel which read values in from PLC's which are then pasted/linked on a form in Access. They display live data on my form (machine on/off) and all work fine. Is there any way to use the value of an OLE field to trigger an event. On updated is no use because the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.