Search results

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

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

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

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

Hello folks- I have a question about using "select case" I would like to use the code below to change the color of a textbox (text59) based on the combo box (Status) text. It works well, but I have other textboxes and combo boxes that I would like to perform the same. Is there a way to loop...

Hello- I was wondering if someone would be willing to help me put together code for a form button. I want the button to go to a record that is typed into a text box based on the key field of a query. If there is no key that matches then I would like to have a message say someting like "record...

Hello folks- I have a form below that is used to filter a table based on criteria in the text boxes. The listbox is filtered based on a query "mainquery". I would like to add a subform or textboxes, not really sure which is appropriate, to show the contact info and address (last 2 columns...

This is probably easy to do, but I can't find the solution anywhere. I've got a listbox that displays a query reslut. The problem is that there are some fields that have more than one line per row and are not visible in the listbox eg; field1 field2 row1 line1 line1...

iwas wondering if anyone could hlpe with splitting a songle column into several new columns. The data is from an access file in which the flields have the following format: 1231222 1@yahoo.com 42424242 2@yahoo.com So, whwn I import them into excel they have the format: 12343434||1@yahoo.com...

I was wondering if there is a way to separate information I have in a database. The database was originally designed with a field called "contacts" At first only phone numbers were entered, but as time went on email addresses were added on separate lines eg: 123-345-6789 one@yahoo.com There...

Hello all- I've seen a few examples on this forum, but I still would like some ideas. I've got a listbox that I would like to filter based on text boxes. I would like to be able to filter the listbox with any single textbox or a combination of the textboxes. Ideally I would like to be able...

Hello- I was wondering if anyone here could help me modify the following code. I would like to use several unbound listboxes in a form to display several queries based on one uploaded table. I can't seems to get the code right so that the listboxes refresh after the Hot Sync completes. I've...

Hello- I was wondering if anyone here could help me modify the following code. I would like to use several unbound listboxes in a form to display several queries based on one uploaded table. I can't seems to get the code right so that the listboxes refresh after the Hot Sync completes. I've...

Hello- I’ve searched the forums and was not able to find the answer, so I was hoping someone would be able to help with this. I would like to open multiple forms (cascade) in the same .mdb file when the first form is opened. There are a total of 4 forms. This is probably a very simple thing...

Hello Folks- Just wondering if anyone here has a tip for my problem. I've got an Excel file that is being used to fill in word documents via linked objects. The problem is that the excel file is growing exponentially, and seems to crash frequently. Right now the file is about 15 megs, and...

Hello folks- I’m posting here because I have received great help in the past (for other questions). So, I was wondering if there is anyone out there who could help me with this one.:confused: I have a form control that imports data from a PDA to an active form. It works great. So much so...