Search results

Hi All, Im trying to create a crosstab query with parameter entry from a form. I wish to be able to specify a date (using Microsoft DTPicker control) and a shift (using a combo box to the relevant table) to make the selections. These two selections on the form are the criteria for the cross...

Hi all, I need to remove the time input from the DTPicker. i am using it as part of a data entry form and added it sometime after i created the form. However, i now find that for any entries which were made using the DTPicker, the queries I run on the entered data does not pick up the entries...

Hi all, I'm trying to create a chart in a form, this is not a problem, however, the chart types available are a bit limited compared to if i inserted a Microsoft Excel Chart object. I'd do that except I'm trying to create a chart based on a query. Is there a way to make the chart wizard use...

Hi all, stuck on this, not sure if it can be resolved.... I have a parameter query for which the parameter is based on a form field entry (i wanted to avoid the dialog box popping up). No problems with this....however, I want to create a chart based on the same query however, i get the...

hi, i have a form that uses combo boxes for entry, some of the combo box entries are dependent on preceding combo box selections. i have managed to make the combo boxes present options based on the previous selections, but am finding that after i move on to another record, some of the combo...

Hi All, I've got a form with a series of combo boxes which are dependent on each other, however i keep finding that after ive entered some data and left a record, when i then return to the record, some of the information ive entered has been deleted and the combo box is blank. I think it must...

Hi All, I have a query about cascading and combo boxes, which I was kindly, advised about previously. However, I’m stuck as to how to cascade using the selections from more than one combo box. Here are the tables involved tblLine fld LineID (PK) LineDesc tblMachine MachineID...

Hi all, I have created a form to enter downtime information using the fields from downtime table (as follows) tblDowntimes fldDowntimeID (PK) DateOccured MaterialCode ShiftID (FK) LineMachineID (FK) DTCategoryID (FK) DTReasonID (FK) However on the form, LineMachine is taken from the...

Hi, I have a form which lists Employees (flds EmployeeID (pk), Surname etc.) and a form listing Absences (flds AbsenceID(pk), EmployeeID(fk), StartDate...etc.). from the employee form, I want to use a command button that will take me to the Abscences form but auto insert the EmployeeID and...

Hi all, I'm trying to create a query which will retrieve holidays for a specific week, so it would allows me to enter WeekDesc (e.g. week 1) and Line (e.g. Line 1) and then retrieve some information relating to holidays. I have gotten this far already. However, I've just realised however that...

Dear All, Please see attached word document with a screenshot of my tables and their relationships. I'm trying to link from Table:Line,Field:Line to Table:Shift-Line and similarly with the shift table and access is not able to maintain referential integrity. Can anyone explain why? and...

Hi all, I'm trying to set up a holiday register. In my holiday table i have the following fields HolidayID, PersonID, StartDate, EndDate. I would like to have a final field which auto-calculates the number of days taken between start and end date. I read somewhere this should be done in a query...

Hi All, A bit new to this, any help most appreciated. I'm trying to set up a table which will have multiple fields (a recordset? is that right, if so I don't know how to set one up in access). Its for a skill set which is utilised by specific lines in a production plant. Each line in the...