Recent content by mike wild

I have a report listing members of a social group. The report is split between Current and Past Members. I have a yes/no check box on the main form based on weather each member is a current memebr or not. This is recorded in a table called "data" within the column called "member". I have a...

All fixed. i just selected "no" to Allow Additions in the forms propities. There are 200 records no more and no less. therefore it is ideal.

When i press the page down key to cycle through the record set it often ends up past the last record, and i get an error 3314 about the id being set to true. I have tried the following code on the forms "before update" and in the ID fields "before and after update" with no luck. Private Sub...

I need help with this one. What i am trying to achieve is: Bag 1 [4] Bag 2 [7] Bag 3 [7] bag 4 [10] Bag 5 [6] bag 6 [3] bag 7 [5] Bag 8 [2] Column one contains "bag 1", "bag 2" etc. It is text, and is always the same and in that order. Column two (with the []) contains data taken form a...

It works now. Thank you all.

ghudson, i tried that earlier and it just closes the form you've just opened. which is why i was tring to record the name of the current open form in a dim statement, so that i'll be able to close it whneever.

yes, but any one of the 9 forms could be open.

I am starting a new project. I have 9 forms and any ONE form could be open. I have 9 option buttons which opens the forms. When the user clicks option button one, forms one opens but i need to close the other open form. How do i to declare (dim) the current open form? so that i can open the...

got it poped it in the event timer to check every 3 minutes. thank you

I placed in the the forms onload property, but you can still minimize the application.

That is correct for the access form window but i mean the application window.

I'm looking for a way to keep a form maximized even if the user presses the minimize or maximized buttons in the top right hand corner. Or even gray out the min and max buttons altogether. I have code in place that grays out the close button but not the min or max. Any help would be great!

What if there is no relationship?

the share the id field

I have a form called card and it is bound to a table called cardtable. On the form there are several unbound fields (one is called "winselect") that i would like to be saved (or bound) to another table called winner. Is this possable? thanks