Recent content by radur

I have a listbox populated with a query (concatenated last and first names with a bound ID field that's invisible). How would be possible to search the names in listbox by more than the first letter of the name. As it stands now, if you type Smith, the focus goes to the last letter I' m typing...

Hello! I want to create a form (that contains records from a table) in which I can to navigate between records by searching data from my keyboard. Example: I have records with person' s names (Alex, Raoul, etc). If I type "ra" on my keyboard I want to select Raoul' s name, so on and so forth...

I want to see all the names that fits to the page selecting the name while I'm typing

Hello! I want to create a form (that contains records from a table) in which I can to navigate between records by searching data from my keyboard. Example: I have records with person' s names (Alex, Raoul, etc). If I type "ra" on my keyboard I want to select Raoul' s name, so on and so forth...

Hello. How can I get the age in years, month and days, between date of birth and current date. In excel is like ym, md, but in acces it doesn' t work. Thank you!

First, I want to thank you for your answers and support. Second, I cannot use what you are telling me because: - in my tbl I have 200 records; - as I said the two columns of dates are an interval = a month - the "value" column can be renamed and is a salary (the column is formed by summing many...

The dates from tbl is a period 01/01/2011 - 31/01/2011 = january The number after dates is a value I want the qry to group dates and showing, if the value is the same, the full period, without grouping dates if the value is changing, and I showed the result that I want to see after I run the qry...

This is my table ID Data1 Data 2 Value 1 01/01/2011 31/01/2011 200 2 01/02/2011 28/02/2011 200 3 01/03/2011 31/03/2011 500 4 01/04/2011 30/04/2011 200 5 01/05/2011 31/05/2011 400 6 01/06/2011 30/06/2011...