Recent content by dungstar

This CAN be done. I've just started to search information on this, and I seem to find that most of the response say that an EXE cannot be created from an Access MDB/MDE file. BUT... I am supporting several Access front-ends that are executed from an EXE file WITH a custom icon. Trying to...

As an alternative that may require a bit of work, you could use 2 forms that look like one. Have button on both forms that toggles (or rather, close one and open the other) between the two. One form would be bound to a recordset, the other unbound and used as a "Query By Form" (you can try to...

svuille - to automatically apply filter, you can try: DoCmd.RunCommand acCmdApplyFilterSort However, it appears that in Filter by Form mode, controls are disabled, with the exception of the "input"-able controls that is used to query the recordset, so you may not get a chance to use it as...

Turn on Filter By Form / Enabled Controls during Filter By Form? You can use this code to have your user get into filter by form mode: DoCmd.RunCommand acCmdFilterByForm I'm wondering if you can add a button to Apply the Filter on the form that is not disabled during Filter By Form mode...

Is there a way to apply this functionality to a subform (while using it at the main form level, using the same module) as well? (Since Screen.Active form calls the main form.)

Yes, I did. It's a spectacular piece of work. I'm trying to model after that, which is what I've ended up here. (Major kudos to Ghudson for that!!!)

My objective is to output an audit trail to a text box that records the old and new values (of all changes) that is comprehensible to the user. On my form, I have text boxes as well as combo boxes (i.e., the text boxes are fields from the main table and the combo boxes are foreign key fields...

Right now, I am calling the function on the Form_BeforeUpdate event, actually. Sorry about the confusion. The OldValue property works. But I'm trying to get the OldValue of a column of the combo box that is not the bound column. Cbo.Value has the same result as Cbo.Column(0) because...

SJ - Sorry, I made an error. I had Desc and ID switched around. Should read: What I'm trying to do is output the old value that was displayed in the combo box, i.e. column(1)'s old value (Desc), not column(0)'s (ID). To answer your question of when: After the record is updated. Example...

I was hoping there's some flexibility in the OldValue property that I could take advantage of, so I could use a universal function for all Combo Boxes using For Each acComboBox rather than write an idividual code for each one. If I did this however, instead of combo box event, I may have to use...

I have a bound form, Frm, bound to tblMain. I have a combo box, Cbo, bound by column(0), a foreign key, to tblMain. The Cbo's RowSource comes from table tblCbo, and populates 2 columns on the form: tblCbo.ID, tblCbo.Desc. First column, tblCbo.ID is hidden. What I'm trying to do is output...

I could be wrong, but I think it's DoCmd.OpenQuery "<QueryName>" alternatively DoCmd.RunSQL "<SQL Statement>"

Thanks, ByteMyzer. My objective is to have the source image be an embedded image rather than a linked image. All reports that require the logo will link to the embedded image. The solution you provided still requires that the source image be linked. Is there a way to link to an embedded image?

I thought this would be pretty simple, but I cannot figure out how and wasn't able find the solution here or anyway. I have a source form. (I can resort to having a Table with OLE Object if I must, but prefer not to.) On this source form I wish to include different things such as company...

Are you referring to the FE & BE when you say both DB's or the split and unsplit DBs? I'm not quite sure which reference section you are referring to. Could you please clarify? Thank you!