When printing a report from a form, is there anyway to by pass the window that pops up and asks if you want to print (paper size, pages, quality)? That way it is just one click.
When I click a button on my [Student] form it opens the [Family] form. I created a find button, but it can't find anything when I use it. Now, if I open the [Family] form directly then the find button works like a charm. What's wrong?
How can I create a fake autonumber in a query? I have a set of data that have their own individual number but I would like to sort them by date and then run a dsum() based on the FAKE autonumber.
-Alex
Is there a way I can grab the previous record's value without using dlookup? I am trying to create a running total in a datasheet view. e.g.
Date Credit Debit Run. Tot.
6/1/06 $25 $0 $25
6/4/06 $30 $0 $55
6/9/06 $0...
In my database I have all my clients information in the [Main] form and all their transactions / debits / etc. in a subform [Transactions] in datasheet view. My question is how can I have the subform automatically scroll down to the last record (or to a new record) so the user doesn't have to...