Search results

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!

I have an Access database that I have running on the server. I've compiled it made it into an MDE file. When I run it, everything appears to be working fine. I created my own log-in form. However, when I split it, I will often get this error when clicking on the log in form: The...

I have an Access front-end linked to an Oracle (7.3) database. I can run a report that is generated by a query I have saved. However, when I open the query itself, I get the "ODBC--Call failed" error. I set the ODBC TimeOut in the query's property to 0 and I set the ODBC's QueryTimeOut...

Thanks for that post Dave. That was the exact same problem we were experiencing. Here's the technet page you refered to. http://support.microsoft.com/default.aspx?scid=kb;en-us;202171 This solution did work for us. You have to make sure that the [C]reate right is set for all users so they...

I have developed an Access application as a front-end to an Oracle back-end. I'm trying to create an MDE file with the Access MDB file but it hangs every single time until I manually force it to close. (The MDB file has been "compacted & repaired", and the coding successfully compiles.) Has...

Dynamically Changing Form Style Design This is a very effective method that I have used again and again, in changing the form style design and making them all uniform in format. This will go through each form (or by altering the conditional, to go to selected forms) and alter form properties...