Search results

  1. N

    sum data BY DAY!?

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

    exporting access table to excel problem

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

    Filter record by month and year!?

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

    Get data according to 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...
  5. N

    Query problem... =(

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

    make custom switchboard?

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

    Flickering Label

    :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...
  8. N

    unlock a locked database?

    hello everyone, i am making a database in MS Access 2003 on WinXP. when i publish this database to users in my office, i will lock it, hiding the table and all. my question is, is there a way to unlock it so that i can do maintenance and maybe improvements later on? if yes, how? helps are very...
  9. N

    Unassociated label blinks on mouse over!?

    i am using MS Access 2003 on WinXP. i made this form, and for the instructions, i put a label. this label has an error, which told me that it was an unassociated label. i just ignore this error and everything is fine except that when i view that form in form view, whenever my mouse pointer is...
  10. N

    many table, one form?

    undefinedundefinedundefinedhi, i'm a newbie using MS Access 2003 on Windows XP. i am developing a database containing data obtained from different states, and in my case, i have 4 states; so the data will be in 4 different tables. to present the data to end-user, i made a form, displaying all...
Back
Top Bottom