Recent content by jbrumbau

Apparently if you have Access 2007, customizing right click menus (Shortcut Menu) either involves code, or you have to open it in Access 2003 and customize the menu from there. You can then pick the shortcut menu for Current Database or for Form Properties. In Access 2003, you go to View...

I found this out the hard way, apparently InStr doesn't work in any SQL statements. You can only use "Like" or "Not Like", and only directly from a field, not a derivation of the field such as UCase$([FieldName]). Another option, if you absolutely must get a character position, is to reroute...

Great news, I found a way to get it working with tabular view. Apparently, DoCmd.RunCommand acCmdPrint still works. So instead of opening the form in acPreview mode, just tell it to directly print.

I actually have the same issue right now, though for me, it was working in Access 2010 until I changed the window layout from popup windows to tabs. With popup windows, Docmd.OpenForm formName, acPreview works just fine. When I changed it to tabs, I got the same error you got, Error 3270 -...

tmort, I know this is years later but this is to help other users out as I had problems finding the answer. Here's the code I used that worked: Function SendOutlookEmail(ByRef olApp As Object, ByRef subject As String, ByRef toRecip() As String, ByRef ccRecip() As String, ByRef bodyText As...

I had the same error as well but with a different cause. My query had a reference to another form ([Forms]!frmLogin!txt...), which apparently gives JET fits. The solution is to use the following code: Function removeFormRefs(ByRef qryName As String) As QueryDef Dim tempDB As Database...

Hello, I searched everywhere for the answer to this too and finally found something, so I'm posting on here to help everyone else out. I was trying to pass a recordset as an optional parameter to a function. Here is what I did to get it to work: Sub setupTable(..., Optional ByRef rsExist As...