Recent content by mxp346

I have the below code so far. The problem is that the variants are being populated with a number equal to the location in their respective listbox. I want the variant to equal the actual value. I'm not sure if this will have an impact on how the correct code is written but the values in the...

I have done some VB programming with Excel previously but never with Access. I have a form with the following: Radio Buttons Domestic and Overseas Listbox Organization I have a table called Organizations which has two columns (Organization and Location) When a user clicks the radio button...

Ok it worked now. Sorry about that, I dont know what I did wrong the first time. Thanks again for your help.

Skip, thanks for the response. I saved the file as a .prn file but when I opened the file with notepad, each line still had quotes around it. Is there another file type or method that might work? Thanks in advance. -Matt

I am trying to copy a range of cells into a text document. The code below copies the range, pastes it into the text document, saves the text document and then closes it. Everything works correctly except when I go to open the text document each line of text has quotes around it. In trying to...

Anyone have any better methods? I do not want to then have to do a save as again to save the file back to an .xls file.

I have a worksheet called Scripts that will have a different number of rows, but the data will always be in column A. What I would like to do is save the used range on the Scripts sheet to a text file. I do not want the other worksheets to be saved to the text file. I'm not really sure where...

Thank you very much for the help

I need a simple loop statement that will go through each worksheet in a workbook and then take certain values from that worksheet. Then it is going to run some other subs using the variables. Below is what I have. I believe I am doing something wrong with ActiveSheet part of it. For Each...

Thank you very much, that worked just like expected.

I am trying to use VBA in excel to have the next empty cell value to be a combination of hard coded text and a variable. The code below is part of a loop that goes through each of the worksheet and sets the variable userid to cell A1. I then want the code to enter the following in the next...

Adding Val() made it work. Thank you very much. Any ideas on what I would want to add if I am looking at a date?

Here's what's wrong. I used this code below to search through the repair sites: Private Sub SearchRepairSite_Click() Dim Counter As Integer Counter = 0 With Worksheets("Search Results").Range("A2", "J65536") .ClearContents End With For Each cell In...

That code isn't working either. Any other suggestions, Rob or anyone else?

I have a form, SearchForm, that has a text box called TicketNumber. Once the button is clicked, I want the value in the text box to be compared to the Column Range called AllTicketNumbers. When it finds a match, I want the entire row output to a worksheet called Search Results. For this case...