Search results

All the references I've read concerning "Dynamic" Reports show, by using crosstab queries, how to control columns of data. Is it possible to create dynamic rows. The reason I ask is that I am trying to produce a report detailing records of product returns, showing quantity and type of product...

Can anyone please help me? Users enter a date on a form control [txtas400date] - a date which is usually within the previous 7 days of the current date. I want to prompt the user to check the date entered if it is older than the 7 days but allow entry if the user confirms. I also want to prevent...

I hope the experts can help me. I have a main form with a text box control [txtDiscrepancy] formatted as a Yes/No field with a default value set to No. On a subform I enter details of any shipment discrepancies using 3 textboxes - [txtItemCode] - [txtQtyAdvised] - [txtQtyReceived]. I have tried...

I am trying to populate a form control Field1 ["DailyHireRate"], by looking up a value from a table ["Rates"], based on the date specified in another control Field2 ["ChargeDate"] on the same form. Form = "Transactions" Field1 = "DailyHireRate" - Format: General Number Control Source...