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

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

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

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

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

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

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

Is it possible to set up a query so that it finds all the records between two heights? I set up an input mask so that the heights are always entered like _'__".

I have a paper form that i'm trying to convert the information into a database using Access. The form has 3 main categories with check lists underneath them. An abreviated example of what it is like is below... Type of Anesthesia 1.Epidural 2.Spinal 3.General 4.Other Procedure...

I'm trying to make a form that can be used to query so that the user doesn't have to go in an write up a query in design view. On my form I have text boxes txtBegDate and txtEndDate and AnesNum. I want the form to find all the rows in the table where the field Date is between the two values...

I have a text field AnesNum that can include several ID numbers. If the ID number 111 is include in this set of numbers, I want the text field OtherAnesType to become visible. The following code works if I type in *111* but not if I type in 111 or 111, 123. The help file said that * can be...

I have a paper form where there is a list of events that can occur during a visit. The person can check off several of the events. Is there a way to make a form so that if there are several items checked they will all be stored into the same field? Or would I be better off doing it some other...

I have a form that when the user fills it out with an ID, Description, Category and Occurance Number, the inputs are stored in an Occurance table. There is another table that has the ID's listed and has the associated Description and Category. So that the user doesn't have to input the...

I have a form that the user enters in an id number. According to that ID number I want the form to lookup the category and description in a table. Then I want to be able to save the ID number and the values that were looked up into a different table. The table that the values are looked up in...

I have a form with the following text fields... txtID1,txtDesc1, txtID2, txtDesc2, txtID3, and txtDesc3. The user fills out all of these fields and then there is a button to add the records to the table, tblOccurance. Each of the sets of ID's and Desc's stay together as 1 entry into the table...

I have a form where there are three fields that go together. There are also several sets of those three fields on the form. Is it possible to have a button that if pushed enters each set into a table whith each one having an autonumber entered with it. The setup of the form is below...

I have two tables. I made a form where the person types in an ID number for an instance. I want the form to look in the one table and pull the information that goes with the ID entered by the user. The user should be able to open the form and type an ID in, then the statement...