Search results

I really don't want to do that, but only because I'll take the win & run with it without understanding the decisions made & why. I'd rather go a little slower & understand why decisions were made so I don't have to come back and ask again next time. I have at least 3 more to convert after this one.

Yes, thats more or less exactly what this tracks. The rest of it that I haven't mentioned yet is basically MI from that data. Tracking things like all the jobs with an invoice outstanding or all the jobs currently being quoted. Which is all stuff I know it can do, but I haven't looked at yet...

theres a scroll bar on the right... there are 25 Invoices. being able to start with 1 and add them in would be better though.

This is a screenshot of the current interface in Excel (As above, I'd like to keep the access version as close to this as I can) In invoice 1 I've turned on CIS & Part Payment to show the hidden elements. This is the main form for inputting a new job & managing an existing one, which is about...

But I assumed (maybe I was wrong) that if I used multiple tables, a main 1 to hold job number info (client site address etc) and 1 for each of the 25 Invoices that would help to overcome the 255 limit. hence my original question. The Invoice tables would each be about 25 fields. (25 fields x 25...

Sorry for going silent! It was a very busy weekend & Yesterday was just as crazy. Thank you to everyone for all the suggestions & help. I have links with some reading to do here & a database to download & explore. The spreadsheet has been evolved & honed over 5 years to something that works...

Hi, I'm very new to vba in Access but have dabbled in Excel for some time. I'm in Access 2016 (through office 365). I have a large slow spreadsheet over multiple sheets with lots of VBA which we use to manage our jobs & I'm remaking it in access. This section is a main form which will have...