Search results

Hi! The code below set the printer correctly (\\wxp-021\hp1210Shipping), but the application print the report on the other printer (\\wxp-018\NetPrintQueue2Fax). Just before the OpenReport command, I put a MsgBox, and the Application.Printer is really \\wxp-021\hp1210Shipping, but it print on...

Hi! In a form I have a combobox with 2 columns. The RowSourceType is a list of values. How can I set the defaultvalue of this combobox? Thanks!

Hi! I have to put a conditional criteria in a query. If the value of a listbox in a form is "My value" then don't put criteria, else the criteria must be :like "listbox value". How may I do that? Thanks!

Hi! I put items in a listbox with addItem method. But if my string is more than 16 characters long, this cause an error. Is there another property for the length of accepted string? When my listbox is generated with a query, it accept very long string! Thanks

Somenone have an idea why this line cause an error??? DoCmd.TransferSpreadsheet (acExport,,"R_export_excel","d:\test.xls",,,) Thanks!

Hi! I tried this code to export fields from a SELECT but two lines doesn't work. Public Sub ToTextFile() Dim intFileNum As Integer Dim strFileName As String Dim strText As String Dim db As DAO.Database Dim rst As DAO.Recordset intFileNum = FreeFile strFileName = App.Path & "\" & Month(Date) &...

I have a table 'item' who contains the name of the item and the price. The format of price is standard with 2 decimals. In a form I have one item and I do a sum of this item (sometime there is many item). When I have high number like 471 219.70 the sum of this number is 471 219.66... Why?!? I...

Hi! I try to use Nz function in my report but when I quit and come back to my report, the Nz function has disappeared. I think it's because I don't use it correctly but I don't know how.... I want this calculated field (who is ok) =[item30]-[paiement30] return 0 if is null. I tried this...

How can I update a field in a form after an AfterUpdate event of a field in the subform. When I create a new record in the subform, I want that this new data update a field in the form. Thanks

Hi I have a report who print bill. In the detail section I have different number of item (maximum of 6), but I want that for any number of items, the height of the section is always the same (like when there is 6 items even if I have just one). Is there a way to set this? Thanks

I want to code a function that checks if the number of record in a table is > 0. If count(table.record=-1) > 0 DoCmd... DoCmd... DoCmd... Thanks

Hi! I would print a report (3 copy) from a form on close event. I can't use the PrintOut command (it print the current form/report and I'm in a form) and we can't choose the number of copy in the OpenReport command. Thanks