Search results

First create the startup form, it can be unbound. In the On timer event for the form enter code something like this. Docmd.Close Docmd.OpenForm "Your Switchboard Name" In the timer interval enter 10000 Note: 1000 = 1 sec Go to Tools and Startup. There is a Display/Form/Page: combo box. Enter...

Thanks Pat. I have an additional question. The reservoirs are five different tables (not my design) and I created a query including all five tables and added a expression that Sum the rainfall fields. My question is can I use your suggestion using the expression as the maximum value

Hello all I have 5 different reservoirs and keep track of the rainfall at all 5. I want to total all five together and then only show the maximum value on a yearly basis. But I also want to include the individual fields for the reservoirs in the record. I hope I'm making sense. DJ

Well sometimes the solution is so simple that its comical. Simply changed to Format(Date(),"m") instead of Format(Date(),"mmmm") Is my face red! It was because of the bound column. [This message has been edited by DJBummy (edited 12-04-2001).]

Hello All I have a form that I use to select a month and year for a query. I am using two seperate combo boxes. Month and Year. What I would like to do is have the current month and year display in the combo boxes whenever the form is opened. Tried setting the default value to...

Is the date range in the criteria field in the query?

I think you may just need to add "*"& after the LIKE in your code. D.J. [This message has been edited by DJBummy (edited 08-31-2001).] [This message has been edited by DJBummy (edited 08-31-2001).]

Hang in there. This is the place to come for answers. I learn something new every time I am on this forum. Good Luck D.J.

Is this what you are loking for? http://www.access-programmers.co.uk/ubb/Forum5/HTML/001701.html D.J.

You could run it directly from the query like this. Like "*" & [Enter A Selection] & "*"

Go to Tools Startup and in the Display Form/Page: box enter the name of your form. Hope this helps. D.J.

Or Try this one. <DateDiff("d",4,Now()) both will work D.J. [This message has been edited by DJBummy (edited 08-30-2001).] [This message has been edited by DJBummy (edited 08-30-2001).]

This is probably a stupid question. But I've been reading the threads on saving records. I always thought that once you have entered data into a field or moved to a new record that its added to the table. Why would there be a need to save a record? Am I way off on this? Or is this for some other...

Man I learn so much stuff on this forum its unbelievable. Thank you. D.J.

Try this: Between [From] And DateAdd("d",6,[From]) D.J.

Hey LQ Sorry about that. Try this sight. might help you out. http://www.mvps.org/access/strings/str0005.htm D.J.

Click on windows unhide. D.J.

Hi deno Sorry I'm not sure how this may be done. I would have to do some research first. Try this link it may be what you are looking for. http://www.access-programmers.co.uk/ubb/Forum5/HTML/000345.html Good luck D.J.

You can just put the greater than symbol into the Format property of the field: > D.J. [This message has been edited by DJBummy (edited 08-27-2001).]

=[Owner]&"'s " &[Color]&" "&[Sex]&" "&[Animal]&" name is " &[Pet's Name] The quotes are to put spaces between the fields. put in unbound text box. in control source. D.J. [This message has been edited by DJBummy (edited 08-27-2001).]