Recent content by guyuz

To be honest, I don't know how indexing works/for what it is used, and having indexing on all fields was the default (IIRC). Anyway, I removed the indexes for F1 and F2. It doesn't seem to solve the problem, though. EDIT: Found the solution, it was a mistake on my part: tblTarget's F1 and F2...

If I understand correctly what you are asking, all 3 fields (Primary Key, F1, F2) have indexes ("Yes (Duplicates OK)"). However, I've already tried tampering with the Indexed property of the fields F1 and F2, with all combinations of Yes (Duplicates OK)/No. I still receive the exact same error.

[SOLVED] Microsoft Access Didn't Add Records Due To Key Violations Hello, I have a table called tblTarget, with 3 fields: Autonumber ID, Number F1, Number F2. F1 and F2 are indexed, allow duplicates, and are not required. I'm trying create an append query. SQL code is the following: Insert into...

Hello vbaInet, I realize that changing the SQL of the record source is problematic, but I'm short on alternatives. I've read online about various syntaxes of IF statements (IF-ELSE, IF-THEN-ELSE, IF-THEN-END-ELSE), but Access Recognizes none. As for closing the Querydef, that's my fault. I'd...

Once again, thanks for the reply! I've taken your tips into account, though I'd like to ask how would you name a table that connects two others in a many-to-many relationship? I've seen it done with an underscore, but since you said it's normal not to have special characters in the table name, I...

Thanks for replying! This is the entire code for the form, most of it isn't problematic as far as I know but since all the code work together, no harm in having it here. Error happens only inside code snippets 2 and 3 (Which are identical but for the different buttons), at the lines...

Hello everyone, I have an issue with a table embedded in a form, with a query that changes based on what is done in the form. The problem is a bit long, so please bear with me. I have a table of events, tblActivitiesDates which have an activity type and a date. I have a form which has a...

[SOLVED] Query In Form Fails When Form Is Called Through Navigation Form I'll try and keep this short, nobody likes to read a wall of text. Feel free to ask anything, I'll gladly elaborate. I have a form, called SearchFrm, that inside has a subform ContactsSubFrm that is in fact a datasheet...

Hello everyone, I'm Guy, 17. I'm relatively new to Access, I've been using it for only a few months, but since I am probably going to be using it for a long time, might as well take it a step forward and join a forum:) My interests off the top of my head...: basketball, football, video games...