Recent content by Jeffr.Lipton

Works just fine -- thanks!

I have a form with multiple pages/tabs (see attached). If I copy a button (or other control), it goes to the detail and appears on every page, even if I move it to a specific page. Is there a way to convert a control on the detail to a specific page?

I use queries as the data source for Forms, or if I need a query in multiple places. Inside my code, I almost always use SQL.

It worked once, then stopped working. GRRRR! I'm running this in db2, and "\\sce\workgroup\TDBU2\Grid Contracts\IT Applications\Production\True-Ups\FrontEnd\Create Action Items.accdb" is db1. After a bit of experimentation, this seems to work: DoCmd.DeleteObject acTable...

I figured it out: Dim appAccess As Access.Application dim sql_Clr_Table, sql_Insert as String 'clear local table sql_Clr_Table = "DELETE * FROM tblNew_Action_Items;" DoCmd.RunSQL (sql_Clr_Table) 'Create instance of Access Application object. Set appAccess =...

I have 2 databases that I want to have run the same module, and update local tables. db1: contains universal module db2: calls module in db1 to update local tables db3: calls module in db1 to update local tables This way, if I need to make a change to the module, I can just make the change in...

I've cleaned my cookies and we'll see how it works... What's the difference? "Please log in" indicates that I've been logged out (ie. "kicked out".

Every time I open a new tab, or go to new page, it seems like I'm logged out and need to sign back in comment. Wassssup with that???

"Use Themes" was introduced in 2010, but it doesn't transfer when you copy and paste a form. Since I sometimes make substantial changes to my test database and would like to just transfer the whole form to Production, I wrote the attached procedures.

I personally find the version with underscores easier to read, but I think it may be a matter of personal preference (albeit a weak one). That was NOT a real world example. strPath_Ext or strFile_Name are more likely examples. Your point about the role of underscore is well taken.

The latest version of Access strips important information (such as whether a Theme is used) when you copy and paste a form or control. In order to avoid this, I created a module that would let me save and load one or all of my forms. This way, if I make multiple changes in a form, I can save...

With the (hopefully obvious) exception of underscore. (I personally like sLots_Of_Tiny_Words to sLotsOfTinyWords -- if there is an advantage to the latter, other than length, please let me know.)

One way is to "cheat" -- build your table in Word, then copy and paste into your email Dim appword As Word.Application Dim doc As Word.Document Set appword = New Word.Application appword.Visible = True Set doc =...

If you are using multiple countries, you might want to use the one of the ISO 3166-1 codes (see https://en.wikipedia.org/wiki/ISO_3166-1 for more information, then have a seperate look-up table that links each country to its code. That way if a country changes its name, you only have to update...

I'll be trying this soon and will report my results.