Search results

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.

Thanks. Works well.

Hi, On a main form I put a TabControl with 5 pages. On each pages I put a subform. How could I refer to each subform's control (textbox, listbox etc)? Thanks

Thanks. The ENVIRON("UserName") working fine. But is there any possibility to get the email addres of the current user and save it to the table? Note to Environ method: at my worplace the username is set as follow: LastName FirstName and also we get an Alias (for example: John Smith and the...

Hi, I created a module to send emails with Outlook. I would like to save some informations to a table. These infos are: the name (or email address) of the recipients (the sender, To, CC, BCC). I successfully solved to save the To CC BCC recipients, but I couldn't get the informations about...

I did a search and I found the following code: On Error GoTo MyButton_err ' your code here MyButton_Exit: Exit Sub MyButton_err: If Err.Number <> 2293 Then MsgBox Err.Description, vbExclamation, "Error #: " & Err.Num End If Resume MyButton_Exit but I still have the same problem...