Search results

  1. P

    ActiveX Component ALERT!

    everytime i drag a command button, a combo box, a list box or a subform, an error displays informing ?"ActiveX component can't create object" . I already reinstalled my Office yet same thing happend. Obviously, it has something to do with objects that has accompanying wizards on it. I'm sure...
  2. P

    append query used by more than 1 form

    thanks pat, it helped a lot!
  3. P

    Get criteria from combo box

    i was really thankful that this thread has been posted coz i also encountered this kind of problem. but i wonder why the final criteria expression: [Forms]![FormName]![combo6].text wont work on mine. does it have to do with the type of action query? i'm using an append.
  4. P

    append query used by more than 1 form

    i thought i have browsed from the Help of Access that to specify the criteria of a query which is being used by more than 1 form is this way: (assuming the common control name of the forms is EmpID) [forms]![Empid] meaning, just ommit the form name. but it didn't work. instead it was being...
  5. P

    combo box: to control the navigation buttons

    I found the SOLUTION! First, add a combo box and when the wizard appears, choose 'Find a record on...' then just continue with the wizard. The problem that arises next is that when you load the form, the combo box is empty and the record displayed is the first record. To solve that, on the...
  6. P

    save a subform from another form

    whew! thanks for the idea pal but i have figured it out myself. i need to have another form because that new form is based from another table thought the type of data is quite similar. what i did was: 1. before the new form will be opened, from the subform the focus must be on the new...
  7. P

    combo box: to control the navigation buttons

    i got a form with a subform. from the main form, i have a combo box. if i change the value of the combo box, the entries in the subform would also change because this combo box is linked to a certain field in the subform. but... the record on the main form is altered. what i really want is...
  8. P

    Scanning Barcodes

    brad, hope you won't mind if i ask. what is 'keyboard wedge barcode scanner'? and are there other type of scanners?
  9. P

    save a subform from another form

    i got a form which has a subform. to add entries to the subform, another form will be opened. from the newly opened form, i can paste the current record. but the problem is i can only add up to 1 record only because the subform does not advance to a new record. i tried requerying the subform...
  10. P

    update table from a form.

    YES! thank u so much, brad. ur really a HEAVEN of a kind! (uh, what's that?!) if ur just here, i could have kissed you (just kidding). it was just i didn't really get everything that you are trying to point out and besides i didn't know much about action queries. but because of you,... i love...
  11. P

    update table from a form.

    so kind of u, brad. in fact, u gave me a chance to try to work on action queries. i tried doing ur advise but nothing happened even if the cascade update option is checked as well as the enforce referential integrity.
  12. P

    update table from a form.

    thanks sarah but it it didn't worked on mine. i tried revitalizing my original codes and followed your tips but it caused error/s. what i supposedly need is to update my Disposed Items table based on the values of the controls in my form which displayed an instance of my Purchased Items table...
  13. P

    Multiple records from one form!

    i don't think you need to access the VB code anymore. have you created the Relationship? if you did, then if you'll create the form using the wizard, automatically, it will update to the tables you have mentioned. well, based on my experience... it worked.
  14. P

    update table from a form.

    i'm viewing the data of the Purchased Items table from a certain form. i place a command button "Dispose" so that when i click it the current record will be deleted from the Purchased Items table and will placed in the Disposed Items table. Help me plezzzzzzzz!
  15. P

    change a value on a certain table but my form is based on a query

    whew! i've been going into circles and i didn't notice! thanks for your time. geee!
  16. P

    change a value on a certain table but my form is based on a query

    my database is all about keeping records of computers assigned to an employee as well as the number of computer units in a certain department. so everytime a new employee is assigned with a unit, the number of computer units in the department where the employee belongs increases. now, on my...
Back
Top Bottom