Recent content by TB11

  1. T

    Gaps in records

    Gosh I am sorry. I didn't mean to make this difficult for everyone because I was not clear in my question. The gap would occur between the EndNumb not equaling the BegNumb on the next record, and if these numbers do not equal there is what I am guessing is a gap, and the data entry must be...
  2. T

    Gaps in records

    My apologies for not being clearer. The gaps are not tied to an ID field or when a record is deleted, but rather the BegNumb and EndNumb are from data entry. The gaps may arise because the data entry has a typo, which would result in a gap or some other human error. I already have calculated...
  3. T

    Gaps in records

    Hi All. I'm stuck on how to find gaps in records. (I know there have been other threads on this topic, but I am just not getting it, sorry.) I really don't want to have to manually go line by line to find any gaps. In my table I have a BegNumb and EndNumb. I have done a query to calculate the...
  4. T

    DB behavior is bizarre

    @CJ_London I know I should not work direct in a table, but I slip into direct table data entry once in awhile. This DB has been weird since day 1. To my knowledge I have no timers or special send keys, and I only use a few send keys in Access (select all, copy, paste and that's it). Thank...
  5. T

    DB behavior is bizarre

    One of by DB's is doing the following: in a form or table, sometimes when I am adding records in a short text field, the cursor is not acting normal. If I change part of the text in the field, the cursor jumps around, and letters that I am not trying to delete get deleted or moved to a new place...
  6. T

    OpenArgs confusion

    Hi. I need to pass the IDOrder from the frmOrder to a new form frmOrderDetails, connected with foreign key fkOrder. Typically, frmOrderDetails will be used for adding new records. So I am confused as to what the code should be for both the command button on frmOrder and the On Loan event code...
  7. T

    VBA OpenArgs for On Open (or On Load) Event for Report

    @Gasman dang you are right, I was doing that. I appreciate the help. Obviously, I should have stepped back before posting. Sorry about that.
  8. T

    VBA OpenArgs for On Open (or On Load) Event for Report

    Hi. I am trying to pass the openargs to a report On Open (or on load event, I don't know which would be preferred). I have the code figured out (with prior help of Access World Forums) for the on click event of the form for openargs. Now, I've been trying to figure out the On Open/On Load code...
  9. T

    VBA to open specific form/report based on combo box selection

    @arnelgp @Gasman With your help, I got what I needed. THANK YOU BOTH! :)
  10. T

    VBA to open specific form/report based on combo box selection

    @CJ_London Thank you! Appreciate the help.
  11. T

    VBA to open specific form/report based on combo box selection

    Hi. I would like to select a specific form or report, based on a combo box and then have that form or report opened on a click event. I have a FormName table that lists forms and reports for that a user can do data entry or view the form/report. I have a FormMain that has cboFormName combo...
  12. T

    Form; pass value of text box from prior record to add new record

    @Pat Hartman Love, love, love BeforeUpdate Event. You certainly showed the way to avoid bad data being saved. THANK YOU.
  13. T

    Form; pass value of text box from prior record to add new record

    @Pat Hartman What an awesome video for the BeforeUpdate event, and why it should be used. You were right, that is exactly where I need to put my code to pass thru the fk.
  14. T

    Form; pass value of text box from prior record to add new record

    @Pat Hartman I'll keep my eyes open for it.
  15. T

    Form; pass value of text box from prior record to add new record

    @Pat Hartman popcorns not my thing, but how about apple cider donuts? is there a way I can get a notification when the next episode comes out?
Back
Top Bottom