Search results

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...

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...

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...

I would appreciate some comment on a solution I have come up with, which is described below. I had a dialog form on which users couldchoose 1 of 12 queries to open. Users justifiably found a list of 12 queries confusing, so I now have 4 option groups instead. Every option on the dialog form...

I have a DLookUp Expression =DLookUp("Rate","tblLevyRates","[LevyYear]= " & [LevyYear] & " And [Species]= '" & [Species] & "'") I use this expression in a form and it works fine. I it as 'Rate:' in select query "qryLevyPayAll" and it works fine: - qryLevyPayAll SELECT...

I am trying to use an IIF function in each of three yes/no fields in a query to select records where one of the yes/no fields (as determined by a dialog form) = true, regardless of the value of the other two fields. Each record can contain any combination of Trues and Falses in these three...

I have a subform that is dispalyed as a datasheet. I am trying to make two combo boxes on the datasheet use the value of the previous record as their DefaultValue for new records. To do this I have created a functions and LostFocus event for each combo box: - This is working for one combo...

I have created the following function in a Standard Module: - (At this stage I am just trying to call it from a calculated text box on a form. Later I will add arguments to feed into the RoundDown function). However if I set the data source of a text box on a form to =RndDwnII() I just...

Hi All, I have a calculated text box that displays a currency value to 2 decimal places. I need to make this truncate (e.g. $87.679 = $87.67) Does anyone know how? The only thing I can think of is to -0.005 from the text box result. This would always make it round down, which acheives the...

Hopefully someone can answer this question for me: - Is it possible to sum a calculated text box in a subform in datasheet veiw by using the Sum function in another calculated text box in the footer of that form? The text box I wnmat to sum multiplies the result of a DLookUp function in...

=DLookUp("Rate","tblLevyRates",[tblLevyRates]![LevyYear]=[LevyYear] And [tblLevyRates]![Species]=[Species]) The above is the control source for a textbox on a subform. I just cannot get this to work. I have tried mimicing all the example I could find in the various threads, but no luck with...

I have a form that is used to enter/display industry levy payments. It has a main section and two subforms, both of which are datasheets. subform1 is based on a table and shows individual payment details. subfrom2 is based on a query that calculates what the amount for the payments by lookign...

I have a cross tab query for which I want to display the dayes in mmm-yy format. I am grappling with the problem that this is essentially a string, so gets sorted alphanumerically. Having read around related forums I have tried basing the XTab on a select query, which is sorted by the...