Search results

Thank you very much for your help, darbid. The combobox is fine for my needs. Thanks again. Regards

Hello, I have a form on which I put a few controls. I have one ComboBox and two TextBoxes. ComboBox's name is Dep, TexBox1 - Abr, TextBox2 - Fac. Is it possible to automatically fill up TextBox1 and TextBox2 with the appropriate values depending on the value selected by a user from ComboBox? I...

Thank you Regards

Hi, Could anyone help me and tell if there is thousands separator in Access, the same or similar as in Excel. I'd like to use it to one of the field in my query. Thank you in advance.

Yes, now it works perfectly. Thank you all very much for your help.

Well, maybe I created a little confusion. Let me exemplify. ID LastName FirstName Position Department 1 Smith John Programmer IT 2 Smith Andrew Programmer IT 3 Brown Michael...

Hello, I have a query containig the following columns: Id LastName FirstName Position Department I'd like to filter these records for which the values of LastName, Position and Department are the same. Could anybody help me? I'll be grateful for your help. Thank you in advance.

Yes, of course... Thanks for your help. Regards

Hello, I wonder if is it possible in Access to "convert" a given column, fields of which have been created on the basis of the custom function. I'd like to achieve the same or similar result as when using Excel - when I just copy a column with formula and paste it specially indicating "copy...

Thank you for your help. Regards.

Hello, I'd like to ask you if it is possible to substract one query from the second query. Both queries have the same columns and they are put in the same order, so their composition is identical. In the 1st query there is a list containg some names that may be also in 2nd query and other...

I decided to try a solution that suggests changing the font in Access (Arial Unicode MS) and in cases when subscripts or superscripts have to be used copy adequate characters from Character Map. It seems to work fine. Thanks for help Regards.

Hello, I have a question concerning formatting in a given table. I've started to create a table by manual inserting data in the coulmns. One of my data has to be formatted as subscript ( font has to be subscripted, e.g. B5) Is there a possibility of putting data above using subscript, if yes...

Thank you for help. I really appreciate it, Regards.

Thanks for this site I've just looked through( it is quite interesting), but I couldn't find anything that I can use. Maybe I overlooked something...?

Hello, Does anybody know how to write a macro (or function, whatever) that will be accurate for counting the number of cells of specified colour (let's say red ones) and containing specified text e.g. "BM". Cells in my sheet are white or red, while there is three various texts: "BM", "WA"...

Ok, Let me describe you in details what I wanted to do. I have a table with over 2000 rows. In each rows in the my_avg field is placed a number that represents average of sth. These all values are going to be put in the adequate range ( 4 ranGes). I'd like to create a form where 4 buttons are...

Hi, I have a question... Is it possible to use the following command with the "between" operator: DoCmd.RunSQL "UPDATE points SET my_avg = between 4,05 and 4,28" I've tried put this in the form as a subclick but it doesn't work. Can I use operators in such commands? If not, what is the best...

Thank you very much, it works perfectly. Thanks again.

No, there is always single occurrence of "Iii" or "Ii" substring in a given record. Additionally, one record contains or "Ii" or "Iii" substring or such one that doesn't need to be changed at all. There is no case when one record contains both "Ii" and "Iii" and when it contains multiple cases...