Search results

Ok, I think I got what you are saying, but how do I display this control on the main form? I tried setting the control on the main form to =Sum([subform].[hours]) but that didnt' work and I couldn't find a way to set it = to that control...

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

OK I did that, put all the fields into one query but it still gives the exact same message... Any Ideas?

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

Ok, I'm still new and clueless here but, I think I got the query right. I redid it and used the totals button. Now how do I apply that to the field on my form (and add it to the other AdminHours field for that matter) I appreciate the help

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.

asjd;flkajdfk, can't get it.... HELP!

OK, I fixed the first problem, I created a macro that sets the PartInput's TaskID to the TaskInput's and then I just made it so the 'Add new part' button on the PartInput form does the same thing since it will always be true... Still workign on the second and 3rd probs...

tried a few things, still stuck... :/

I have a subform on the TaskInput, just a datasheet of the parts table...

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

*bumb* help a newbie out

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?

what does 'me' refer to? The name of the form or of the table?

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