Recent content by mikeTTI

I saw that and fixed it. In the revised expession I am refering to the control/frame that contains the sub form on the main form. So still something wrong ... ...

Thank you Galaxiom for pointing out the error in my expression. I have corrected this, but it still isn't working. I am still getting the 2001 error code.

Thank you everyone for your help, but I am still stuck. I have a subform which contains two fields [Grower] and [Farm]. The subform is based on a table [...Details] that contains harvest records. [Grower] and [Farm] are both lookup field based on the tables [...Contacts] and [...Farms]...

I have a subform. I need to use a DLookUp function to set the default value of [Grower] on the subform, based on the value of [Farm] in the same record (but earlier in the datasheet). Both farm and grower value are found in Table. The idea is that the suer types in a farm number and this sets...

This is some code I was working on a while ago, and posted on this Forum:- Dim MyDate As Date MyDate = Me![DateFrom] DoCmd.OpenForm "LevyReportDialog", acDesign Me.DateFrom.DefaultValue = MyDate 'MsgBox MyDate DoCmd.Close acForm, "LevyReportDialog", acSaveYes It is supposed to save the...

No code. It is set in the Default Value property of the Table tblLevyReceiptsHeader.

I have realised I do in fact need to use a type 2 join to get the data I want. (All records from tblContacts and only those records from tblLevyReceiptsHeader where the joined fields are equal) Thanks to all the help I have received from this forum by trial and error and removing fields...

Hi Wayne, Just had a look at this. Can a Yes/No filed be null and if so how do I tell it is null? Cheers Mike

Hi Bob, Thanks for your help. Interestingly I tried this. It still brings up the error, even when those IIF expressions are removed from the query. This suggests it is not the conditions that are problematic, yet the query works for one of the three values that relate to those...

I have a query: SELECT tblContacts.Name, tblContacts.[Mussel Processor], tblContacts.[Salmon Processor], tblContacts.[Oyster Processor], tblLevyReceiptsHeader.AutoID, tblLevyReceiptsHeader.Paid, tblLevyReceiptsHeader.DateAdded FROM tblContacts LEFT JOIN tblLevyReceiptsHeader ON...

I have a cross_tab query, that users print on a monthly basis. The user selects whether they want to include data for one or all of three products. So the query could show data for example for Salmon only. I need to be able to show on the printed query, what products it is displaying for. At...

Thansk Bob

Thanks Bob, Do you still think I should use a variable to store the last date used? Presumably once I am in design veiw the textbox will effectively be blank?

I have a form I use as a dialog box to set reporting criteria. There is an unbound text box [DateFrom] on the form. When/before the form is closed I would like to set the default value of this text box to its current value. (there is currently no default value assigned). I have tried the...

Hi, I'm not sure which Form topic this post should go under ... I have an Access Database which contains contact information including email addresses in a number of tables. Each table is a reference group of individuals interested in a particular topic and has three fields (contactID, name...