Search results for query: *

I have a form called store_receipt. It contains a subform: store_receipt_item on which there are the following fields: order_id - Text Child/Master linked field row_id - Text sku - Text quantity - Number adjusted_price - Number What I need is for the row_id field to start numbering from 0...

As always the answer was as straightforward as they come. It looks like my logic was okay, it was just my syntax that was wrong. That's the trouble when you rely on the Query Window to do the work for you. Much appreciated.

I have been struggling with my first union query. From the look of it, what I am trying to do isn’t straightforward. I have a form [Title Page] which contains a combo box Assistant. This lists the names of all the shop assistants who worked during a certain period. The list is extracted from...

Much appreciated, Mark. I'm only just getting into working between applications - all my experience has been with Access - so I sometimes need a push. The code wouldn't work while oXLApp wasn't visible but I just tagged it on the end after the application was open - good enough for government...

I have an Access form that I need to export to Excel; I am using Office 2000. This I can do. What I want, is to reformat the spreadsheet before e-mailing it onto its intended recepients. Two lines of code simply refuse to work: ActiveWindow.DisplayZeros = False...