Recent content by stuandwil

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!

you have added the getopenfilename code off that link page also. This is required to bring up the browse file and pick BE.

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

many thanks, I have it working from your example.

not sure how to implement what you say, I have this but not working as yet. Private Sub Form_AfterInsert() [cboproduct].DefaultValue = cboproduct End Sub

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.

or >now()-720

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

me.requery did the trick, the second FE is more of a look only so it does not matter that the whole thing is refreshed. Thanks

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

Check this info out http://www.utteraccess.com/forums/showflat.php?Cat=&Board=85&Number=317683&Forum=,,,,All_Forums,,,,&Words=&Searchpage=3&Limit=25&Main=317618&Search=true&where=&Name=33366&daterange=&newerval=&newertype=&olderval=&oldertype=#Post317683&bodyprev=

many thanks

The form is specifiaclly for searching for keyword if one is not entered I want the form to close. Maybe not possible. Stuart

I have a button that opens the form which contains the combo with the parameter query. When I click the button I get the parameter query "Enter Keyword", if a word is input the form is opened, combo drops down with the list of problem fields containing the chosen word. If when the parameter...