I have been looking to make a receipt maker for my company depending on the service i have provided. Is this something I would use access for or should I just look at using some other MS program for this? if you know of anything that i has been done that is like this could you please...
So i am using the ID represented ClientID (far right in picture)but now it seems it's not highlighting at all this is the code i have so far i think i put everything in the right place
DCount("*","Checks","[C_Amount]=" & [C_Amount] & " AND [Chased_Date]=Date() AND [ClientID]='" & [ClientID] & "'")>1
the issues with it i think is that the First name and last name arent in the same table would i need to add another rule add the tabl into the function?
This worked thank you! that was much simpler then i thought lol. anyway, i could also add a restriction like say ignore the duplicate (or not count it) if the person names are different from the report compared to the table???
Hello, again great access world! hope all is well and yall are safe!
I've come to you guys about Conditional Formatting issue i have come to This is the rule I'm using and it currently checks all the data from the table "Checks" which causes every amount in the report to go red because it's...
So i am trying to get my "sub form" to change to the data the user enters i know this is something you can do when you use a forum as a sub form but my "sub form" is coming from a qry as senn in "Annotation 2020-03-04 004253.png". Im not sure why i keep getting this see "Annotation 2020-03-04...
OH I see! ok ok. I think i found why it's doing this maybe.
the ID was different from ID in the report I just changed it to look at the client ID and make sure it matches to the ID on form and it worked! thank you guys so much! you guys are the Best!!!
Kinda wanted to have it on its own table becouse i have combo boxes that call to that zip when adding companies. same wiht countries when verifying what ID they have showed us. so those combo boxed call to the different tables so you dont have to type it all out. and yes Contacts is name for...