Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. BrianLe

    Insert table value based on listbox selection

    Will do. Thanks, Brian
  2. BrianLe

    Insert table value based on listbox selection

    PH, Thanks - that was it. I was getting the INSERT Into error because someplace along the line I had deleted "GroupID" from tblReqReadDocs. I moved the last Next to before rs.Close and it works great. Here's the final code. Private Sub cmdAddRecords_Click() On Error GoTo...
  3. BrianLe

    Insert table value based on listbox selection

    PH, I put in your code , but I'm getting a "Object variable or with block variable not set" error with this code. Private Sub cmdAddRecords_Click() On Error GoTo Err_cmdAddRecords_Click Dim lbx1 As ListBox, lbx2 As ListBox, lbx3 As ListBox, tbx1 As TextBox, SQL As String, DQ As String...
  4. BrianLe

    Insert table value based on listbox selection

    At first I thought it would be adequate to track by group, but when I considered that employees could change groups I figured it would be best to track by employee. They don't change groups that often though. The reports we run, usually within a one-two month period after the reading...
  5. BrianLe

    Insert table value based on listbox selection

    In AC97, I'm trying to create a database of reading done by employees. The records go into tblReqReadDocs (DocID (PK),TopicID,SubjectID,GroupID,DueDate)using the code below from frmAddReqReadDocs that has lbxTopicID, lbsSubjectID, lbxGroupID, and tbxDueDate. Private Sub...
  6. BrianLe

    Add Records Combination of Multiple List Boxes

    If I may expand on this issue, because the employees may move to a different group at a later date, I think I have to add the EmployeeID to tblReqReadDocs so I can retrieve which Docs each employee read. Therefore, I would like to add the EmployeeID of each employee in the GroupID's added to...
  7. BrianLe

    Add Records Combination of Multiple List Boxes

    I'm using Access 97. DAO 3.5 Object Library was checked, so I unchecked it, and checked DAO 3.6 Object Library. I still sometimes get crashes when I run a particular query. I'll take that issue to the query forum after I get a chance to research it. Thanks, Brian
  8. BrianLe

    Strange random grey background on group header?

    Could it be doing it by some code in the report? In Design Mode, select View, Code and look for something that could be changing the color.
  9. BrianLe

    Grouping records on separate report pages

    I'm trying to create a report from the records in a query (qryReqReadDocs). The fields are GroupID, EmployeeID, TopicID, and SubjectID, as well as description fields for each. Each EmployeeID is assigned to a GroupID, and each SubjectID is assigned to a TopicID. There are typically 5-10...
  10. BrianLe

    Add Records Combination of Multiple List Boxes

    TheAceMan1, Your code works too. I don't know enough to say whether it is better or not. I'm still getting Access crashes with your code, so maybe I have some other code issues elsewhere. Or maybe my computer just isn't fast enough. Thanks, Brian
  11. BrianLe

    Add Records Combination of Multiple List Boxes

    Works great!!! Here's what I have. Private Sub cmdAddRecords_Click() On Error GoTo Err_cmdAddRecords_Click Dim lbx1 As ListBox, lbx2 As ListBox, lbx3 As ListBox, tbx1 As TextBox, SQL As String, DQ As String, itm, itm2 Debug.Print SQL Set lbx1 = Me!lbxTopic Set lbx2 =...
  12. BrianLe

    Add Records Combination of Multiple List Boxes

    In AC97, I have a tblReqReadDocs with fields docID (pk), TopicID, SubjectID, GroupID, and DueDate. I have a frmAddReqReadDocs with lbxTopic, lbxSubject (multi-select), lbxGroup (multi-select), and tbxDueDate. I would like to add records to the table for each combination of selections from the...
  13. BrianLe

    Multiple table fields related to multile records in another table

    Thanks MajP and PH. I'll set up my tables as suggested and try to set up the forms too. I may be back for more help on the forms. If so, I'll post in the Access Forms forum. I'll let you know how it comes out. Brian
  14. BrianLe

    Multiple table fields related to multile records in another table

    In Access 97, I'm trying to create a database for jobs, tasks (which are involved in the job), and hazards (which are involved in the task). The database will be populated by assigning hazards to the tasks, and tasks to the jobs. So for each job, there are various tasks to pick from, and for...
  15. BrianLe

    Concatenate Time with Date Picker Control

    Duane, I didn't mean to make it look like I was ignoring MajP's suggestion, but I couldn't try his suggestion at the time because I wasn't at my Office 2010 computer. And since you responded first, I felt I should respond to you as soon as I could. MajP's suggestion does work, after I changed...
  16. BrianLe

    Concatenate Time with Date Picker Control

    Duane, The Hour values in the lbxHour come from a query of the table tblHour30, with fields TimeID and Hour. The Hour field is a Date/Time type and Medium Time format. Thanks, Brian
  17. BrianLe

    Concatenate Time with Date Picker Control

    In Access 2010, I'm trying to change a text box (tbxSheduleDate) to be the combination of the date (from date picker DTPicker1), and the time from a listbox (lbxHour)of hourly values. I tried the following but is doesn't work. Private Sub lbxHour_Click() Me!tbxScheduleDate =...
  18. BrianLe

    Syntax error (missing operator) with the dates in the INSERT INTO

    I get a syntax error (missing operator) with the dates in the INSERT INTO statement in the cmdAddRecord_Click code. The format of the fields in tblChemicalOrders are as follows: OrderDate - date/time (only date part used) ExpectedReceiveDate - date/time (only date part used) OrderQuantity -...
  19. BrianLe

    Accessing tables from startup page

    Thanks Hap - works great.
  20. BrianLe

    Accessing tables from startup page

    I'm trying to troubleshoot a problem with a pretty simple 3rd party program that uses an Access database for data storage and reporting. When the program starts, the startup page comes up as expected. Reports run OK. However, there is a problem with one of the data input screens. The vendor...

Part and Inventory Search

Back
Top