Recent content by Rokhi

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