Recent content by sometimes24

Hello everyone, So, I'm new to access and I've gone a long way and I have one more step before I'm done. I want to suppress the warnings that says things like about to run an append query, about to append two rows, about to delete... BUT I want the key violation warning to show. I'm using a...

Hello everyone, So, I'm new to access and I've gone a long way and I have one more step before I'm done. I want to suppress the warnings that says things like about to run an append query, about to append two rows, about to delete... BUT I want the key violation warning to show. I'm using a...

Oh.. thanks. It's working now :)

Hmm.. still not working. It's working on the form, when I click on the Yes/No field on the form, it works like a charm (except delete which I am working on) but nothing happens if I click on that field in the table. Not sure how to run an already existing macro or the append query.

Alright, I got the append query to work - works like a charm but I'm stuck on how to run that from the table. When I go to my table, I click on Table and After Update, it shows me a set of instructions, non which include Open Query or Run Macro. So I am not sure what do about that. It works...

Alright, I was actually able to get it to work YAAAY - so now it says it's only appending 2 rows BUT.. it's appending it to the Query table not TableTwo, how can I get it to append to TableTwo

Oh, haha wow - feel a little dumb for not picking that up. I tried -1, it says appending 72 rows, I only have 5 rows in TableOne and only two have Yes clicked on. I went with it nonetheless but I see no change to either table. The AppendQuery though, when I double click on it has all these...

That's the project's requirements. So I don't really have much say in what I think. I believe I got the append Query to work, or at least it needs a couple more tugs

Hello everyone, I am super new to Access and have a project I need to complete in a week. I am giving two tables and I need to create a macro that automatically updates these tables depending on the value of a Yes/No field. If it's No, it's in the 1st table TableOne, if it's Yes it...

Hello everyone, I'm super new to Access, let alone Windows, and have a project due in a week and YouTube video choose the EASIEST example to demonstrate - which doesn't demonstrate much. I am giving two tables and I need to create a macro that automatically updates these tables depending on the...