Search results

Sorry Brian, my bad, I missed your sarcasm :o

:eek: Why are you allowing users to put your form in design view :confused: Perhaps this link will help with your other question.

Thanks stopher, much neater. I knew there'd be a more economic way to do that :D

Ill founded rumours I'm sure.

When I was a kid it was alleged that the local Chinese Take Away, used to turn them (cats) into Dim Sims :eek:

Sorry I'm sitting in an Airport lounge at the moment, but I think the sample here may do the sort of thing you are after. If not, it's going to be a good 24 hours before I can find anything else :o

Welcome to the forum. You could have some code in the Before Update Event of Field B, along the line of; 'Check if Field B hold a Zero Value If Me.FieldB = 0 Then Exit Sub End If 'Check if both fields are even If Int(Me.FieldA/2) - Me.FieldA/2 = 0 And Int(Me.FieldB/2) - Me.FieldB/2 = 0...

You'll need to use sub tables linked to the parent table via it's unique ID. This you would do using a form bound to your master (day record) and then a sub Form(s) for your sub records.

Welcome to the forum. Perhaps a Multi Select list box will do what you are after.

Yeh, kittens will mess you up real good, if you get on the wrong side of them ;)

Brian did you not see my tongue firmly in cheek back there :eek:

You may get some inspiration from one of the data models available here, check section 8. Restaurants.

But those Hello Kitty M16's are so cute. How could they possibly hurt anyone :banghead:

The sample posted in this thread may help you to achieve your goal.

Perhaps the sample here will give you some pointers.

Assuming your DB is closed down at the end of each day, you could test the date in the On Load event of your Menu form, and fire the code from there.

I'm pretty sure I see what you are trying to do. I'm not currently on a machine with Access, so I can't test. However, if you the maximum size of your groups is going to be a finite number, I would probably create a table with the records 1 to Your Max Group Size, and use that to populate our...

I suspect that you should be able to adapt the principals demonstrated in the sample here. I wont be back on a machine with Access for about another week. However I think you should be able to treat a combo box in a similar manner as the option groups are treated in the sample.

It sounds as if you have not got a reference correct some where in your code. Or you have not change the name of one of the controls on the form to match either the code or the query.

Sound's like you are looking for a cascading combo box set.