Search results

As per title I'm producing a fairly simple report but the width of the controls looks pretty random. Fields with few characters seem to have large widths and others are truncated as the width is far too small. I know I can go in and change the control dimensions but it seems a bit painful. Am I...

thanks I'll take a look

I am looking at an access database that uses to and from controls on the main form to control what is displayed in other forms and reports etc. I there an easy way to see which queries uses these controls as their criteria. So I've created a query using the following criteria...

Thanks to everyone for the help. Appreciate it

i've got something like that I've got strParentForm= Me.Parent.Name and then i use If Forms(strParentForm)![strtemplate] <> "Sale" Then

I've inherited an access database. There is at least one instance where a subform is used on 2 different forms. Let's call them form1 and form2. The problem is that code in an event procedure (after update) assumes that the form is form1. The problem is that this event procedure is now...

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.