Recent content by johnain

Hi NamLiam. That worked an absolute treat. Thanks a million. Dates really are always an issue in every language I work in, or have worked in.

Hi Spike. Thanks for coming back. The output in the watch window looks ok . Here is the version with the hero marks ( '16/10/2014 11:26:02', 'JohnAin', 'New Document Created', 'Your document 21-2014 was saved with AutoSequence 1019.', '21', 1019, '100' ) And my other versions "look" ok to me...

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 Spike Thanks again for the input. It's appreciated. I have fixed the issue now, but I thought it might be useful for others who face similar issues, and also out of interest for you. But first ... a word of thanks for that tip on referencing. It is pure gold ! I confess that I sometimes go...

Hi. Thanks for that. I am setting up a general ledger accounting entry with one header record for each document and then many transaction lines (up to a couple of hundred or so) - which must balance DR vs CR overall to zero. There must also be a sequence number allocated to the header and...

Hi Spike. A bit aggressive, that. Never mind. Thanks for replying. The Application will eventually be an accounting and crm/sales / sales order management system for companies that work through agents. These companies agree contracts with agents in any one of several currencies for the...

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 again Gemma Ok, I'm going to fool around with these options. Once I get it to work I will post the solution on this thread because I imagine that there will be others looking for this solution. You've been great. Thanks ever so much. ps. I hope that I don't have to get into database date...

Great stuff Gemma. Really, really helpful. The SUB now runs. The technical issue is fixed thanks to you. the SUB now runsNow I have to find a way to to the date conversion to (I suppose) yyyymmdd. That sounds like fun !!. Dates really are a nightmare in most languages aren't they? I though PHP...

Hi Gemma Thanks very much for your reply. It is much appreciated. Unfortunately your option is not available to me. That is because there are some points when the system needs to have two periods open, at period end and also at year end as the accountants go about their closing routines. I...

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. Thanks for that, it's really helpful. The reason I am wanting to do it myself is because accounting software is something that I know really well, so if I use it as my example it ought to help me to learn Access. Within the SAP world (or my Business Intelligence part of it) the big move has...

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...