Search results

Hi all I really have hunted for this first! Surprisingly I havn't found a solution. I want to save NOW() (i.e. Date and time) into an event log file. But I just cannot work out the syntax. My insert statement works fine without the date field in, but fails on a syntax error (3134) when I...

Hi all I am very new to all of this, so I hope this is not a daft question. But I have hunted for a solution for a little more than a day so help would be appreciated. My scenario is that I am using a one time table that is a copy of my real transaction table (called GLAcTranLine) to enter...

Hi All Ok, it's a date issue. I have yet to find a language that doesn't quickly demonstrate date issues. I am building an Unbound form in Access 2007. It's a General Ledger posting program. What I am trying to achieve is accepting the input of a document date from a user, then going off to a...

Hi to all. For reasons associated with being a Visual Foxpro fan I never really tried Access. Bu here I am now because I am trying to build an accounting system that will support my (tiny) business as an SAP Freelance consultant. So I knew VFP and other DBASE stuff. I know SAP ABAP...

Hi to all. For reasons associated with being a Visual Foxpro fan I never really tried Access. Bu here I am now because I am trying to build an accounting system that will support my (tiny) business as an SAP Freelance consultant. So I knew VFP and other DBASE stuff. I know SAP ABAP...