Search results

I have the same problem. I have a table linked to another table for values. I created a query to link both values into one data set. When I click on "Collect Data" from the query, it only allows me to collect new records, not update existing ones.

I started from scratch and I copied the sample database from Microsoft. It worked! Yay... now on to a different project! Thanks Ken for trying to help me. Mel

I think I'm doing more harm than good in my database. I can't get my values to fit in. Should I just send someone my database to have a look at it? I think I majorly screwed up the VBA coding too! :eek:

I don't know what I'm doing wrong, but I can't get either method to work. I have no clue how to use VBA. It keeps asking me to create an Event Procedure, but their examples are with Categories and Products... I need MCC and SPOC to talk to each other. I don't know if they refer to a field name...

I give up! I've tried these two methods from Microsoft and I can't get them to work. http://support.microsoft.com/default.aspx?scid=kb;en-us;209576 (Both queries were built successfully, but I can't connect the main one to my form. Instead, a window opens asking me for my primary value.)...

My column with the times is called TAC. (I don't know what the abbreviation is for!) Each row has a different time. It was HH:MM:SS. I shortened it to HH:MM because I had read that it would round up the minutes. I don't know if it actually helps.

I'm trying to write a query that will find all duplicate records that have the same time, within a maximum 10 minute time frame. For example, 9:43, 9:50 and 9:53 would be duplicate records. Then again, 9:58 and 10:08 would also be duplicate records. I have absolutely no clue on how to write...