Search results for query: *

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

If a user does not enter any text in the parameter query is there any way to prompt them for a value else cancel the request.

Many thanks, thats it I have messed about with every combination to try and get what you achieved. Got the "" in the wrong places. Cheers much appreciated

Try adding this to the open event of your form. Dim strinput As String strinput = InputBox("Please Enter Password") If strinput = "password" Then DoCmd.OpenForm "yourformname", acNormal Else MsgBox "Incorrect Password" DoCmd.Close acForm, "yourformname" Exit Sub End If

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

Yes you are correct I have it now, I was trying to put the file name in there rather than the title. Many thanks I think this instruction will do what i need.