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

Thank you!

Hi! "See MS KB No 95806" What is that? Thanks!

Thank you for your help. If I put ="All", it work fine...

With Default Value: "All";"(no filter)" I get a syntax error message

Yes, I try to use de defaultvalue property but it dosen't work. My list of values is like this: All;(no filter);1;Critic;2;Normal The list is diplayed on 2 columns. When I put "All" in DefaultValue Property, it doesn't work, neither if I put "All;(no filter)"

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!

ok, it pop me because the [FieldName] is an alias Year:Year([Activity].[DateEnd]) When I use Year([Activity].[DateEnd]) instead of Year, it work fine! Thanks!!!

Is it normal that it pop me a prompt box to enter a value for FieldName instead of return records?

What is your set up to show all records when a listbox is null? Could I try to replace the "My value" string by a null item?

oups... problem Thanks, but... It work fine if Forms!FormName!ListBoxName <> "My value". But when Forms!FormName!ListBoxName="My value", the query select nothing. I have an empty result. Instead of "", I tried "*", like "*", like '*', not null, "not null" but any seems to do the job! Suggestion ?

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!

forget my last message but look at this ListBoxNoDem.AddItem oRs("des") 'This line work fine with any oRs("des") Do While Not oRs.EOF ListBoxNoDem.AddItem oRs("des") 'The same line in a do while cause an error if oRs("des") has ' more thans 16 characters...

wow! it's weird... When I use this method: listBox.addItem "This string may be very long" I have no problem, but if I use this method: listBox.addItem oRs("description") this cause an error if oRs("description") value is more than 16 characters!!! why?

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!

ok! Thank you, it was the problem but I have two others problems: I declare: Dim db As DAO.Database Dim rst As DAO.Recordset but when I use the function, it cause an error who say the types are undefined!?! Is there a different way to declare this variables in Access 2000? Thank you!

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 don't want to use currency because sometime the currency is not dollar

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