Search results for query: *

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...

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.

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...

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...

I would greatly appreciate any help on this. I have a web based program written in php that pulls images from a database (mySQL). Sometimes the images appear and sometime they do not. And this varies from computer to computer. Thanks. John

I have a form with a top of 0, and I have hidden all command bars except for a custom bar. However, regardless of anything I do the form does not position directly below the custom command bar. It almost appears that the hidden bars remain. Should I use a negative number for the top to make...

Can anyone direct me to a solution to add multiple files to an email. I need the user to be able to select the files in an Explore type environment. Thanks for your help.

Hello. I have been spinning my wheels for two days now. I have a form that I am using as a header where a user can select from a combo box any open form. The "header" form works, but I am trying to create a user interface where only one form appears on the screen below the "header" form...

I do not know if this is possible in Access 2003, but does anyone know how to display a global variable on the system header so that it is shown continously. For example, I would like to show the username, dates selected to run reports and the specific customer selected at that time. Ideally I...

Hello. I would like to add the ability for a user to modify the color of a heading on a web site. Does anyone have a recommendation on a good applet or some code that I could include that will show a color palette, allow the user to select a color and when clicking Ok will transfer the hex...

Hello. I have a form where the user clicks on an email address and MS Outlook opens with the email address in the To box. Once the user completes the email and sends it I would like to have the email message written back to a table (along with other tracking information internal to the DB)...

I am creating an expand/collapse menu in HTML using DIV and SPAN tags. The menu works fine up to 2 levels, but when I add a third level the menu does not collapse. The code I have is below. The issue is that the Insurance heading does not collapse the menu items below it. It appears the...

Help, someone. I'm trying to make a collapse/expand menu but in some cases there is nothing to expand. Therefore when the user clicks on the heading into should just go to a different web page. However, I am new at this and cannot seem to make it work. Can someone direct me? The code I'm...

Hello. I'm hoping someone can assist me. I am new to web development and design. I have had a difficult time with a Fireworks menu that I'm importing into a Dreamweaver document. The problem is that I have a transparent background for the menu and when I import it into Dreamweaver I see...

Hello. I'm new to Dreamweaver and have been having a difficult time importing a Fireworks popup menu into Dreamweaver. The problem is that the font is very jagged and shows some sporatic white space around the letters when viewed in a browser. The menu has a transparent background. The...