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 Rhinorhino 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: *

  • Users: BrianLe
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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 =...
  6. 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 -...
  7. 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...
  8. BrianLe

    Finding Concurrent Events

    I tried to solve this in Excel, but I didn't have much luck, so I'm going to try with Access which is probably better anyway. Using Access 2007, I have the following tblEvents: ID SiteNo EventNo EventStart EventEnd EventDesc 1 1 1 1/1/2011 1/5/2011 a 2 1 2 1/11/2011 1/15/2011 b 3 2 1 1/9/2011...
  9. BrianLe

    Find common dates in Excel spreadsheet

    In Excel 2003, I have a spreadsheet that has numerous start and end dates for events for 3 sites. See example below. Site 1 Site 2 Site 3 Start End Start End Start End 1/1/2011 1/5/2011...
  10. BrianLe

    Excel Chart Legend Series Name Re-ordering

    In Excel 2003, how do you re-order the list names of the series in the legend? After creating the chart and legend, I added some more series and names. Now the series names are out of order. Thanks, Brian
  11. BrianLe

    Slow response for Word table

    I have a table in Word 2003 with 6 columns and about 400 rows. Each cell has about 100-500 characters. When I want add/change something in one of the cells, it takes 5-10 seconds for a response. I checked the FAQ's and searched for help but couldn't find any. Is there anything I can do to...
  12. BrianLe

    Specifying numbers, text, dates

    In AC97, I'm trying to add records to a table with information from cbxTask - number, lbxOperator - number, tbxCompletionDate - Date, and chkSupvJobBriefing -y/n that are on frmTaskCompletion using an "On Click" event like the following. I'm sure it isn't close, but I'm lost as far as how to...
  13. BrianLe

    Order of selecting combo boxes

    In AC97, I have frmTaskCompletion that has cbxOperator, cbxTask, and tbxLastOpertorTask. The record source for tbxLastOperatorTask uses the DMax function. When I select an Opertor and then a Task, the tbxLastOperatorTask updates with the correct "CompletionDate". However, when I select a Task...
  14. BrianLe

    Update selected table records

    I have the table set up like this. tblA ID(pk) fld1 fld2 fld3 1 1 1 3 2 1 2 3 1 3 4 2 1 4 5 2 2 6 3 1 2 7 3 2 8 3 3 9 3 4 The fld3 value is always in the record...
  15. BrianLe

    Using value in header in detail section formula

    In AC2000, how can I use a value in the Header section of a report in the formula for a value in the Detail section of the report? The tblPlanning includes fields Activity and BurnRate. For each record of the plan, there is an Activity, but since BurnRate is constant for all the phases of the...
  16. BrianLe

    Find DMax based on combo box selection

    In AC97, I have a table TaskLog with fields Operator and Completion Date. I would like the maximum Completion Date to show in a text box on a form for the Operator selected from cbxOperator. I've tried a number of variations of the following for the record source of the textbox but the textbox...
  17. BrianLe

    Sum for group of records

    For a material handling database, I have a table tblActivity with a field HandlingOptionID (1-10). Each record in the table has a StartDate, the HandlingOptionID and a weight (DBelt) specified. For example Handling Date OptionID DBelt 2/2/08 1 30 2/4/08 1...
  18. BrianLe

    Time duration

    I have a tblActivity with fields StartDate and EndDate with Date Type as Date/Time (no specified format), and a report with tbxDuration with control source =[EndDate]-[Start][Date] I would like to change the control source for tbxDuration so that the period of time from 9:00 AM to 9:15 AM...
  19. BrianLe

    Send email when Access file is changed

    Is there a way to send an email to specified addresses when an Access file is changed? I would like to notify all the users (<10) of changes to the database. Thanks, Brian
  20. BrianLe

    Exclude similar records in table

    In AC97, I have a form frmAddNewTrainNo with tbxTrainYear, tbxTrainNoStart, tblTrainNoFinish that is used to add new train numbers to tblTrain. There is also a lbxTrainNoYear with a record source query that displays the last train number's TrainYear and TrainNo. The user is supposed to enters...

Part and Inventory Search

Back
Top