Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by MisterEkted

  1. MisterEkted

    setting a check box in a different table

    I have an invoice form (based on an "invoices" table) where I can select from a list of completed jobs from a "jobs" table. The "jobs" table has a check box "job invoiced?" that I would like to set to "yes" when the "print invoice" event happens.
  2. MisterEkted

    subsubform record indicators problem

    Geesh. OK, I got it. Somehow the "data entry" property of the sub sub form was set to 'yes', and I should have had it set to 'no'. That seems backwards but I compared to to the main form and sub and they were set to 'no' so I changed it and it works. Thank you very much for your efforts. This...
  3. MisterEkted

    subsubform record indicators problem

    Dhookom, thank you for that suggestion. I changed it and put it in the command button onclick event that makes the subform visible. No change. I will keep trying other things.
  4. MisterEkted

    subsubform record indicators problem

    Well, In the OnLoad event of the sub-subform I typed me.form.requery, and that did not do it. I don't think it is a requery problem but I am not sure. I noticed something else after my initial post...Even if the sub sub stays visible and I change records in either one of the parent forms, the...
  5. MisterEkted

    subsubform record indicators problem

    Hi, I have a form-subform-subform situation. The sub-subform has a command button to hide it when it is not needed. When I hide and then re-show it, the sub-subform record indicators (or navigation buttons as they are called) do not show that there are any records in the recordset. The records...
  6. MisterEkted

    Access Subform Question

    I did not create a relationship per se. I created a subform on a tab control of a main form. The subform wizard asked me if I wanted to link parent/child fields. The subform records that are displayed change as the main form record is changed, of course. What I am trying to do is to occasionally...
  7. MisterEkted

    Access Subform Question

    I am wondering how (or where) Access links the parent/child fields in form/subforms. I would like to re-direct a subform record to be related to a different form record. Is this possible?
  8. MisterEkted

    form only shows all records after sort accending/decending

    I have a problem with a form. When I open the form, the record selectors show '1 of 1' records. There are several records in the table, but only after I click one of the sort buttons does it say '1 of 235' records. I originally had it working otherwise.
  9. MisterEkted

    Unique, yet 'private' incremental numbers

    Thank you very much for your suggestions. The first obviously is longer. So I will try the second one first. The suggestion about creating a table is a little vague to me but I will try to fill in the holes. -Kerry
  10. MisterEkted

    Unique, yet 'private' incremental numbers

    I am still learning Access. Addictive it is. I want to create auto-incrementing estimate and invoice numbers so that the customer does not know how many others I am making. My thought was to use his ID number (188 for example) as a prefix like this: 188-0001 would be the first invoice for that...
See more

Part and Inventory Search

Back
Top