• I am creating a new home page for this site, where the focus will be on directing people to the forums. If you would like to provide a testimonial, I would be most grateful. The thread where this is discussed can be found here: Seeking Testimonials Alternatively, just private message me.

Search results

  1. M

    Question Form not displaying information

    Check VISIBLE properties in DETAIL of this form.
  2. M

    Question Form not displaying information

    Send a short example of your mdb (access 2000 or 2002-2003), and say what is the problem.
  3. M

    Question Form not displaying information

    Check the properties VISIBLE (for every field). It must be YES.
  4. M

    Question Form not displaying information

    As I can understand you, in this form put DATA ENTRY = No (properties).
  5. M

    Date filter

    Look at "DemoStartDateEndDateA20022003.mdb" (attachment, zip). Look at Table, Query, Form. Open Form1 and try. Adapt it in your mdb.
  6. M

    Need Help with Copy Record button

    You don't need the same data in the table. It means that your tables not normalized wel. Learn something about DATABASE NORMALIZATION.
  7. M

    Go to New record in subform

    Did you put the code in "SUB FORM_CURRENT", (instead of "Sub Form_ Load"), in subform ?? Look at attachment, Access help (word, zip).
  8. M

    Painful InputMasks

    Put blank i INPUT MASK properties, and put NOW in DEFAULT VALUE properties. For that field i the table DATA TYPE put DATE/TIME, in Format properties put GENERAL DATE.
  9. M

    A couple of simple issues (I can't solve)

    Send a short example of your MDB, (Access2000 or 2002-2003), and say what you want to do, (what is the problem).
  10. M

    Go to New record in subform

    Look at "DemoSubNRecordA2000.mdb" (attachment, zip). Open frmMAIN and see. Put it "ON CURRENT" event (instead "ON LOAD"). Look at VBA.
  11. M

    Write data to tables

    Try to do this via query, (append query, or update query).
  12. M

    The Solution to passing a parameter from one form to another

    Maybe your husband is a genius, but he have to learn more about Access. Look at "Demo2FormsA20022003.mdb, (attachment, zip). Open Form1 and try. Look at VBA, (Form1, Form2, Report1).
  13. M

    combining two data sources into a combo box

    I think you need something like "DemoTwoDataA20022003.mdb", (attachment, zip). Look at Table, Form. Open Form1 and see.
  14. M

    Incorrect display of data in continuous form.

    Send a short example of your MDB, (access 2000 or 2002-2003), and say what you want to do.
  15. M

    "Go to" entry box?

    My mistake, it is Access2000 (not Access 2002-2003), sorry.
  16. M

    "Go to" entry box?

    OK, I know what you want. I thought you knew a Primary key, or any other data in record. Look at "DemoGoToRecordA20022003, (attachment, zip). Open Form and try. Look at VBA. In the table you have got 10 records. When the form open the first record is on the form.
  17. M

    Running Sum For Selected Records

    It must be you make a mistake somewhere.
  18. M

    "Go to" entry box?

    I think you need something like "DemoFindA2002.mdb" (attachment, zip). Open frmForm1 and try. Look at VBA. Adapt it in your mdb.
  19. M

    Running Sum For Selected Records

    Look at "DemoRuningSumA20022003.mdb" (attachment, zip). Look at Tables (I added 1 record), Form1 (VBA), Query, Module1. Open Form1 and try. I made the first query only.
Top Bottom