Recent content by krazykaigh

Hi all, I am attaching a .jpeg of some Form - Subforms I am using. In the subform marked Specific Inheritances, there is a sub-subform called Prime Beneficiaries. In Prime Beneficiaries subform, there is a check box with the label "Alt". What I am trying to do is make sure if Alt is checked...

@PBaldy: Thanks, again. I finally just did the hidden field and referenced that. You know what I also realized was that I am using the Main forms. subform control's exit event. So even though it is the subform's info it is checking, I cannot use: Me.[Name of control on sbfm_One], because me...

Hi all, I have a subform (sbfm_One let's say) that has a subform on it (sbfm_One_A let's say) that will only be visible if you check a checkbox on the first sbfrm_One. Now when exiting the control for sbfm_One, if the checkbox is checked and nothing was entered on sbfm_One_A, that's a no no...

Re: Not understanding why Error 3021 is happening - SOLUTION FOUND @AccessMSSQL, Thanks for that suggestion. I am unsure if it works because I worked out the solution. I had: int_SPC_In_PrimeBene_No = Me.Recordset.[spc_Bene_ID] Somewhat like AccessMSSQL suggested, I removed the .Recordset...

Hi all, I need some (more) help. So I keep getting error 3021, and I honestly cannot figure out why. Here's the situation (attached views and text file with VB code): I have a table for Specific Inheritances (tbl_Specific_Inherit). This table is on a subform to the main form. Now the form has...

@Pat Hartman Thanks for that. It works for the most part... There are quirks, like the .setfocus throws an Error 2108, must save record before .setfocus may be used. So I just made .value = .oldvalue and that seems to help. I think I have to do something on .Lostfocus also for field...

@RainLover Based on this information, if Cat 13 was deleted and DMax was applied would it come back with Cat 13, again?

I am using Access 2007. I am designing db that inputs client information and outputs a Last Testament and Will as a word document. I have one section that takes specific bequests: I want my son, Jimmy Lastname to get my onyx bracelet. However if Jimmy fails to survive me then I want Markee...

pbaldy, thanks for the quick response. Now a question I am embarrassed to ask: I see from the link I should use the .mde for front-side and .mdb for backside. How does one create a .mde file as compared to a .mdb file? And I will plan on staying with Access 2007. (I didn't mention the version...

Hi all, I work at a NON PROFIT with a minimal budget (aren't they all). I am both the paralegal and the network administrator... but fortunately I am experienced in both... paralegaling more than networking, but I took db programming in college, and did networking as a "duty as assigned" in the...

Hi I am 47, a Paralegal by trade, a network Admin as an assigned duty, and a programmer by design! I started writing db code with DB3 from (?) Borland back in 1988. I have written dbs in Access and Oracle, but the last was over 5 years ago. So I have forgotten more than I remember... Now I am...