Search results

* 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...

Apparently in MS fashion, if I delete the form and switchboard completely (after copying the table data to excel of course) and then start from scratch (start a new switchboard with the wizard) then copy the excel data back to the table, all works fine. It's like a windows soft boot, everything...

Thank you for the quick reply, but that actually doesn't solve my problems as the error is produced via the switchboard wizard (evil MS wizards). (I did not plan nor develop this only update it). But the error is caused cause I cannot update the switchboard and have these refs work on both...

I am currently using Outlook 2003 (Microsoft Outlook 11.0 Object Library) and everyone else is using OutlookXP (Microsoft Outlook 10.0 Object Library). How can I have Microsoft Outlook 10.0 Object Library as a reference in my Code view > Tools > references without installing outlookxp? Thank you.

hey, that was a VERY strippe down version of the db to get it to fit but thanks. the other computers have the same version, sp of access and windows.. I also disapprove of sb's but it is legacy code and is (hopefully) soon going out the window. I cannot find a dll that isn;t ont he other cpus...

Hey, I am updating a switchboard from someone elses work. I get the error on other peoples computers (but not my own) that there is an "error loading DLL" and the I get "The expression On Click you entered as the event property setting produced the following error: The expression you entered...