Search results

I have received a zip file in Excel with 85,000 entries and when I open the file it exceeds MS Excel's capacity. I have tried importing the zip file into access by using a macro but I keep getting a message '...cannot open the file, it is already open by another user ....' If I unzip the file...

I have written a small update query which will not work. I have one of the fields named CODE. Is CODE acceptable for a field name? Terry

I have a series of invoices in a table which are up to 35000 at present. I would like to re-start using invoice numbers which start at 40,000. I have done this before but can't remember how. Any ideas.

I have a form and one field has a drop down box with several fields in it. I can only currently get the drop down box to save one field value. Is it possible to get 2 or more fields to be saved when I select from the drop down box? If so, how can this be done and is there a way to be selective...

I have a report which lists 'Invoice Dates' and also lists how old the Invoice is by 'number of days'. I need to total the 'Invoice Values' based on the 'Number of Days' the invoice is overdue. i.e. Total all invoices between 0 & 60 days old. The value to sit in Report Footer. Simple...

I have a report which is a statement of outstanding invoices and I would like to sum the oustanding totals by period overdue i.e. 30 days, 60 days etc. Any ideas?