Search results for query: *

My country use Date format dd/mm/yy but default in Microsoft Access use format mm/dd/yy. I want to let user enter data format dd/mm/yy. I already changed Date format in Regional Settings in Control Panel to dd/mm/yy. When I enters Date which day more than 12, It shows correct Date (dd/mm/yy...

Thanks for your comment. I need to export from table, what should I do? thanks again.

Hello, I have a filed in table which data type is Number, Field size is Double, Format is Fix, Decimal is 2. It shows 10.00 in the table. When, I export this table to text file by module, It shows only 10. How can I export to 10.00 By the way, I can change data type to Currency. However, I...

Hello Question 1 In module, how can I write module to run update query that need to pop up parameter dialog box to get data from user? Question 2 How can I write module to run macro? thanks.

Hello, I am new. In Access 97, it has recordset and recordsets (with "s"). What is different? Query and queries bla..... thanks.

I have two fields (MyDate and MyTime). Both are Date/Time data type. I need to export to text file. After I export, It have default value in the field MyDate and MyTime Example MyDate, MyTime 6/20/01,10:28 After I export, It shows 6/20/01 0:00:00, 12/30/99 10:28:00 Is there any way to export...

I had a macro to run my work. However, I would like to have this macro to run task automatically at 6:00 AM. I think I need to write the module. What is the code to do this? thank for your help.

not good feedback but it is perfect feedback. thank you for your advice. appreciate.

I want to buy RAM however could you they me what is 32x64 or 32x72 mean? thanks. ----------- PC-133 256MB 32X64-7 168-PIN MODULE PC-133 256 Meg Ram 32x64 - 7 nanseconds 168 Pin Module ----------- PC-133 256MB 32X72-7 168-PIN MODULE ECC PC-133 256 Meg Ram ECC 32x72 - 7 nanseconds 168...

I have a Form which you can choose USA. or International. Then customer will choose state or some countries. (That form shows all states and some countries). I would like to disable other countries (gray options) if they select USA. Also, if they select Internaional, all states will show gray...

Thank you for your answer. It seems to be my question is not clear enough. QBE allows me to group by date and Sum. It lets me group by only day. Also, I can group by month if my criteria has >=01/01/01 and <02/01/01. However, It let me group only one month for each query. So, If I need to group...

I have a table which has field and Data below: TransactionNo SellDate Product Amount 001 01/01/01 A 5 002 01/01/01 A 6 003 01/02/01 B 7 004 02/04/01 A 3 005 02/05/01 C 8 I would like to create a report which group by MONTH, PRODUCT and show sum of Amount sold. What should I do? I tried to...