Search results

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.

With the " ... WHERE Batch_Date Between #" & Format(Me.DTPicker1, "mm\/dd\/yyyy") & "# And #" & Format(Me.DTPicker2, "mm\/dd\/yyyy") & "#" working fine. Many thanks.

The OS date format not set to US format. How could I change in VBA the date format to US without affecting the OS date format?

I put on the form two Date controls (DatePicker). How could I format these controls to show the correct date? I tried two methods: 1) Format(DTPicker1, "Short Date") - with this format I have no results (I have found no records). 2) Format(DTPicker1, "Medium Date") to get the "01-Jul-2010"...

OK. It's seems to be working. 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...

OK. I created the query. But how could I import the query field (total of quantity) into the textbox. About the data range: I put two datapickers on the form (start_date and end_date). With these datapickers I enter the range.

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.

I get the message in that case when I physically open the Excel file.

The same problem... Anytime, when I open the Excel file, appear the error message.

It's not working. (I've got the same message).

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

Thanks. It's working great.

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

Thanks. The Format(DTPicker1, "dd\/mm\/yyyy") is working great.