Search results

Ar maybe just to lock the field, cause using allowedit you wont be able to edit nothing in the form. If you just want to protect the date textbox try: Me.Textboxname.locked = True And thats it. Hope it'll come in handy.

Hi there, im designing a database for my office, and i'm lacking some information, i hope you can help me a little here. I have a report, which shows a list of products and their characteristics. In the product table theres an image field, to input the photographs or diagrams of each register...

Final Code. Just in case somebody gets to need this, ill post the code here, it works properly if i use the individual blocking instead of the allowedits. I hope this will be handy for someone. Boblarson, thanks a lot for everything, ill add to your rep. Private Sub Form_Current() If...

I found the source of all errors, the on current protocol doesnt work as i though it would, if a register is blocked, and i go to the next one, its blocked or unblocked state remains loaded from the last register. So then, something on the code causes the protocol to carry data from one register...

And does anyone know the instruccion for such action ?

I guess its getting hard to get what's wrong, yesterday i've been told access doesnt allow to block anything if my mouse has a field selected. Could that be the source of the mistake ? is there any visual basic command that would let me unselect any object before blocking ? ( that way ill be...

Problem solved, it wasnt exactly what i needed but doing so i found out my mistakes, thanks a lot, i'll add to your rep ^^.

It definitively locks now, thanks, but still ( I can't understand how can they be so many bugs in something as simple as this ) now theres a problem when one unblocks. If the register is saved as unblocked, when one accesses to that specific register, the textboxes are unblocked as they should...

Done, thanks! Now i've got another little inconvenient. having three headers, i need the report to start in a new page each time a new header is set. I know the property, but i have a problem using it, cause if i set my three headers that way, then my first page will contain just the first...

Mm.. I dont think i get it, im not so used to working in access. Could you explain it a little more ?

This is a hard one. Is it possible to operate over a single field of a subform modifying every register field in the same way ? Let say i have a form with a subform inside, lets also say my subform is a list of products in which we have certain fields including one named "unit price" Would it...

Hi there, I'll try to make myself clear: I have a report with 3 headers. Purchase Order Number > Product Floor > Product Area The structure of my report goes like this: PURCHASE ORDER header Purchase Order Data header Floor Header Area Header ( This one also holds inside the...

But the program still blocks every registry when i open them, it does not discriminate if they have been previously blocked or not. I know how to play with the current stuff to fix it. but wont it show me the same mistake i had when i sent it to you ? I've just tested my modification. This is...

What's that me.dirty field ? This program would block any executed register, i mean ( form current executes on every opened register ), what we were looking for was for it to keep a record on blocked and unblocked registers and only showed as blocked previously blocked registers. thats why we...

The file is eddited in the previous reply. I hope it's enough to foind the problem.

I just cant resume my database enough to make it fit here. I'll make you an example. Here it Goes

Here Here it is. At least i think so. Sorry but it's in spanish. Hang on, ill have to take away some info for it to fit.

Im working in access 07, is there any problem with that ? I mean, i cant give you a mdb file only a .accdb file. I cant save it as an old database cause it includes new features.

They are in the main form. But i have a subform too. Anyhow the subform blocks itself just fine if i lock them manualy from the design view. if the code should have something else to block the subform, please let me know.

It's all properly working! Except for a tiny little detail. Me.AllowEdits = False Me.AllowDeletions = False Me.AllowAdditions = True This commands applied to my form doesnt block my text boxes nor my comboboxes, i can keep editing them as i please... i dont know what could be causing...