Search results for query: *

I've never heard of that before, and actually I couldn't find any info on the Safe Mode command line switch at all when I looked for it. I tried just slapping the /safe at the end of the command line anyway, and there appeared to be no change in opening the corrupt db or a working one that I...

I can't get into the old DB at all using Access. The only thing I have gotten to is the data through Excel.

Yup. Sorry if that wasn't clear. I can't import the forms from the old DB into a new one. After I browse for the old DB using the import function in the new DB and hit OK, the screen where you choose the objects in the old DB that you want to import never comes up. However, I noticed that if...

Hi- I have a corrupt database that I need to get a few forms out of. When I try to open the file, I enter my password and then the file fails to open. Access itself stays open as if I had closed the database window and now no Access files are open. I have not found any information regarding...

That did it. Thanks! Have a star.

If an excel document is open and the code is executed, nothing happens in access but the excel window in the taskbar begins to blink. When that excel window is maximized, the dialog box is open in front of the spreadsheet instead of the dialog box appearing in front of the form in access.

Followup: When I use the GetOpenfileName method while I have an Excel document open, the dialog box opens up in Excel, not Access. Is there any way to block it from opening in Excel? Thanks. Todd

Slashes going in wrong direction. Problem solved.

Okay, I tried both of these and they work when the document is located on the local machine, but not when it is located on a remote server, which is what I would need. I tried using the server name directly (//server/folder/file) and also the drive letter that my local machine uses...

Even better. Thank you.

Perfect! I don't know how I missed that. Thank you. Todd

Hi- I'm writing a document management tool and need to know if there is a function or method of opening a file using the windows defined program associated with it. I believe the Shell command only opens exe files and other methods require creating an object of the specific program you want to...

Does anyone know how to do this in conjunction with reassigning page numbers as described in KB 306127? Using this method for generating a blank page, my page numbers get all fouled up... TIA. Todd

That did it. Thanks! Have a star.

Hi- I'm having trouble linking a dbf file in code to the current Access database. Here's the code DoCmd.TransferDatabase acLink, "dBase IV", "//server/folder/BILLSUM.dbf", acTable, "BillSum.dbf", "BILLSUM" What's odd is that I'm getting a "not a...

I just wanted to post the resolution to a problem that brought our office to its knees this past week. We have a multiuser Access 2K database being accessed by about 12 clients with W2K and have been getting the following error about every 10 minutes after repairing: The database...needs to be...

I went with DAO instead, but thank you. Maybe I haven't been very attentive in the past, but you seem to be posting in every thread I look at all of a sudden. Did you recently quit your job and turn to being a Tek-Tips guru? :) How do you have time for all of this? Just curious...

I used the code from the Knowledge base and I am getting a 'Type Mismatch' error on the Set GrpPages = DB.OpenRecordset("tblReportGrouping", DB_OPEN_TABLE) in the Report_Open Event. I obviously changed the table name from what is in the example, and it has been changed in all...

Finally!! I took the code from the problem function and placed it where it was previously referenced to eliminate those issues discussed above, and the second instance of the outlook object was removed. Thanks for your time Rob, have a star.

Shouldn't it recognize the "Set objOutlookMsg = objOutlook.CreateItem(olMailItem)" line that was already executed in the function above it? I'm not very familiar with the ActvieInspector method but from what I have read and more importantly what I am trying to do, isn't the...