Recent content by Michael.K

SOLVED: Run-time error 3022 with .AddNew Hi vbaInet! Thanks for the offer, I appreciate it. I have just noticed that the last number field was set to Indexed(No Duplicates), which wasn't a particularly smart idea... :) Once I changed to Not Indexed and Not required everything works like...

Hi, Actually, yes there is one more number field in the table. I plan to set its value with an update query at the very end of the procedure. It will hold the ID for the record that will be created as a result of the first record. Here is the full logic: I want to create a record with an...

Hi :) Just one, the first field, which is set to Autonumber. Yes, again this is the first field. I think Access automatically sets the indexed property to Yes(No Duplicates) for the primary key fields. I have pretty much the same code for adding new data to other tables that also have...

Hi all, I have a problem with something that I thought would be very simple and trivial. I have a table with three fields: an Autonumber field, a date field and a text field. I also have a form with a command button to add a new record. When I add the record for the first time it works...

Hi all, I am stuck with a little but annoying problem: I need to create a Data Access Page for one of the tables, but every time I try to create it the DAP comes as read-only. I searched the Internet and found that one of the reasons for a "read-only" page could be the grouping. I removed the...