Search results

I have a Task form that has a subform Parts. When I want to show all records or do any sort of filters it will not show those records that do not have any parts associated with them. Some task are jsut action tasks and have no parts. All the Tasks that have at least one part in the part table...

I changed the source for my form to an sql statement to include some fields from a query, but now many of my searches and my subform get an error stating: "The specified field 'Blah.[Blah]' could refer to more then one table listed in the FROM clause of your SQL statement" how do I fix these?

This may be a stupid question, but is there anyway to add a new field to a form? I created a new query with some totals in it but it seems if i cut and paste one of the fields i currently have and change its controll source, but all I can do is reference it. That doenst' work though because it...

I have a form Tasks and a second form Parts which is also imbeded in the Task for as a subform. On the Task form I have a TaskID field, AdminHours field and a TotalTaskHours field. On the Parts form I have a TaskID (1 task, many parts) and a PartHours field. The TotalTaskHours field is a...

Is there a default message box for inputting a linked file or OLE object. i.e. when someone enters the file field I would like it to pop up a browse window to find the file to be linked.

Is there a default message box for inputting a linked file or OLE object. i.e. when someone enters the file field I would like it to pop up a browse window to find the file to be linked.

Sorry to bug, but I got thrown into this project and they didnt' give me much time to complete it. The only book I have on access doesn't seem to be much help either. Anyway... I have two tables, Tasks and Parts (linked by common field TaskID). Each Task can have many parts. On the TaskInput...

If i have a list box, when a user selects an Item from the listbox can I have otehr fields in the record go to a specific value?

How can I capture the current value of a field with a button on a form so that I can open another form and filter the records based on the value? e.g. I have a task table and a parts table Each task may have several parts defined by their TaskID(the common field in both tables) On my partsView...