Search results

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

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

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.

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

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

Hi, I would like to send an email with the following code: DoCmd.SendObject , , , strTo, , , strSubject, strText, False My question is: When I click "No" on the message box "A program is trying to automatically send e-mail on your behalf. Do you want to allow this?" I get a runtime...

Hi, I would like to export some tables to Excel using OutputTo. When I open the Excel file with the exported table, I get a message "File error. Some number formats may have been lost." Please help. Thanks.

Hi, I have a filtered query (filter a table between 2 dates) and I would like to export this query to an Excel file. Using this code (because I would like to format some cells) return an error message: "Rut-time error 3061 : Too few parameters. Expected 2." I tried to export the query to Excel...

Hi, I would like to export tables, queries, subforms to Excel. I've used the OutputTo function. The problem is, I know nothing about formatting the worksheet from VBA. I would prefer to format the cells (Font size, font style, cell borders, colors ...). Please help. Thanks.

Hi, I put on a form an unbounded subform. I would like to set different recordsources to this subform depending the selected option button. Form example: CASE 1 bound "Query1" to the subform CASE 2 bound "Query2" to the subform Please help. Thanks.

Hi, I have a problem with filtering a recordset. I would like to filter the recordset between two dates. When I make a query, and put the "between" criteria, everything working fine. But when I filter the recordset with the sql statement from a form, I get an error message (no records between...

Hi, I have a table with the following fields: BatchID, Batch, Quantity, Date I would like to display in a textbox the sum of quantities between two dates for a single batch. How could I do that? Please help. Thanks.

Hi. I would like to export a query to Excel. I put a button on a form with the following command line: DoCmd.OutputTo acOutputQuery, "Query01", acFormatXLS, "C:\Tmp\Test1.xls", True When I execute this command, the Excel file is opening with the "File error. Some number formats may have been...

I have a report (see the attached pic). In this report I would like to put a field with the sum of quantity subtotals for each PartNo (Total Sum of quantities for each PartNo). Please help. Thanks.

I have a table with these fields: Batch, QuantityIn, QuantityOut, DateIn, DateOut I would like to display the difference of Sum of QuantityIn and Sum of QuantityOut (SumOfQuantityIn - SumOfQuantityOut) for a period (between DateIn and DateOut) for a single Batch in a TextBox. Please help. Thanks

I have a Date/Time Picker on a form. The system date format is dd.mm.yyyy (short date). How could I change it (without changing the system date format) in dd/mm/yyyy ? I tried the Format(DTPicker1, "dd/mm/yyyy") without any effects. Thanks.