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

As always, I figured it out as soon as I wrote the post. In case this helps anyone: Dim objASht As Worksheet Dim wks As Workbook Dim Path As String Dim WksCt As Integer 'This is in a loop until all worksheets have been formatted Path = "..." WksCt = 1 Set wks = GetObject(Path) Set...

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

No - every morning, even when you manually open the database, the password protection has been setup. I use a copy from the day before (with no password) and overwrite the offending copy. We use a software package to back up the databases every night...maybe this is causing it? {Altho, it...

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

Thank you guys for all your suggestions.

Interesting! I'll look into that - it sounds feasible. Thanks for the idea! I'll post back here with what I find works.

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

Those properties are set as you indicated and it still does not work.

Yes, those are set. Thanks.

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

No, the boxes are blackened in no matter what field the focus is on. It only happens on these list boxes.

Yes, they are enabled already. All text boxes on the form are white with black writing, but the list boxes that are populated show up black with white writing. I never had this problem with list boxes when using them before - maybe I just got lucky.

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

In case anyone can benefit from this: What I did was make the 1st combo box have 4 columns show. Only the first is bound. Then on the change event for the combo box, I update the 1st field to the 1st unbound column, the next to the 2nd unbound...etc. It's much easier than what I was trying to...

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 had the cancel as integer in there previously, but it didn't work. Tried again, to no avail. As I am testing this procedure out, I only have the one sub defined behind the form. I also tried Tazcat suggestion - called a function in a stand-alone module, and passed the values, but it...

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 tried your suggestion, but it did not solve my problem - I get the same error.