John, I started Bills suggestion and realized it was only 21 dups. I went through each duplicate and deleted one of the duplicates that did not have any...
John I did forget to mention that I still cannot get the join to be a one to many. It is still an Indeterminate. does it matter or should I address the...
Jim- If the AutoNumber is now a Primary Key, Access should have no problem figuring out the relationship. Can you post a picture of the Relationship Diagram...
John When I made a copy of the original table I did not give it a name that was too different than the original and I was trying to link the copy to the...
Good. I'm glad there wasn't too much damage. I've had weird times when my back end tables went corrupt, and then after I did a compact/repair, it lost the...
Duane, I am a novice to Access. The projects I've worked on as of late I've kind of just been thrown into. It is comforting to know that when I don't know...
Rocky Mountain Tech Trifecta in Denver this Saturday This Saturday is the Rocky Mountain Tech Trifecta, a free technical conference in Denver covering...
Katrina, You have to open the report in design view and then view the Group, Sort, and Total. You have one level at the bottom of the design view (Access 2007)...
I have created a unique index on a table to prevent duplicate records from being added,(you can't play two events at the same facility at the same time)...
Hi Bill, I often create unique indexes too -- the unique index prevents duplicates during batch appends, but I don't use it as a way to inform the user of...
Bill- The only way to trap the error is to test for a duplicate in Before Update, issue your own error message, and cancel the save. Why are you running an ...
John, John, Hopefully this will answer your first question. This is going to be tricky to explain. I wish I could send an attachment. I am working on this...
Thanks to all of you for being here and walking with me! I'm pumped--just solved my own problem because of what I've been taught here! There have been many...
Thanks Duane, I appreciate the help very much. Glenn From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf...
Bill- In each case, are you inserting one or multiple rows? Actually, if you use the Execute method of a Database object, you can trap the error in code by...
John, Actually I will have to run at least three append queries for each game. I have two tables in a one to many relationship. One to schedule the FACILITY,...
Crystal, I may want to do this with a few more tables. Am I correct in understanding that I will have to remove the PK as a unique index. Bill Singer From:...
Hi Bill, not correct a table can have 32 indexes. more than one index can have the Unique constraint set by definition, PK (Primary Key) is Unique. In a Types...
John,... Yes i've tried load the wmv to the activeX, and it give same erorr "Unable to Open AVI File". Regards Hendra ________________________________ Dari:...
Jhon,... I've found the solution, i use Widow Media Player activeX and there is a way to hidden the play/ stop/pause etc. buttons. But the new problem is how...
John, Below is my first shot at a preventing this multiple posting of game times. However, here is the funny thing, if I run the append query off of a button...
Bill- If you're running three queries in succession, not only should you be using Execute, but you should also be using a Transaction around the three queries...
Bill- You run code off a command button using the Click event. No need to cancel it – just bail if something goes wrong. John Viescas, author Microsoft...
Hendra- Sounds like a problem with the ActiveX control. If you gave it a .wmv, it shouldn't tell you there's an error opening an AVI! John Viescas, author ...
Hi Hendra, convert the WMV file to AVI and try it ... according to the error message, that is what it is looking for Warm Regards, Crystal * (: have an...
Thanx Crystal... Yes, I had done that twice with the same file, first using Format Factory tool, and the second time using Zamzar (free online converter)...and...
Jim That may very well be. Run a query to find your orphans like this: SELECT MyField FROM childtable LEFT JOIN parenttable ON childtable.parentkey =...
