Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: stuandwil
  • Content: Threads
  • Order by date
  1. stuandwil

    supress outputting to dialog box

    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!
  2. stuandwil

    can't open fe/be database

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

    Default field to previous value

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

    dlookup value to trigger macro

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

    closing an inactive form

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

    How to refresh other front ends

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

    Using a combo box to search form

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

    OLE values

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

Part and Inventory Search

Back
Top