Search results

Thanks for the advice, I'll definitely be moving vat calc and suggested fields etc onto the lines instead of the header, the standing data vat table is something i hadn't thought of either. I do have the customer order number field within the table, but not all fields are showing in the current...

Hi, I think its standard practise to have the header and details tables with a relationship. There are no fields that store any data in the stage-1 (header) table, its fields on the form But yes my original question was whether it was better for the invoice number or autonumber be the pk and...

will do, thanks for the advice everyone

oh so even store the value not just the % ? Yes all the actual accounting is Sage but if there is a proper way to do it then i like to try and make the database follow that as much a possible. So i would actually create a calculated field in the table of the line total and vat % ?

After reading quite a bit it seems the Vat per line needs to be displayed if there is different rates within the invoice. Im 99.99% we always use the same rate per invoice but i'll move VAT rate to "Stage-2" table so its stored correctly, have the subtotal calculated and also put a dropdown...

The address field on there is actually a lookup to a separate address table. I didnt know that about VAT, i used our companies existing invoices as a template and there is no vat per line item. Currently our invoices are excel generated and then entered on sage, so i assume it is stored by...

Of course, thats a good idea, I guess i could also index the INV-1-REF (invoice no) with no duplicates

Hi there, I have a draft form for invoice creation, (i know there shouldnt be '-' in names but this was made a while ago) Stage-1 main invoice Stage-2 product details/costs etc At the moment the autonumbers are the PK's but INV-1-Ref is the actual invoice number My question is, is there some...

I managed to copy the "ListReporter" to make "ListReporterAdd" I amended the If statements under "If FileExists" section to exit the sub if the file does not exist, So now i have two functions i can call: 1- To export, create and format to the new excel file 2- To export, create and format to...

you know i bet you're absolutely right, now that you mention it i did have all fields in the query "*" and then added one again to filter. IT was just coincidence that as i changed the field name i also reduced the query columns which would have removed the duplicate field

Its worked Minty! I was getting a "Cannot define field more than once Error[3191] After googling a bit it turned out it was the underscore in my field names... which sadly i have a lot of but just by simply changing the field name in the query has sorted it. When i get the chance I'm going...

Thanks Minty, i will give it another try in the morning

Sorry for the, i've just had the chance to try and run it. Im getting variable not defined on Applicationcurrent.Path" so changed to Application.CurrentProject.path Sub not defined on ISFileOpen, FileExists etc. I tried just cutting it out to see if the export could work but no luck. As i'm...

thats brilliant thanks, im going to give it a whirl this eve

Hi, Thanks for this, I've been googling but i have no idea how to call this correctly. But i plan to run through those tutorials so hopefully it will help because i would love to be able to read the code you posted properly

Hi everyone, Im currently looking into exporting a simple query to excel (weekly orders status) Im hoping for: Export on click custom filename Open & format as table Close and Save maybe open MS outlook and attach to an email Im following a Youtube tutorial by "Access Jitsu" using the...

Its going to take me a few days to understand these as I cant read them, but thanks I will definitely try and figure them out and utilize them

its just the tip of the iceberg for me haha

haha I can only imagine what you guys must think sometimes when you see what and how people like me try to do things. I am looking for some good starter course to get into, maybe udemy or something I managed to get it working by adding a cancelevent at the very bottom of everything and using a...

I have made these changes and the it seems fine now. the only problem is the code continues as the error message as if it was ok but I think that is due to other statements I have further down which I guess aren't reliant on the results of this this statement.. I will have a look at the...