Search results

I am working on a database in which I must check the records in one table against the records of another table, and return a list of the one's that don't match. The tables contain salary accounting information. For each employee, they can have up to 5 fund/orgn/acct combinations, with a...

I have a secure database that has users login using their oracle username/password. I've got that working great (thanks to some code I got off another thread....Thanks, Pat!), but I need to make it where my code automatically logs on a 2nd user, who has oracle access to a couple of linked...

I have a finished secured DB that I'm trying to figure out how to distribute properly. The DB is called "New Finance Queries.mde". I've got the workgroup (mdw) file stored out on the server at "\\Fin_tools\Finance Queries\New Finance Queries.mdw". I've searched this forum on this topic, and...

I'm working with Access Security for the first time. I've read the FAQ, and I feel like I have a good grasp of how it works overall. The code on my main form creates a query and saves it as a queryDef. However, I need this query to be able to pull records from a table that is off-limits to my...

I'm trying to figure out what the best way is to fully secure my database the way I want it to be. I've browsed through some of the posts and skimmed the Microsoft security FAQ, but I'm not seeing answers to my questions, and I'm unsure if that's the route I really want to take. Basically, my...

I have a database that backs up a bunch of tables from our live oracle database and runs every night via a windows schedule task. I've had ongoing problems with it working some nights and not other nights, so I've decided I need to put some code into it to copy whatever errors are happening and...

I'd like to change the multiselect property of a listbox using code when the user clicks a button. VBA help lists a way of doing this: Forms("Order Entry").Controls("Country").MultiSelect = 2 However, this doesn't work. My code won't even run when this line is in there. When I comment it...

Is there anyway to bring a control to the front (exactly like what Format->Bring to Front does) in VBA? I have a combo box that is directly below a label, close enough that the top pixel of the combo box exactly overlaps with the bottom pixel of the label. Sometimes while I'm running my form...

I am working on a database that will allow my users to query financial records. I'm setting up the entire thing to use VBA code and forms. I'm running into an interesting problem that I haven't been able to think of a decent solution for, and I thought someone here might have some ideas. I'll...

I have some code in a command button on a form that generates Error 2001: "You cancelled the previous operation." I've searched this forum for fixes, and the only suggestion I found which might work for me is creating a new database and importing everything from the current one. I've tried...

A project I am working on involves a two-tiered backend database setup. A database called "Finance Backup.mdb" runs a bunch of queries that creates some backup tables, and then exports these tables to "Finance Views.mdb", which my front-end application links to. I have set things up so that...

I'm trying to figure out how to secure my backend Access database. The backend database stores all the tables I use in my frontend database application. I need to figure out a way to secure my backend DB so that my frontend application can always link to the tables (regardless of who's logged...

I need to add security to a database I have setup. I have lots of tables in my backend database that my front end database application links to. Is there someway I can set up security on the backend database so that only the front end application can link to the tables? I tried setting a...

For some reason, Access is unable to create an mde file out of my mdb database. This has never been a problem before - I've converted this exact same database to an mde file several times before. I've been working on fixing a bunch of bugs recently, and now that I have those fixed, I want to...

For some reason, whenever I run Access (from the program icon, not by double clicking on a database), all the menus are gone. Nothing happens when I right click (I guess the right click menus have been disabled, too). I basically can't do anything but close it. It didn't use to be like this...

Forgive me if these questions have been asked and answered before, but I searched for the answers to them, and couldn't find anything....so here goes: I am setting up security in my access database. Rather than using the access security wizard, I have things set up where it prompts the user to...

I have created an Access Database that some of my coworkers would like to be able to take home to use during weekends. The main database is entitled "Finance Queries", and contains all the forms, queries, macros and code and is what the user interacts with. I have another database entitled...

I'm trying to create a query which pulls the value of a combo box on my main form into a column. This combo box has the default value of 12. For some reason, the query works fine if the user selects a value in the combo box (even if they simply re-select the default value). But if the user...

I have an interesting problem. When you open the database, it puts the user through a login form before opening anything else. I tried to add a feature to the login form, but somehow my code has messed up the login form to the point where the Login button doesn't do anything, and won't let the...

In a database I have created, I have set up a button that does the same thing as the Tools -> Office Links -> Analyze It With MS Excel menu option. It simply exports the data to excel. 99% of the time, this works great. However, I've run into a problem recently - when I try to do this on a...