Search results

I dont get it. I should set up that code both on after update event and on current event ? Was the button code ok ?

That one should block registries if one of their registries is completed. Could i add a yes/no field to my table called "blocked" and use a command or something to change its value blocking or not the order im seeing ? If Me.blocked = No Then Me.AllowEdits = True Me.AllowAdditions =...

I have a form with a subform within. My need is to avoid already finished registries from being modified later. But when i turn the property off, this prevents my subform to be edited not only in older registries but in new ones as well. How should i correct this ?

Adding tables to handle floor would mean losing the practicity of it all, anyhow, i've read that i can handle my last character in my code by asigning "=1" to my text field as control and a add property. As for the remaining floor number and area number, maybe i could assing similiar text boxes...

I've been requested to design a tricky report. I'll try to be clear on this, The report fields are the following: Purchase Order, Date, Floor, Room, Item, Product, Product Description, Photograph. The Report is ordered by the Purchase Field, Date Field, Floor Field, Room Field. ( In...

Ill try to explain it Again. http://img153.imageshack.us/img153/115/screenshotxo2.jpg [ I had posted two doubts, by the first one i have already figured out by myself. ] This is the screenshot of my form. In in, theres a subform with the name of some items the user is wanting to buy. the...

It works just fine now, thanks! I could manage to understand the code as well with what you've told me. One last thing though, about the second question. the dashed correct part of my problem, but i still need the last number to be showed in its five numbers, even though they might be zero.

Im needing to program a couple of modules to make calculations with subforms cells. The first one its easy, i need one of the subforms columns to be automatically equal to be equal to the product of another two columns. Just as one would normally do in excel =(A1*A2) Im not sure where i should...

It works ok, just what i needed. But there are some details i need to correct. - When i end up filling a form, and use the arrow to start the next, an error comes up, telling me im doing an invalid operacion with a null value. I supose this is because the autonumerical field is not...

Hi there, Lest get straight to the problem. I've bumped myself into a slight inconvenient trying to design a simple vb module which would autofill a serial number into a textbox on a form when i click over it. The structure of my serial number is MM-AA-XXXXX ( When MM is the current month, AA...

Nah, that was exactly what i was thinking. --- Well, this post was never completed, still you helped me out a lot. Ill add to your rep.

I get it, i should consider carefully any secondary possibility so that my model needs no secondary modifications, but even after doing so, my doubt remains, how can i do so that one form will autocomplete loading data out of a secondary table when i input a field that matches a registered client ?

Nah, its perfectly ok, you were right, i wasnt quite understanding it the right way. The Purchase order im trying to develop has information both on who am i purchasing supplies and for whom am i purchasing them. Thats why i need both client and supplier tables to relate with the purchase order...

Thanks for the insight, im think i'm a little more into it now, i've started editing over NorthWind as Col suggested and its working pretty good. Is there any good online tutorial about inputing data in a form using comboboxes to input preexisting parameters already stored in other tables ?

Hi there, I've just started working in a office, and i've been requested to design a database in access in order to register any work that comes up. What i need to build is a database that includes the following tables: - Customers - Suppliers - Purchase Orders But being just improvising...