Search results

I've got a major problem that I sincerely hope someone can help. I need to show all livestock on report and if a particular cow has an offspring, then it needs to show below that cow. My query recordsource is based on LivestockID. In addition to the LivestockID, there is a DamID field which...

What's the preferred way to loop through a recordset to get the record count? All this move next, do until, EOF etc. get's confusing. Your thoughts is greatly appreciated.

Bob: Thanks for your idea.

I spent considerable time working on a form for an individual with his db and need to lock it down so that he or someone else can't change it. I know that if I can find a way through code, it will not be fool proof, but better than nothing. Your thoughts are greatly appreciated.

I need to prevent design changes to a particular form without using ULS or mde. I am hoping someone has some code to accomplish this. Thanks in advance

Stopher: I sure do appreciate your help and also the explaination. Just what I needed.

I'm having problems with Dcount when used in report group footer. Report is based on query and grouped by 'Location' dislayed by txtLocation control. I need to use DCount to bring up the total number in the group location but from tblMain and not the query that report is using. How do you...

Currently I have a crosstab query with row totals. Is it possible to also display, in datasheet (not a report) column totals? Any help on this is greatly appreciated.

I have a form with a continuous subform with bound checkboxes for selecting records. Once the record/s are selected I wish to update a table with the selection from a combo box. What steps need to be taken? Thanks in advance.