Search results

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...

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...

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...

@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...

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...

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...

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

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...

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

@CJ_London Thank you! Appreciate the help.

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...

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

@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.

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

@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?

@Pat Hartman the link works. I'm very excited to watch this in full tonight. The before events are not something I ever really considered, but I will now. Thank you, again!

@Pat Hartman you must be a mind reader - I did need the ability to pass the fk to more than a single record. Your solution is so much better than the work around I came up with. THANK YOU!

@Pat Hartman I used the ID field from the record selected where "[fkDetails]=" & [IDDetails]. @arnelgp Thank you for the code. I will try it out, but I found another solution with SetTempVar set on click on first form and SetProperty on load of second form which opened in Add Data Mode. I...

@The_Doc_Man THANK YOU! I appreciate the help.

Hi. I have a form which opens in edit mode. The form has a textbox fkDetails. I want to add a new record, and copy the fkDetails value (number) to the new record via macro or vba tied to a button. The prior record from which I am copying may or may not be the last record in the table. Any...