Search results

  1. M

    Linking a form to another form

    You have got 2 tables, "tblDocument", and "tblClient". Populate RELATIONSHIPS (tblClient : tblDocument, 1: more). Make a Main Form on tblClient, and form on tblDocument. Thise second form put in Main Form as a SUBFORM. Link them via LINK CHILD FIELDS, and LINK MASTER FIELDS properties (in...
  2. M

    Please Help - problem with adding new records to Subform

    Send a short example of your MDB, (Access 2000 or Access 2002-2003), and tell what you want to do.
  3. M

    SQL to retrieve records where primary key field is date in mmmm yyyy format (2007)

    The advice is: Send some records from your table.
  4. M

    Code to open report with current month data only

    Look at "DemoCurrentMonthReportA2003.mdb" (attachment, zip). Look at Table1, Query1, Form1, Report1. Open form and try. But, if you want year 2012 only, you have to incluede the year in query, and in form.
  5. M

    I think I need a subform

    Yes, it is O.K. Make 2 tables (ORDER table with Primary key ORDER, and PAYMENT table with Primary key INVOICE). In th PAYMENT table put the field ORDERsub (Foreign key). Make a RELATIONSHIPS (ORDER table : PAYMENT table 1: more) via ORDER field and ORDERsub field. Make 2 forms on 2 tables...
  6. M

    Show calculated query field into text control on form?

    Try to do this with DLOOKUP function.
  7. M

    Unique ID

    What is the PRIMARY KEY in your table ??
  8. M

    Convert Binary to Number

    Look at "DemoBinaryA2003.mdb" (attachment, zip). Look at Table, Forms (VBA), Queries, Module1. Open MainForm and try. I think it is what you want, adapt it in your mdb. As SPIKEPL said, INDEX and SIZE are reserved words in Access.
  9. M

    Apply a filter by date not workign

    Send a short example of your table, or your mdb. (Access 2000, or 2002-2003), and tell what your want to do.
  10. M

    Help needed

    As I can understand you, you don't need the same data in two tables, (PRODUCT NAME). I suggest to make 2 forms. Main form on the "Product" table, and subform on "Inspection records" table. Linke them via "PRODUCT CODE" (1 > more). In that case you dont need routine to retrieve product name from...
  11. M

    queries on check fields

    Look at "DemoCustomersOrderA2003.mdb" (attachment, zip). Look at Tables, Relationships, Query. Open query and try. If You want to see a customers who have no orders, you must to change a RELATIONSHIPS IN THE QUERY. Put "Join properties 2", "Inculude ALL records from "Customers" and only those...
  12. M

    Filter on query

    Look at "criteria" in query1.
  13. M

    Filter on query

    Look at "DemoFilterQueryA2003.mdb (attachment, zip). Open Form1 and try. Adapt it in your mdb.
  14. M

    Data Entry Check

    My congratulation !
  15. M

    Data Entry Check

    Send a short example of your mdb (access 2000 or 2002-2003), and tell what you want to do.
  16. M

    Subform not refreshing on when deleting a record.

    I dont know your mdb, but I think you don't need Subform B. Put all in Subform A.
  17. M

    Data Entry Check

    If the field "AssessmentDate" is a DATE field, in that case you must write a VBA differently. Look at Demo a new one (attachment, zip). Open form and try. What VBA you have got in the Current event ???
  18. M

    Data Entry Check

    Look at "DemoForm2A2000.mdb" (attachment, zip). Open Form and try to enter a new record, and try to skip a field F1. F1 field is Required, (look at Table1 F1 field properties). Look at VBA, adapt it in your mdb.
  19. M

    Enter Parameter Value

    As I can understand you, you have to have something in Combo9, (Antique or Reproduction). It would be better to send a short example of your "mdb" (Access 2000 or 2002-2003), and tell what you want to do.
  20. M

    Open Subform From Yes/No

    Look at "DemoSubFormA2002.mdb (attachment, zip). Open "frmMAIN" and try. Adapt it as you need.
Back
Top Bottom