Search results

I have resolved the issue by importing the file from inside the zip folder as a csv file.

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

Fixed it! Don't know how, but it is working. Terry

Here is the code, basically updated a field. Private Sub Code_AfterUpdate() Me.AccountName = Me.Code.Column (1) End Sub

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

Thanks for the advice Mr B. I will start looking at learning some VBA code. I have managed to achieve the required result by creating an update query to take the 39999 value from a secondary table. Nevertheless this is obviously the wrong choice as stated in your comments. Can you advise on...

Thanks for all your advice and particularly about the autonumber which I am currently relying on to to increment by one each invoice. I will have a look at the DMax option although I am not a VBA programmer and may have to revert back. Thanks again, Terry

Thanks for all your advice and particularly about the autonumber which I am currently relying on to to increment by one each invoice. I will have a look at the DMax option although I am not a VBA programmer and may have to reve3rt back. Thanks again, Terry

I don't see how this resolves the problem. The current invoice numbers work on an autonumber and have reached 35,000. I want the next invoices to start at 40,000 and increment by one each time from this point. 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.

Many thanks for that Smeghead, I have got it up and running. Terry

Hi, I have the table field as a Combo. I am not sure how you set it to allow multiple values in the properties box. I am viewing the table field in a form and the form will only save one field into the table, whereas I would like to include other fields.

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

Thank you, Problem solved! Terry

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?