Search results

Thanks Alexei you are bang on, worked perfectly. Thank you for your help Regards Bagel

Hi all I am sorry if this has been asked already a million times already but I could not find any relavant information in the time I had. I have a requery / refresh problem. I have a Customers form showing all customers, I also have a NewCustomer form for adding new customers. On the...

Thanks Rich and GodofHell for your replies. Mr/Mrs hell I have tried what you have suggested and yes it works well but I still have the same problem as before being that if I set the quantity.enabled then it does this for all Quantity controls on the continuous report, not just the current...

I am having trouble with a continuous form setting Enabled to False in the current record only. I have tried code in the OnCurrent of the form and OnOpen, examples like If Me.NewRecord then Me!Quantity.Enabled = False ..... also If Me.NewRecord = True then 'if this makes any difference...

Well unfortunatly I am still getting the run time error 3021 - no current record, when I debug it even shows a record number! it seams quite confused, or is that me? Any ideas?

Many thanks Thanks Cosmos75, I will change it all now, thank god for find/replace. I shall take note of Mile-o-Philes warning, luckily it is the only domenuitem statement I have.

Hi Again I have been using the following code to delete records from my database for some time but for some reason this code now gives me the runtime error 3021 - no current record. It may be wishful thinking but I think it may be a microsoft issue because if I create a new form and copy/paste...

Hi All Before we start, I am an amateur so please keep it simple. I have a report to print customer address labels which works well. I have a pop-up box to ask how many cartons you will be sending, this is relative to the amount of labels to print but most of all relative to the amount of...

Hi Pat I have tried what you suggested but this did not seam to work, is there something else I need to do?

Thanks llkhoutx, your a champion. I have hours on the net looking for solutions. Thanks again Regards Bagel

Thank you llkhoutx How would the queery basically read? Regards Bagel

I am a novice at access so please explain in the easiest way possible if possible. I have a Table called "Citys" I have a form with two combo boxes on it, Both with the same data "CityName" I would like to be able to limit the data on my report so that only the citys between the two combo...

THANKS AGAIN FOR THE REPLY I DONT HAVE A cmdClose_OnClick EVENT, MAYBE THIS IS MY PROBLEM. I ASSUMED THAT BECAUSE THE CLOSE BUTTON IS BUILT IN RATHER THAN ME CREATING ONE, THERE WOULD NOT BE SUCH AN OPTION, JUST THE ONCLOSE FOR THE FORM. WHAT DO YOU SUGGEST? BAGEL

HI CALVIN THANKS FOR THE REPLY I HAVE TRIED YOUR SUGGESTION, AS YOU MAY HAVE GUESSED I AM BUT AN AMATEUR (FRUSTRATED) BUT HAVE HAD NO SUCCESS. ON PRESSING THE CLOSE BUTTON(BUILT IN) I STILL RECIEVE THE SAME MESSAGE "BLAH BLAH ERRORS ENCOUNTED WHILE SAVING", IS THERE NO WAY OF CANCELLING THE...

CAN SOMEONE PLEASE HELP ME? I HAVE A FORM ON WHICH I HAVE A FIELD THAT MUST HAVE DATA ENTERED INTO IT. TO CLOSE THE FORM THE USER MUST CLICK THE BUILT IN CLOSE BUTTON. IF THERE IS NO DATA ENTERED INTO THE FIELD THEY ARE ASKED IF THEY WOULD LIKE TO CANCEL OR RETURN TO THE FORM AND ENTER DATA...