Search results for query: *

Hi there, I have a list box that has name and userid as the two columns. The userid is my Bound Column because I use that in most of my queries and code. But, I have at least one case where I want to show the name selected -- like in a report header. Is there a way to reference the unbound...

Hello, I am using Access 2010 with VBA code. I need to create a SQL statement that I can use for docmd.RunSQL (strSQL). I know I have done this in the past but haven't been able to figure it out. I have Query1 and Query2. Then, I need to do a LEFT JOIN of the two results. Below is basically...

Hello, I am using MS Access 2010. I have links to several password protected Excel 2010 files. In order to access the file, it has to be open. So, I added a call shell to open the file. I need to be able to check to see if the file is already open before running the Call Shell. Can anyone...

Hello, I have a form with a subform. The subform is displayed in datasheet format. I need for the users to be able to edit the existing rows in the data set, but I don't want them to be able to create any new records. I can't figure out how to turn that off. Can anyone help me? Thanks.

I have a Word 2003 document created by someone else that has a Table of Contents. There are 3 levels to the TOC, but only the first level appears in the actual TOC. How do I expand that to show the second level? Thanks for the help!

Hello, I have found code that allows me hide the "Select All/Deselect All" under a multi-select prompt. Is there a way to hide only the "Select All" side and leave the "Deselect All" side available? Thanks.

Hello, I am trying to convert the Execution Time from the Audit database to minutes (or seconds). Does anyone know what the unit of measure is for the Execution Time? Thanks.

Hi There, Is there a way to set the row source for a ComboBox to a noncontiguous range? I need the selection options to vary based on certain criteria. So, sometimes it might be just "A1", but in others it might be "A2,A3,A6", etc. I have found how to create a noncontiguous range (ie...

Hello, I have a UserForm in my Excel 2003 workbook that opens automatically when the workbook opens. I would like for the users to only be able to see the form and not the workbook itself. Is there a way to hide the workbook and leave the form open? Thanks.

Hello, I would like to be be able to use a name entered by a user into an Excel form to look up the person's email, phone, etc. from Outlook address book and return those values to Excel. Is this possible? If so, how? Thanks.

Hi There, Is there an easy way to sort an Excel 2003 spreadsheet by more than three columns available in Data>Sort? Thanks.

Hello, I am working on a project to convert all DTS packages to stored procedures in SQL Server 2000. I have one where it is loading an Excel spreadsheet (starting at row 4) into a table. BULK INSERT will not work for Excel. Any suggestions? SSIS is not an option. Can a job step save the...

Hello, Is there a function in Excel (2007) that simulates LIKE or CONTAINS? Thanks.

Hello, I am trying to figure out how to pull object/column info from the system tables. I have figured most of it out, but I cannot figure out how to pull in the Description property for a table column. Thoughts?? Here is what I have so far: SELECT o.name AS ObjectName, o.id AS...

Hello, I am working on a small project where I need to validate that text box has an entry before going to next field. (Note: Validating event does not work here because they have the option to click a different radio button selection.) I have the Enter key working but I cannot seem to get the...

Hello, I want to be able to run 4 sets of objects through a loop. Example: Dim intCnt as Integer = 1 Dim dblRate as Double Do While intCnt <= 4 strName = "txtRate" & CStr(intCnt) dblRate = CDbl(strName.Text) dblGross = CStr(dblHours * 40) lstOutput.Items.Add(dblGross) intCnt += 1...

Hello, Is there an easy way for VB.Net to set the focus to a specific control once a user enters a value and hits the Enter key? Thanks.

Hi there -- I am trying to combine multiple pdf files into one big one. By the time I make it to about the third or fourth file, I get a message stating that Adobe has encountered a problem and must close. I have unintalled and reinstalled the software and tried doing this on both my...

Hello, I am creating some documentation in Word and would like to be able to provide limited list of options for certain cells in my table. Is there a way to provide a lookup list for cells in a table when using Word? Thanks.

Hi There, Is there a way to open an existing Excel file from an Access database using either a macro or VBA code? Basically, I have an Excel file that links directly to an Access table. The MS Query in Excel refreshes on open. I would like to run my update queries in Access then have it...