Search results

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

@MajP THANK YOU! I can't even guess how many hours you saved me.

@The_Doc_Man I'm trying categorize thousands of records based on the file names.

Sorry about that. The FileNameTbl with the following results:, with fk for both the color and texture fields from the FileNameSnipetsTbl FileNameTbl: IDFileName, FileName, fkTexture, fkColor 1, BackgroundTextureRoughBlack , 2, 2 2, YellowSmoothTextureAbstract, 3, 4 FileNameSnipetsTbl...

* I meant update not append (oops)

My ultimate goal is to reach a point where I can do an append query based on the results of the query. Tables invovled FileNameTbl: IDFileName, FileName 1 BackgroundTextureRoughBlack 2 YellowSmoothTextureAbstract FileNameSnipetsTbl: IDSnipet, Snipet 1 Black 2 Rough 3 Smooth 4 Yellow 5 Texture...

Sorry. Page =1 Record 1, New Page = Add new record