Search results

Which group has the interval of 3 set on month? the numeric month field or the date field ? If the date field you are sorting by is a full date, that may be upsetting things. If you need to subsort by day, return a separate day field too but still do the 3 record interval on the numeric month...

An alternative might be to pass in the year and month as numbers in the source query, then sort on the numbers 'year' and 'month', and you should be able to group on the number 'month' in group intervals of 3. I havn't tried it, but it might be worth a crack.

The group interval property splits the year into months starting at 1, so a group interval of 3 used on a date/time field grouped on month would give you Jan/Feb/Mar and Apr/May/Jun etc. starting at feb will give you feb/mar then apr/may/jun. Similar concept to if you grouped a date/time field...

I am trying to create a single method that can manipulate whatever table is presented to it in different ways depending on some passed parameters. Table1 may have fields data1 and data2, and table2 may have fields otherdata1, otherdata2 and otherdata3 and so on. If the method is dealing with...

fldVarString does not contain direct references to the data fields, but a string containing the references. ie - not FldVarString = Nz(rst1![Data1]) & val(rst1!Data2]) but FldVarString = "Nz(rst1![Data1]) & val(rst1!Data2])" In which case, if I try to assign the value fldVarReturnVal =...

Keep the hidden row count textbox text1 set to =1, with running total set as before. Put a textbox txtTotal with no label in position under your summing column (txtMthlyTotal) with a height of 0 and cangrow = true, right aligned with txtMthlyTotal Private Sub Detail_Format(Cancel As Integer...

Hey, thanks for the advice The statements were cramped in the examples to save space in the post The iif() is used because I'm storing the calculation in a single string variable, that's the point. I want to be able to call a stored line of query logic from a lookup and use it in the...

Try putting a number of images on your form in the pattern you want, with empty 'picture' properties, then use custom navigation buttons to move thru the recordset, picking up the image addresses from the required number of records each move, and populating the images' 'picture' properties...

could you copy it and paste it in your post?

Is the compile error at the same place? Perhaps you could post the line of code giving you the error

I Assume you are using a relational model and bound forms and the parent form is bound to the parent record set, and the child form bound to the child record set. If so, there should be a Key relationship - say ParentURN being a unique key in the parent data set, and ParentURN being a foreign...

How are the numbers in the list file related to the records in the MDB? Why are they separate to the MDB? How are they generated and how often? eg on the fly? static?

If you copy that line of code and paste it in the immediate window with the '?' in front, you will see the problem. ?"Update Table1 LEFT JOIN Table2 ON Table1.Test = Table2.Test SET Table1.Update1 = Table2.Update1" & _ "Table1.Update2 = Table2.Update2" & _ "Table1.Update3 = Table2.Update3" &...

Use the form_current event and set the form's allowdeletions property depending on conditions in the current record. e.g. Me.AllowDeletions = Mid(Nz(text1), 3, 1) = "d"

Sorry, I misunderstood. To get your report to break on every third record: Put a hidden text box in the detail (Text1 for this example) with its control source set to '=1' and running sum set to 'over all' (no quotes). Put a pagebreak under the detail controls (pagebreak1 for example) In the...

I think you may need to consider a different approach. This looks overly complicated Can you tell me what your source data looks like and what the broad goal is?

Here are some code samples showing how to pass the parameters in an array. Function SumThemUp(varValues As Variant) As Variant ' Find the sum of the values passed in. Dim varItem As Variant Dim varSum As Variant varSum = 0 If IsArray(varValues) Then For Each...

You could display a custom input box in the button click event that opens the query. This form could then be of any shape/size or color that you want , and could conceivably allow input of both begin and end dates, have a calender control etc.. The form would take the value input, do any...

Pass them in an array. Browse thru the code in this Access Howto MDB courtesy of Ken Getz & Paul Litwin. It should give you some ideas

Hi The problem VBA - DAO How do I extract a value from a string containing field names Data: rst1!data1 = "ABC" rst1!data2 = "000123000" query Fields sourced from a lookup: FldVarString = "Nz(rst1![Data1]) & mid(rst1!Data2],3,3)" (or any of a number of combinations) I want another...