Search results

how bout if i use date() insteaed of key-in date manually?

if i use Date() as default value at my field, can i save it? i mean it not change when next day come for some record. coz i want to use today's date as default date to some record. when next day come, date for that recoerd still at yesterday's date.. or there have any other way to do it? TQ

error, cant trace, how to fix it? Private Sub cmd_calculate_Click() Dim daoRS As DAO.Recordset Dim strRS As String strRS = _ "SELECT COUNT(*) AS [Counter], " & _ " AVG(NZ([A1-1],0)) AS [Aa11], AVG(NZ([A1-2],0)) AS [Aa12], AVG(NZ([A1-3],0)) AS [Aa13], AVG(NZ([A1-4],0)) AS...

any1 know how? to get value from each row record. instead of this: rsSurvey.Fields("SalesmanName").Value TQ

i got new coding.. seems ok but stuck wit parameter error.. any1 can help? Private Sub cmd_calculate_Click() Dim daoRS As DAO.Recordset Dim strRS As String strRS = _ "SELECT COUNT(*) AS [Counter], " & _ " AVG(NZ([A1],0)) AS [Aaa1], AVG(NZ([A2],0)) AS [Aaa2], " & _ "...

yup, i need to search data wit same name, to add, then devide it in then end of month, that y i use to serach name and month

wow.. thanks for helping... yeah,i meed to learn more bout efficient and effetive coding... i try now..ill give th result later..

thanks for reply robert.. ok.. so how do i change my code toa make condition works and how to get value from query... thanks

plz refer to this link... http://www.access-programmers.co.uk/forums/showthread.php?t=107692 TQ

hi there.. i make simple system to make calculation in the end of each month bout point that car salesman from customer bout our their service i make cmd button to calculate where criteria (by salesman name and month) based on combo box then the result (calculation) return to box.. i make 2...

urgh... so, do u guys mean make Excel as data storage very risky? is it true that u need to re-make Access table from fresh if u want to change, insert,delete table in excel?... OMG...:eek:

as i know, i can import data from excel. but is it possible to make data permanently at excel? i mean Access as a system n excel as data storer.. if possible plz tell me how... thanks

nice..thanks but how to make it calculate depend on checkbox? like this: Current date - Hired date, when check box not checked Resinged date - Hired Date, when check box was checked.. any here have an idea?

i'm making form from query. but all i need to do is calculate days worked (TimeService) either worker still working or resigned. i want to know is it possible to make it condition like it to query? if not can u tell me the other way?

woah... err...right bottom...LOL

so, how bout this... 1 customer can buy many parts at once... and 1 part can be bought by many customers.. at my relation that i create , only part have many customer but not for customer....help me plz..

can i post link to give example that i get from other site? http://www.fonts....tm#accessvba

can u tell me at where to use this?

can i change date format that contain day, month, and year to month and year only.. i try change at fromat at porperties, but it change back into dd/mm/yy at combo box.. this is bcoz i want to filter up my subform that contain parts that purchased by customer by month.. thanks..

thanks..it works..but only 1 data per clickin.i mean, when i click some date, it only shows 1 data instead many of data had same date... how bout i want Subfrom list down that criteria selected from Cbo...