Search results

Then on his own head be it! I think the problem with the current system is that orders are locked once an invoice is created. We're going to change that so that he shouldn't have to delete. We're now also going to have a cancel facility which will appease the tax man. My man is safe from jail.

i do that when invoice number is created. there after it's held with/linked to the original order

It's not really like a true ordering system. The code originally (not written by me) was designed to mimic life. It's a 1 man band business. He goes to a shop and leaves 30 x, 50 y, 23 z and many more When he comes back there are 23 x, 10 y and 1z. So he produces a delivery not and ultimately...

rational is tax office wants it why delete. you print off the invoice and the customer says you have my name wrong i want another report.. currently the system doesn't allow editing once the invoice has been produced. so before (when there was no real need for invoice numbers) the order was...

yeah i get that. i'm working for a man band living on a small group of islands. he's not going to steal from himself. the tax man needs to see invoice numbers with no breaks

No if you reprint you pick up the old number.

I've managed to use record sets to get this working but indications suggest I shouldn't be using another table to store latest invoice number. I'm open to suggestions to what should be in it's place. I like GPGeorge's suggestion but I've posted another issue that it may not cover.

Yes I have that covered. 1. has the order an invoice number 2. no then create 3 yes then use that

I've not looked at a piece of code for over 6 years so I didn't remember , think or even realise that Max(invoice number) was a thing but that seems a great idea. I do have a complication for that as the invoice number is effectively RRnnnn where RR is the region code and nnnn is a unique 4...

1. I used this and got some sort of error and when I was investigating I read, in more than 1 place, not to use it. This one https://nolongerset.com/avoid-docmd-runsql/ said Avoid DoCmd.RunSQL in Microsoft Access. What and why is it a bad idea? 2. No, it's stored on the order itself. When the...

The report is the invoice. The invoice number is related to the order. I need a unique invoice number per order. Once the invoice is created I need to use the next number in sequence and then update that number for the next one to be created,

Not sure if this is what I need but I'll take a look

I've been dragged out of retirement to do a 5 minute job. Unfortunately after 6 years I've forgotten more than I knew. So bear with me if I use the wrong names for things but.... I have a form that is bound to some query. It has sub forms bound to different queries. The form displays list of...

No but this was a while ago and I must have got around his problem. Still interested in doing it properly though so I'll take a look.

Definitely needs a bit more of investigation. One down side is you need an Internet connection. In this day and age shouldn't be a problem but she lives on an island of the North West cost of Africa! Upside is you can get access wherever you are. Thanks again for the heads up.

Yes I went down the VPS route as well. I think self managed servers is the default and probably in reality you don't have to do anything. I'm trying to het further info from them

I've just found out that OpenOffice has a successor called LibreOffice. Anyone with any experience with Base in that or is it as flaky as he Open Office one?

Ah ok. It's a real simple system but I'm going to need a few lines of code so that's a bit of a show stopper. I don't mind the learning about it. I'm more or less retired but just do a bit here and there on request and it really isn't about the money! That said if she wants to buy me a Mac so I...

Just had a look at this and and the low prices refer to self managed servers. I don't know exactly what that means but if that means we're responsible for firefighting, upgrades in OS etc then it's probably a no go unless it doesn't need managing for what we want. Also it seems that the cheap...

An access licence, if my memory serves me right, allows up to 5 users. There's only 3/4 of them and in the main I'd be surprised if more than 1 accesses at anyone time. Besides it's been shelved because of the panyouknowwhat.