Recent content by tsonnenl

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