Recent content by kadara

Here is the simplified version of the db (I just removed the switchboard). I can't fix the problem. If there are no records, I get the runtime error 2501 message.

Not working...

There is no change. I get this error again.

Runtime error 2501 Hi, I have a report filtered by date (between 2 dates). I put the following NoData event: Private Sub Report_NoData(Cancel As Integer) ' Display a message if user enters a date for which there are no records, ' and don't preview or print report. Dim strMsg As String...

Thanks for your answer. With your code I have the same problem. I turned the printer off and run the code, and the result is the printer is idle. I checked the status in the "Printer and Faxes" and the printer is offline.

Hi, I need to check the status of the network printers (if the printer is on/off or have some errors). I found the following code on the web: Option Explicit ' Win32 API declares Private Declare Function OpenPrinter Lib "winspool.drv" _ Alias "OpenPrinterA" (ByVal pPrinterName As...

I tried to open the same doc file from the local drive (C:\Test\MA040.doc), but I got the same error message (Run-time error 4160: Bad file name)

Yes, it is a network drive at my workplace.

U:\Mdb01\Zebra\MA006.doc

I'm absolutely sure!!!

Nothing wrong with the file name or the path.

I updated an existing code to my project. I changed the GetObject to CreateObject, and get an "Runtime Error 4160: Bad file name" on the Set doc = .Documents(tmpDoc) line.

Ok. In fact I would like to update an existing word document with some information from an access table with the following code: Public Function wrdUpdate(tmpDocName As String, tmpDocPath As String, tmpSeria, tmpNume, tmpData As Date) Dim tmpAppWord As Object Dim tmpDoc As Object On Error...

Hi, I would like to open a word document from an access form (using a button). I get a runtime error message: "Run-time error 429 - ActiveX component can't create object". I try to use a simple code: Private Sub Command0_Click() Dim wrd As Object Set wrd = GetObject(, "Word.Application")...

Hi, I have a custom toolbar (menu bar) in a database. Is there any possibility to export this custom menubar to an other database or I must re-make the menubar in the new database (the menubar has the same functions in both of the databases)? Thanks.