Recent content by tommy_mo

Hello- I'm wondering if I can get a little help on the following code. Basically, I would like to use the conditional formatting function to highlight values in a particular column that are greater than a value in the same column, but not part of the selected range. I can do it easily for...

Hello folks- I need to know how to add the current time to a .xls file that is exported from access. I already have the date, but can't seem to figure out how to add the current time. I'm not a programmer by any means, so I'm sure the answer is fairly obvious. Thanks for your help...

Thanks for the reply Keith. Sorry if this is confusing. I need a way to add an autonumber to a query so that the query results have a unique number. The table that the query is currently associated with does not have a primary key, or way to reference individual records. Hopefully this...

Hello folks- I've tried to search for a solution to my problem, but I'm not sure how to phrase it to get a response. The problem: I have a listbox that displays columns from a query. I would like to use the listbox to populate textboxes that relate to the same row (record). I’ve done it...

I'm sure this is an easy thing to do, but I can't seem to get it to work the way I want. The scenario: I have a combo box "study" on my form that contains values eg. LAM, ZAP, HAM ect. I have a table that contains 12 fields that may contain any combination of the "study" values or may be...

I've had look through the forums and have not been able to get a good answer for what I'm trying to do. I have the output to excel part down, but it seems that excel names the worksheet the query name by default. I would like to name it something else. What is the best way to do it? Cheers...

works like a charrm! Thanks again. :D

I have heard of doing that. Would something like the code below do the trick? Thanks. -Tom Forms!Employees!cmboNames.RowSourceType = "Table/Query" Forms!Employees!cmboNames.RowSource = "EmployeeList"

Hello- I was wondering if there is a kind soul who is willing to help me redesign a query/ form so that it runs faster. As it stands, I have a query based on 4 edit controls on my main form. The query results appear in a listbox. The query criteria have wildcards at the end of the the query...

I'm using the following code to format various textboxes when a form first opens. I know there are several ways to select colors. Here is a link to RGB colors http://www.seattlecentral.org/faculty/ymoh/mic110vb/color_chart.htm Hope this helps. -Tom Private Sub form_Open() Select Case...

nevermind. I answered my own question for once :rolleyes:

Is there a way to add the value of a textbox to an exported excel file? I've got a button that creates the excel file, but I can't seem to figure out the code that will add the textbox value. I've tried Me.listbox and (Me.listbox) to no avail. Anyone care to help??? Cheers. -Tom...

Hello alll- I would like to add a textbox or combobox that will hold the text used to name/create a new folder. I'm wondering how to check the contents of the textbox and insert it into the vbcode to name the new folder. I'm guessing it's pretty easy, but I just don't know enough to put it...

Hey Doc- I like your idea, but I have to say that I have no experience with modules. Is there any way you could explain your suggestion in more detail so I can give it a shot. I do plan on using just one form by the way. Cheers! I'll try to work through your suggestion in the mean time. -Tom

Thanks for the responses! Some more info: I have a form called "mainform" with 12 textboxes that are associated with tabs (12 total tabs) on a subform called "subform_study_details". I would like the associated textbox on the main form to change color based on a combo box located on each...