Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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