Search results

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

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.

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.

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

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

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

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

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

Hello, I've problem with REPLACE function. I'd like to use it for strings or substrings that are placed in the column XYZ. If there is substring : "Iii" then I'd like it to be changed with "III", if there is substring "Ii" then my goal is to receive "II". Could you help me in writing...