Search results

thanx a lot maxmangion! that was so obvious! hehehe :D this forum ROCKS!!!

i've managed to get the "total" field. every field has "group by" as default, but there is no selection as to "group by day". where can i find it? also, the sum selection does not return a total of values! am i doing it wrong? can u please point out where i've done wrong? :confused:

hello gurus... pliz help me... i have datas that will be updated HOURLY, example: ===TIME=== ===DATA=== Jan 1, 2005 1.00pm 1000 Jan 1, 2005 2.00pm 2000 Jan 1, 2005 3.00pm 3000 Feb 3, 2005 6.00am...

i think there's a bug in access 2003. i made a db using access 2003, and whenever mouse pointer hover over labels, the form flickers. when the db is opened on other version of access it is fine though... tsk... tsk...

hi all... i made a database that keeps records in access table. however, on that form there is a button which have this code: Private Sub Command50_Click() DoCmd.OpenTable "TxPerlis" SendKeys "%(TLA)", False SendKeys "Yes", False End Sub the result is, when a user clicks this button, the...

one more thing, :D is there any way i can set the record source from a combo box? i would like to have a combo box that contains a list of selection, and when the user updates the combo box, i want the subform to have a new record source as selected. can anybody help me out? thanx in advance... :)

Thanks Mile-O-Phile!!! i have been finding this answer for like 2 days now!!! THANX A MILLION!!!

i'm sorry to bother u again skea, but i can't seem to get anything right here. thanx anyway... :confused:

i put the code in "afterupdate" event of my combo box, i changed 'mycombobox' in your code to my combobox's name. but when it is run, there are debug errors. hmm... is there anything i should change? thanx in advance... i am really bad at this... :(

erm, i'm sorry, but i can't seem to understand what ur telling me... i'm kinda new here actually :o can u please break it down for me?

mkkashif, can u show me how u solved this problem?

hello everyone, i need serious help here. (pliz view the attached image). i am building a form that is used everyday to enter data. bcoz of this, there will be loads of data, so i want the form to view the data monthly and yearly, so that users can view data they want on that particular month...

i'm building a database to manage data that is updated daily. data will be viewed monthly though, summed and averaged that is. i used 1 table to store all the data. but then, on the form to view the data, i am clueless. in the table, the field 'date' used access standard 'date&time' mask. can a...

hi DBL =) can i have it too? =)

errmm, sorry, but i have already given values to the combo box. and bcoz of the "me.requery" event set on 'after update', whenever i change the value of combo box, the query does rerun, but there is this "insert parameter value" popup msg. can't access just take the value in the combo box and...

hi... i have a table that contains data from 4 different states, user will want to view it according to state, so i made "[forms]![MyForm]![StateField]", then i made a new form based on this query. problem is, when the form is opened, "enter parameter value" pops up, and user has to enter...

:) THANX A LOT SJMcAbney!!! ur help is very much appreciated! now i can start doing my own custom form!!! YAY!!! :D

hello there. i am currently using ms access 2003 default switchboard as a menu to go to forms. question is, how can i create my own custom switchboard? i'm a newbie to access, so is it possible to use buttons that will call certain form and at the same time closes the previous form? how is that...

:confused: i am using MS Access 2003 on WinXP. i have attached my sample database. when viewed in form view, notice that the form will flicker on mouse over. why is this happening? is there a solution to solve this annoying problem? please explain in details how i can solve this problem as i am...

so sorry but i can't seem to solve this problem!!! can anybody please guide me step by step? i am using ms access 2003 on winxp.