Recent content by sparky961

I'd really love to put this thread to rest... but I've thought of another catch to this. Even if I'm able to get the query to work properly (which I haven't, as of yet), what's going to happen to the records in my new table(s) when the updater goes and deletes the related record? Seems to me...

Well, I don't have it working yet, but I do appreciate your guidance to this point. I'll keep plugging away, and researching... :) Thanks, -Sparky

Still working on it, and here's a version that's a bit more organized for those like myself that need some spacing and formatting to "get it"... SELECT salesorder.PONumber, salesorder.RefNumber, salesorder.DueDate, salesorderlinedetail.CustomField6, salesorderlinedetail.ItemRef_FullName...

Ok, I decided that if this works it'll surely be the easiest implementation. I'd love to get a solution working that doesn't require additional VBA code. That said, it doesn't seem to be working the way I'm using it. Here's the query I'm basing the main form on: SELECT salesorder.PONumber...

Maybe I'm missing something, but how do you check the checkbox in order to store the result, if it's greyed out? Thanks.. -Sparky

Guus, At this point, the database is massive and it contains sensitive information. If I need to in the future, I might be able to condense things into a more portable generic format that I can post. Can you tell me how Access will display checkboxes using the method you suggest? For...

I have a database that gets automatically updated by an external application (AccessBooks RT). Currently, the application is set to replace existing records. This means that any fields I add to the tables are lost during an update. It has been suggested to me to add tables that contain the...

This is a real PITA... trust me, I've just recently been through it. Check out this PDF file. The instructions are long, but they work if you're careful and smart. :) http://www.geocities.com/jacksonmacd/AJMAccessSecurity.pdf That said, it MIGHT NOT BE WORTH YOUR EFFORT! User-level security...

Thanks for your feedback on this. Until I get things sorted out, I've basically done what you suggest - to create a new insecure database and copy everything into it. In my own "new to Access" way, I'm glad that they've dropped support for the JET user level security. It's extremely...

It seems to take a rather long time to go through and create users, groups, select the permissions, import to another database.... etc. For starters, is all of this really necessary in order to secure a database? Now that I've stuffed all of the security holes with duct tape and chewing gum...

Thanks... this solved my problem too. Great little utility there. -Sparky

I've been doing a lot of reading today on this, and it looks like Micro$oft has really screwed this one up. Correct me if I'm wrong, but it looks like my best option at this point is to stay with the MDB file format and user level permissions. As a side note to anyone looking for similar...

Hi all... I've been doing some research on securing various parts of a new database application, but have yet to come to any conclusions. Another post on this site referred to this link: http://www.geocities.com/jacksonmacd/AJMAccessSecurity.pdf ... which seems to be well written and...

Indeed, that confirms that I've been seeing. I'm 99% sure that the screenshot I have here did it with a continuous form. Not being "one" with Access, it didn't occur to me that this was possible. As it turns out, it's actually quite simple. I now have the application to a point where it can...

My immediate need is to set the title of a report based on how it's called from code. As far as I can tell, the best way to do this is through the use of the OpenArgs parameter of DoCmd.OpenReport. The problem is doing something intelligent with the OpenArgs from the report's Format (or other)...