Search results

  1. M

    TabControl.Value from within a subform on the Tab Control?

    Send a short example of your MDB, (Access2000 or 2002-2003).
  2. M

    replace problem

    I suggest to use an UPDATE QUERY. Look at "DemoReplace1000A2000.mdb" (attachment, zip). Look at Table1, Query1. Run Query1, before make a copy of your table.
  3. M

    Question How to link two textboxes in different forms together?

    I think you need something like "DemoFormAFormBA2000.mdb" (attachment, zip). Open Form1. Select something in ListBox and click on the button "Open Form2". Look at VBA. Look at Table1, Query1. Adapt it in your mdb.
  4. M

    Range period from comboboxes to filter subform

    1) What is your table look. Send some records. 2) Is cboStartPeriod or cboStartPeriode, cboEndPeriod or cboEndPeriode ??
  5. M

    After cycling through records with form return to main form

    On the every form there are a NAVIGATION BUTTONS.
  6. M

    IF statements to Open Forms (Access 2003)

    If your RELATIONSHIPS is CLIENTS on side 1 and APPLICATIONS on side many, in that case you must enter CLIENTS before APPLICATIONS record. In that case the CLIENTS form is a MainForm, and APPLICATIONS form is a subform. If your RELATIONSHIPS is APPLICATIONS on side 1 and CLIENTS on side many, in...
  7. M

    IF statements to Open Forms (Access 2003)

    What are your tables look ? What are the PRIMARY KEYS in this tables ? What is the FOREIGN KEY in Clas data ? What is the RELATIONSHIPS ?
  8. M

    How to select all records?

    Look at "DemoDeleteRecA2000.mdb" (attachment, zip). Look at Table1, Form1. Open Form1 and try.
  9. M

    Set subform to last record

    Hello missinglinq !! In the first theread Big Pat said. "When I open the form...". If he want to move to subsequent records on the MainForm, then he have to enjoy herself with VBA. (he have to know what he want to do).
  10. M

    Set subform to last record

    In subform, Sub Form_Load DoCmd.GoToRecord,,acLast
  11. M

    Creating a search facility

    What are the PRIMARY KEYS (in your tables) ??? What are the FOREIGN KEYS ??? What is the RELATIONSHIPS ??? Where is the field STAF ID ???
  12. M

    Creating a search facility

    Look at attachment (word, zip). Access help about FILTER BY FORM.
  13. M

    Creating a search facility

    Try to do it via FILTER BY FORM (ikon).
  14. M

    combo box linked to sub form

    Here is a word (attachment, zip).
  15. M

    combo box linked to sub form

    Look at my "Demo" a new one. Look at Word "SubormSingle", (below). Open a "frmRacesSubormSingle" and try.
  16. M

    combo box linked to sub form

    I think you need something like "Demo" a new one. Open "frmAthleteMain" and try. I added a combo box on the Top of the form. Look at VBA.
  17. M

    method or or data member not found

    Check in your form, have you got the field with the NAME Combo1.
  18. M

    Tabs and Relationships

    I don't know your task, I can't to say anything. Maybe you need mor tables, (and more subforms). Learn something about DATABASE NORMALIZATION.
  19. M

    data entry 3tables 1 form

    Look at "DemoAthleteA2000.mdb" (attachment, zip). Look at Tables, Forms, Relationships. Look at LINK CHILD FIELDS and LINK MASTER FIELDS properties in the both subforms. I entered 1 record in the frmAthleteMain (tblAthlete), and 2 records in both subforms. Open frmAthleteMain and try to enter...
  20. M

    Tabs and Relationships

    Look at "DemoClientOrdersA2002.mdb" (attachment, zip). Look at Tables, Forms, Relationships. Look at LINK CHILD FIELDS and LINK MASTER FIELDS properties. Open MainFormClient and try. Try to enter a new Clinet record, and a new Order Record.
Back
Top Bottom