Recent content by Bioman

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