Search results for query: *

I run an exporting procedure that scrolls thru and sends different queries to the same file location, creating multiple worksheets within the workbook. I can also use this method to format the spreadsheets after they are created. Why can I not do this in reverse when I import the same...

If you scroll thru a recordset in a procedure, sending the same query with different criteria to the same path, Microsoft automatically creates mulitple worksheets within a single workbook. In order to format these individually, I need to run thru the format routine, and then move to the next...

I have a database that had no password protection on it. All of a sudden, every morning, there is a Microsoft password applied to it. Every time we try to open the database, it prompts us for a password (not a form with code, but the security password access has built in). I don't set this up...

Is there anyway to put a password on the database view of a program? I know you can set a password within Access when the database opens (user's view AND programmer's). But is there anyway to put a password JUST on the (Enter+Shift)? I am creating a database for users that A) do not have a...

I have a frontend/backend setup for a database here. We have 6 users with local copies, linked to 2 shared databases. The database used to be just one database on a shared server, but in order to eliminate continuous repair errors, I split it up this way. We STILL get the repair error on the...

How can I get the list boxes on my form to NOT be blackened in?

On the change event for a set of three combo boxes, I want to evaluate the one that was entered and then update the other two. I have to put the evaluation procedure in a function, but am having trouble then updating the subform from the code in the function. Is there some special reference I...

I think this might be an easy answer, but...I want the users to first press a button to evaluate a value before they are allowed to create a new record. When they scroll thru the existing records (they insist on "move next/move last" controls) and get to the last one, they can just...

I have 3 combo boxes that are linked together. When anyone of them is changed or populated, I want Access to automatically populate the other 2 fields. I've tried ALL the options; OnChange, OnDirty, OnUpdate, AfterUpdate...all of them. The event procedure is in a Private Sub and what I'm...

I have 3 combo boxes that are linked together. When anyone of them is changed or populated, I want Access to automatically populate the other 2 fields. I've tried ALL the options; OnChange, OnDirty, OnUpdate, AfterUpdate...all of them. The event procedure is in a Private Sub and what I'm...

I keep getting an error that a database needs to be repaired. It is already a front end/ back end setup and the problem occurs in the back end. All this database holds is the data - the users do all data manipulation locally. I cannot seem to find why it keeps needing to be reapired like...

I have a problem where tables are created with a make table query. Occasionally, we run into an error where the user (and myself) are denied permission to delete the table (it is deleted and remade many times a day) before the new one is created. How can I assign (or unassign) permissions on a...

I have a problem where tables are created with a make table query. Occasionally, we run into an error where the user (and myself) are denied permission to delete the table (it is deleted and remade many times a day) before the new one is created. How can I assign (or unassign) permissions on a...

We recently converted our office version from 97 to XP. we still have our old operating systems (NT, 98, 2000 - varying). I am having a problem with one of our databases where we have had to repair it 3 or 4 times a day. Occasionally we would run into this problem before we converted, but now...

This happens often. We have more than 5 users at a given time in Access db. I'll get the error that "another user may have unexpectedly quit application while in use..." and that the db needs to be repaired. I'll kick everybody out and then repair. Sometimes it runs thru without a...

I have code behind a form that runs a maketable query and then renames the table. We get an error messages that a user "does not have permission to delete" and the debugger stops on this piece of code (the rename). Why are the user's permissions revoked? I never set permissions on...

This happens often. We have more than 5 users at a given time in Access db. I'll get the error that "another user may have unexpectedly quit application while in use..." and that the db needs to be repaired. I'll kick everybody out and then repair. Sometimes it runs thru without a...

I have code behind a form that runs a maketable query and then renames the table. This has been running smoothly for a few months and now all of a sudden we get error messages that a user "does not have permission to delete" and the debugger stops on this piece of code. Why are the...