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

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.

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

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