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

...just the form? This is what I have: Private Sub CboKras_Change() Call GetKras(Me!CboKras.Value) Me!CboUPC.Value = UPC Me!CboCS.Value = CS *** Here Access tells me that UPC and CS are null values even when the GetKras populates the public variables. End Sub ***MODULE Public RS...

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

...= [name of 2nd CBO]: Me.[name of 2nd CBO field].SetFocus Me.[name of 2nd CBO field] = DLookup(etc., based on value of CBO1). Hope this helps *But it did not help. I get the same message. Do I need to set an additional reference in the modules? I can't figure this out. Anybody have any...

I tried your suggestion, but it did not solve my problem - I get the same error.