Search results

Hi Can anyone see whats going wrong with my syntax below. Is there some sort of software that can help drill down to the error area or something? DoCmd.RunSQL ("INSERT INTO Transactions" & _ "([Date]," & _ "[OrderNo]," & _ "[ItemType]," & _ "[Type]," & _...

Ok, so I tried doing that and the problem I came across was that the below error. "The function 'MsgUser' is not valid for expressions used in data macros." I tried doing a macro in the form after update field but that won't let me create new records. Would I be better off figuring how to do...

Thanks pbaldy, how would you code that function?

Hi, I'm trying to put together a database with a user login and audit trail. I am able to get the used login bit to work with a table and passwords and have the user's name stored in a global variable. I have kind of figured out how to get the audit trail to work with data macro's but am...

Thanks, I think I have it sorted now

No ideas anyone?

Hi, So i'm somewhat of a newbie to databases but I think i'm a few steps further than the average office applications user. I'm using Access 2013 and trying to create a database to manage meat inventory better. I have a table for incoming meat deliveries. Which includes ED Number(unique and...