Search results for query: *

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

Thank you both for the help. Geoff, the code you sent me was very efficient, thank you.

I have a form that after filled out, adds an intern name and job skills to a worksheet called interns when a button is clicked. How can I have the data of the new intern entered into the next empty row? I'm thinking I need a loop that starts with the first row and then keeps going down until...

I'm going to spend some time looking over what I have and follow your suggestions. Thank you both for the replies.

I am a beginner and I am trying to write a rather complicated loop. The background is... I am trying to write VB code that loops through unassigned jobs and based on the Job Type, it assigns the job to an intern that can do the Job Type. I have a table called "JobTickets" that has...

I have a field called DueDate in a table called Assignments. I have the field set up as a Long Date so that the full date is kept for historical data. I'm running some VB code that needs to just look at the day of the week, not the full date. Is there VB code that can take out just the day of...