Recent content by SteveSchapel

Haha! Changed record source - I never thought of that possibility. Mystery solved - what a relief! :-)

Hi Micron As I understand the problem here, Corsica has a query with a calculated field. In the query datasheet, the calculated field works correctly. However, in a form with this query as the record source, a textbox which is bound to the calculated field shows #Name. Something peculiar is...

Good luck. This is indeed a puzzling problem, and as Colin says, being able to see a cut-down copy of the problem application would help, so it's a shame that's not possible. It will be good to get it sorted.

Corsica Maybe you could start from scratch to build a copy of the problem form in the live database, and see if that works.

I think you will need to provide a bit more detailed explanation in order to get good advice! But if I understand your quesion, it will be something like this... If Me.NameOfSubform!Field = "active" Then DoCmd.OpenReport "YourReport" End If

Hi Carlo That's cool. However, I am pretty sure that this will only be a useful approach if the Record Source of the subform is the table itself - which in my experience is often not the case.

Ljmellor, Put an unbound textbox on the main form. In its Control Source, enter the equivalent of this: =[NameOfSubform]![NameOfTotalsBoxOnSubform]

http://facets.datamanagementsolutions.biz/2009/02/access-security.html :)

MaGemme, If there is a separate search box and command button on each subform, then as far as I can see, the only code you would need is: Private Sub Search_Click() Me.Account_number.SetFocus DoCmd.FindRecord Me!SearchID End Sub

Mel, The simple answer to your question (thanks for the very clear explanation!) is that you can enter like this in the Criteria of the query: [Forms]![searchCustomerForm]![CustomerRef] However, I think your query is wrong. Create your query in Design View, and use Joins to link the tables...

MaGemme, So do you mean that you have the control where you enter the search criteria is on the main form? And this control is named SearchID? And this is supposed to find the matching result in the Account Number field in a subform? And the name of the subform is frmRequests? Just...

DStevens, Just a hint for the future... this is always a bad idea. People answering your questions are unable to directly see what you are doing, and are therefore hungry for every little hint and nuance that might help us to understand your application. Showing actual field and object...

DStevens, 1. Showing is often the best way of explaining! Good for you. 2. 'Name' is a Reserved Word (i.e. has a special meaning) in Access, and as such should not be used as the name of a field or control. Recommend to change this. 3. Try it like this: SELECT TABLE1.YourNameField...

Bosve, Up by 2mm!? That's not what you said originally. Originally you said down by 1cm. So has it changed? If you have the Row Spacing set to 0, and the height of the labels is 7.5cm, and there's no margin between the physical labels, then the height of the Detail section of the report...

Bosve, In design view of the report, go to File|Page Setup menu. Under the 'Columns' tab, notice that you have a Row Spacing setting of 1,6 cm. If you can change that to 0, your labels will come differently. Does that help?