Search results

Thank you both for your reply, it's really appriciated. @gemma-the-husky: I am also a big fan to keep all in one table, it's much easier to program but it gives me some issues where multiple tables can be a solution. For example: - Lets assume the user wants to put sample x in room A, rack B...

Hi all, I have a problem with indexes in tables. I made an inventory DB where we can store items on several locations. Their are several difference items, each kind of item has his own table because they all have different fields that the user has to fill in. The only thing they have in...

hi, Yes, I am in test mode at this moment. adding a record works thx to Allen Brown his code, the code puts UserName(), Now(), all the old values etc inside the table but when I want to put a reason also inside the table (expression 4) it doesn't work (error msg 3061)...can I just let the...

Hi Jdraw, Thanks for your reply, it's really appriciated. I tried both to put quotes around "audReason" and without quotes. With quotes it just put the value 'Audreason' as reason in the table, without quotes I get error 3061 that says: "to few parameters, expected 1" so none of them works...

Hi all, I have small issue with the code from Allen Brown. His audit code works ok, no problem, but I would like to register a reason in the audit table when the user change something. I placed a 4th field inside the audit table "audReason" and this variable comes from an inputbox. the...