Search results

  1. O

    Updating a table field using unbound text boxes

    Hello forum, I am running into a wall and desperately need assistance. I have a form that contains a combo box (cboEmployeeName) that pulls data from a query and populates three text boxes (Work Area, Last Name, First Name), This part works fine. Because the text boxes are being populated by...
  2. O

    Subform issues...

    Can I use a subform combo box to update data in a text box on the main form?
  3. O

    Sub-form will not update record source for main form

    I have run into a bit of a problem while attempting to create a form to update a table. Initially my form “frmTrainingScheduler” worked perfect, but after receiving feedback from users to make it more user friendly, I decided to make some changes. On the original form the user would choose a...
  4. O

    Look-up Query?

    Hello all, I am attempting to create query results based on fields with multiple values, and populate a report based on the result of the query. The report is a class roster and the fields in question are "CourseID" and "StartDate". The goal is to pull all data from "trainingSchedule" table that...
  5. O

    Multiselect List Box issues...

    Hello forum, I have a form that I use to populate a table that schedules and records training events for employees. I have many combo boxes that I use to populate most of the fields in the table, and one list box that I want to use to select one or more employee/s to add to the table. When I...
  6. O

    Problem with decimals in combobox on form

    I have searched the threads and tried solutions but none of them have worked thus far, this is why I am asking the question again. I have a combobox on a form that I use to select a decimal number (.5, 1.0, 1.5, 2.0, 2.5, etc.) sourced from a query, the query source is a table field containing...
  7. O

    Looking into the future...

    I have created a query that has several fields of data, one of fields is "CourseStateDate", the records under that field are "short date" format. I would like the query to produce only those records with "CourseStartDates" from Monday of the current week and looking four weeks into the future...
  8. O

    Autofill hours...

    On my form I have the following: txtStartDate txtEndDate cboStartTime cboEndTime txtDuration I would like to have another text box that gets auto-filled with a number of hours based on the durations from the above listed information. For example, if txtStartDate=2/16/2012...
  9. O

    Pop-up calander in a form?

    One of the items on my form is a textbox that is used to enter a date that updates a field in a table. Is there a way to have a calendar pop up when you click in the textbox that allows you to click on a date to populate the textbox? An example would be the arrival date box on a airline or hotel...
  10. O

    Adding addition records without overwriting existing records

    I have a form with several combo boxes that I use to select specific data to add to a table. I need to have that data saved as a new record without overwriting the existing record...can somebody please assist?
  11. O

    Auto close a pop-up form after use

    There is likely a simle answer to this but I cannot seem to find it. I use a pop-up form to bring up a report after choosing a name from a drop-down list and clicking "ok". I would like the form to auto-close after it brings up the report, how do I accomplish this?
  12. O

    Query only certain dates

    I am new to this forum and reletively new to Access as well, please by patient. I am attempting to display a field called "DueDates" based off of data located in another Field called "CourseCompletionDates", I know how to advance every record by a determined amount but what I am trying to due...
Back
Top Bottom