Recent content by jcardullo

I remain cofused. Here is some more detail on my problem. I have an employee table that includes a team field and an equip. field. On my form the [cboTeam] cascades the line source for [cboOperator] based on the team selected. The form is for Loader operators so I also have the code...

I have cascading combo boxes that filter a list of employees based on the team number selected in the first box and by what type of equipment they operate. Is it possible to have the list contain the filtered results on top of the list then list the remaining employees sans the ones selected by...

:D Thank you thank you thank you thank you. I was about to tank this whole project because it's entire reason for living was to track history and current lives of components. Thank you for giving my dbase a purpose.:) By the way, on a general note, this forum has been the most useful resource...

the whole record I wish to save the entire record. Is there any way to do that? I need to enter a record from a form and if certain fields already match it in the table, I need the matching record in the table to move to another table. My table names would be tblCurrentComponents and...

I am interested in anything better suited. What is the On Change event I need? Sorry about the elementary subject matter, but I am new to databases and for some reason none of the ADO topics in my Help file will display. Thanks for any assistance.

What is the syntax for copy? I can't find anything in Help.

Can I write code so that when a field is updated from a form, the old data is replaced and moved to another table? I am using Access 2000

Once again, thanks I'll give this a try. Happy 4th for all the yanks out there

Please excuse my ignorance, but what do you mean by "walk"? By the way, thank you so much. This was driving me crazy.

Here are my columns [Equip#] [Comp.] [HourInstall] [CompHours] [DateInstall] 2580 HCYL 53805 6-20-02 2580 HCYL 50956 12-10-01 2580 HCYL 50081 9-13-01 2580...

I have a table that contains component replacement on heavy equipment. I need to run either a query or report or combination of both to calculate hours on the component. Here's the trick. The hours will be calculated based on the hour meter entry of the new component with the newest component...