Search results

I am continuously so incredibly impressed with this forum and this site. Thank you for the quick answer. I'm positive I'll have more as I muddle my way through this silly treeview experiment, but thank you for all your help!

Ok, I'm not getting anywhere here. I've tried modifying several different codes that I've found and I keep getting stopped at the same spot. Why in heaven's name would Access not like: Const strTableQueryName = "inc_Incident" Dim db As Database, rst As Recordset Set db =...

Yea, but my point is that you actively have to enter an incorrect password to disable the feature once it's enabled. Is that by design?

I'm finding one issue with the code, and I'm not sure if I'm doing something wrong here. 1. Click my transparent button I get prompted for the password. 2. I type it in, then close the database. 3. Open the database and the shift key works. 4. Close the database. 5. Reopen the database...

I've read everything I can get my hands on about securing a database, and I think I have it all implemented the way I want, but my users can still do one thing I don't want. It seems really simple, but I can't find a way to stop my users from accessing a table from the database window. They...

Good to know. Thanks. I'll keep plugging away at it.

Trying to setup a treeview and it's hurting my brain. So here's hoping people can help. tblReviewers Reviewer_ID Reviewer_Name tblCases Case_ID Case_Description Reviewer (Stores the value from tblReviewers.Reviewer_Name) I want a Treeview where the parent nodes area a reviewer's name and all...

I've been using the same code in my database for probably 8-10 months. Today I get an error. Any idea on where to even begin troubleshooting? Here's the code: General - Declarations Public Declare Function apiGetUserName Lib "advapi32.dll" Alias "GetUserNameA" (ByVal lpBuffer As String, nSize...

Ah, and this is how I got really clever :) I decided to go away from the multiselect box and go with a subform with checkboxes. So now, a user goes to the main form and enters information. They click a button and the subform appears. They click checkboxes to select the classifications they...

I'm trying to create a database where a single "Classification" field is populated by selections made in a multiselect listbox and I can't figure out how to do this. Any help people can provide? Table 1: Name_ID <pk> Name Classification Table 2: Classification_ID <pk> Classification What I...

I am saving before I do the check, so that's not it. /sigh. Lagbolt, I wasn't getting a type mismatch on the check. The error was simply that it couldn't get the property. I tried both your ideas and they did give me a type mismatch error. Any other ideas? It can't be that had to see if the...

I would have thought this was easy, but I keep getting an error. I have a form with a save button. When the save button is clicked, I want it to check if user has attached an OLE object to a bound object frame. If they have, I'd like a checkbox to be true. Here's the code I tried: If...