Search results for query: *

Thanks for the reponses! listboxname.column(1) worked perfectly!!

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

Thanks for the help. I have narrowed down that it is a Crosstab query that is causing the problem.

That's what I have now, but it doesn't work. To clarify, it works when I run the query the form reference is in. It doesn't work when I use that query as the source in another query.

That makes sense. Currently I have two access queries (not the two in my sample - that was just to illustrate a point) that look to a form for some criteria. Then, I have been trying to create a third one that left joins those two queries. This third query doesn't work because it can't seem...

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

I don't see the "Allow Additions" property for the subform. I created the subform directly in the main form. I did not create a form and bring it in. Thanks for the advice. I will see about creating a seperate form and bringing it in. Thanks again.

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.

That's got it... 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.

Ummm... how do I go about doing that exactly??? :-)

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.

Thanks! I will give it a try!

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