Recent content by yessir

* Solved * I had a checkbox (1) without a value in tag. when checked first it would fail as was null set this to (0) and is all fine now...:)

Here's the Kicker I have Some that work and some that don't on the same form. the are the same elements with the same checkboxes with the same text values just different records.

I have this: Private Sub GetTotal() Dim ctl As Control, intScore As Integer For Each ctl In Me.Controls If ctl.ControlType = acCheckBox Then If ctl = True Then intScore = intScore + ctl.Tag End If End If Next...

apparently 3 people had continued connections to the 2 .ldb files. the admin above me had more rights and was able to remove the connections allowing me to remove the files. I have advised the users about proper use and distribution of the database and hopefully this will clear up any problems

a logout and restart didn't solve the problem either :confused:

I have a split database and up till now it was fine. It made a lock on the be and left the fe open to use. NOW it locks the fe and not the be. ANY ideas y?

Record Locking Level, Run-time error '2448' Hey, I get this error: Run-time error '2448' You can't assign a value to this object. sometimes when I run a form. The form has a dropdown which when a value is selected opens a form to that record. I found this site describing the error and...

Hey, I have a form (1 that I know about n3way) which I made NO changes to but during an update 1 aspect of the form failed to work on the other computers but , yet, works on mine. The issue is that there are 3 dropdowns. when the first is populated, the next is populated based on the selection...

Ok, changed to this: department_contacts ======================== PK | dc_id ------------------------------- FK1,I1 | dc_department_id REFERENCES department FK2,I1 | dc_contact_id REFERENCES contact ======================== Here was the example I was following: A table can contain...

FYI, i went with: department_contacts ======================== PK, FK1 | dc_department_id REFERENCES department PK< FK2 | dc_contact_id REFERENCES contact ------------------------------- ======================== Allowing the use of M-M relations if so desired but are not layed out in...

thanks for your patience

So then, If I am entering a dept and a contact doesn't exist I must force the user to enter the contact info before hand, and if a dept doesn't exist then I must force the user to first create a dept. Still seem circular. But it is the morning..

i know.. it's confuddled... I am repairing/ upgrading an older appln and am in the init stages of understanding it. this is what they currently had. A person may have a dept or not. a contact doesn't have to be an employee. a department may have a contact and they may be an employee or not...

thanks, Actually the dept and contacts table are used as refs. (including to each other) A dept can have a contact and that contact can be from the table, A contact can be have adept and that can be from the table but it is not necessary to have a defined relationship i believe other than...

I have (for this post) 2 tables. department ==================== pk | d_id -------------------------- | d_fund fk1 | d_status_code_id | d_department fk2 | d_building_id fk3 | d_contact_id fk4 | d_note_id | d_modified | d_user contact ==================== pk | c_id...