Recent content by newfrontiers

Hello. I have migrated over to MS Access 2007 from MS Access 2003. I had a custom toolbar in 2003 which appears under the Add-In Tab in the Ribbon. Does anyone know how I can find out the On Action commands of each item in the custom toolbar? Since I upgraded to 2007, I cannot right click...

Thanks. I will give it a try.

Hello, I have been trying to figure out if there is a way for vba in access to check for certain column headings (row 1) in excel before importing. Any suggestions? Thanks.

I'm using 2003. The only option clicked on Protection is Select Unlocked Cells. All other cells, except these 10 are unlocked.

I have the same problem with the Tab.

Unfortunately, this did not work.

Help. After two days of trying to figure this out - I can't. I have a protected Excel sheet with 10 unlocked cells so that users can only enter information into these cells. I have the cursor move Down upon tab or Enter. However, the cursors jumps as follows (row numbers): 1,3,2,4 and...

Hello. I'm spinning my wheels again on subforms. Ugh! I am trying to set the recordset for a subform on an instance of a form. I am using the context Me.subformname.Form.RecordSet but I keep getting an error that the object cannot be found. Is this because I am calling an instance of the...

Thank you everyone for the suggestions. YMR, if I have multiple instances of the myoldFormname open that call the newform would the reference Me![ntxt1] work? Thanks.

MajP and John, Thank you for your help. MajP I think my code is written similar to your code, but I'm getting an error. Thanks for letting me know where I'm going wrong. Here is the code: Public frmNewform As Form Private Sub txtBusName_DblClick(Cancel As Integer) Dim strSQL As String Dim...

Hello, I only post items here after spinning wheels for more than 3 days. And boy am I spinning them this time. I have a form that when a specific textbox (txt0) is doubled clicked it opens an instance of another form and sets the recordsource using a number from textbox (txt1). The problem I...

Hello. I have been trying, unsuccessfully for 2 days now, to improve the performance of the following query: SELECT C.No, C.BusName, C.SecBusName, C.City, C.State , C.ProspectSt , C.Sales , C.EmpTotal, tblContacts.chrFName, tblContacts.chrLName, tblLastLookup.dteLastLookup...

Hello. I have been struggling for two days now trying to figure out how to open multiple instances of a form and pass information to each. As an example, I would like three of the same form opened and editable that have information for customer A, B and C, respectively. Is there an OpenArgs...

Hello. I have 5 columns of data (Columns A through E) and approximately 1000 rows. I need to transpose the information as follows: ORIGINAL DATA A B C D E 1 ETR 10 FRONT 30 BASE 2 GEF 12.2 BASE 87 FRONT Would be changed to: A B C 1 ETR 10...

Hello. I have a fe/be and just added a database password to the be. I connect to the be using ActiveConnection Here is an example: Sub Login(empid As String, PW As String) Dim cmd1 As Command Dim strSQL As String Dim Prm1 As ADODB.Parameter Dim rst1 As ADODB.Recordset Dim int1 As Integer On...