Search results

Bastanu, i fixed it... Data entry was set to Yes and al those additions, edits and so on, to No... I put them back to yes and that was it... Thx, Anyway! Salutari si tie!

I really don't know what happened but one of the forms is accting weird It is all there in Design Mode, but nothing can be seen in Form or Layout view The culprit is Add_ClassCode_Frm. Can be oppened trou the second button from main, labeled "Adauga Domeniu" Thank You I finaly fixed it. Data...

"and i am really surprise that you are doing Trial and error." How else? You told me to test it, I am testing it (somebody just went angry because I removed some of his doings just because they didn't work as I wanted to, so ... I am testting now) Probably I don't have enough general knowledge...

How can I prevent entering the same author more then one time for a title? Yet, that button still does not do his job For one author works fine For more then one, it stops working The behavior is this: Adding one> I can delete Jimmy Jones If i press on the button near the second row (the...

Actually the button is not working :( If I open the subform itself, it has some reaction. In the main form doesn't work Fixed (i gues) It wasn't If Not Me,Newrecord, but If Me.Newrecord. (Yes, it works... the condition was wrong)

The button woks nice, Thank You Still, even if I notticed that pressing Esc is untrapping me, somehow I have to prevent that error, or, I can use a sticky note on the monitor to let my coleagues to press the Esc :)

Ok... let me be more clear I am selecting in the Combo some data from the list. For some reason, i change my mind and delete the value in the Combo (just empy the content of the Combo), so now it shows nothing selected. When I am trying to leave the combo, thet message pops and all is blocked. I...

If I am filling some data on the ComboBox and delete it afterwards, the error msg> You tried to assign the Null value to a variable that is not a Variant data type. pops out. There is no way to leave the combo on the prior empty state. How should I fix that?

Comming back with testing Save button actualy saves the record, but does not jump to a new record after saving. Why it should be keeped, since the New button saves and goes to new record. Isn't it redundant? I tried to remove it and I get an OnLoad error. Can I load its functions inside the new...

Tested Works pretty well So. I can add a new author via the subform, or I can choose one that is already in list > Excelent Also fills the Junction Table > Good It seems that it will save the record even if the PublishYear_Box is not filled. That is not good. It is a mandatory field I tested...

I attached a database called Bookstore By now, I have a main AddTitle form and a subform that should add author (not finished yet, but working so far) Without the subform, the main form works as it should (at this time, again). Yet, after the sub is embeded, the main does not work anymore...

A little help, again, pls I am trying to replicate some of ClaraBarton's database By now, I have a main AddTitle form an a subform that should add author (not finished yet) Without the subform, the main form works as it should (at this time, again). Yet, after the sub is embeded, the main does...

Pat Hartman, this is really something !!! yet, some error are trigered during use... I wil try to understand your way of thinking and doing the job and if is not too much, I will come back to you for guidance or help in fixing the bugs. Thank you and I apreciate a lor your effort and patience...

To keep it verry simple, i will describe a process> I have two tables 1. Book Tiltles. Fields are Book_ID, Title (and some other, not relevant) 2. Authors. Fields are Author_ID, Author_Name One book may have none (when it is a collective author), one, or many authors Same author can write one...

6. In the error message regardin the unfilled control, I cannot refer to the control name, but to the control label :)

Too compact and yet seems to have some issues... 1. The color does not change to the unfilled control 2. There are controls that can be saved with empty value, so I cannot use a global function. (Call_No, ClassCode2 and 3) 3. The control labeled Cota, is dead 4. How is triggered the MsgBox ("Do...

Gasman, i checked the third test and now it works. (copy/paste, indeed). Thank you. Yet, the first two stil don't geet red.

I have a form that doesn't work as it should. First problem> On form load, i set the value for all controls to null. Just for testing, after loading the null values, i added the code to colour the border for the null controls. Only one is getting red. Second problem I set a variable to...

Works like a charm. Thank You again

Gasman, thank you. Can you be more speciffic please? How should I do that? The combo row source is: SELECT Domains.Domain, Domains.Class_Code FROM Domains ORDER BY Domains.Domain; How can I add the additional column (probably the ClassCode) Let us assume that the Combo field name is Combo and...