Can an Access accounting database be linked to a bank account?

[Owl]

Is it possible for an Access accounting database to be linked to a bank
account, so that the company can see when payments are paid in?

Thanks for any replies.

 

[Tom van Stiphout]

On Fri, 9 Apr 2010 04:14:01 -0700, Owl <[email protected]>
wrote:

Maybe. You'll need to talk to your bank. Some may have this
information available, for example as a Web Service. The bank would be
able to give you the details. Don't expect them to have VBA examples,
but they will likely have .NET examples or at least the spec itself.

-Tom.
Microsoft Access MVP

 

[Owl]

Thank you for your very informative reply. Now, I know where to begin.
However, could you please tell me a little bit more.

If i get the .NET examples, or the spec itself, is it then a case of
converting that into VBA?

If that is the case, I know I won't be able to get very far with that on my
own. However, I am hoping that some kind person here will be able to help me
with that.

Thank you again, in anticipation of your reply.

 

[Tom van Stiphout]

Yep.
Assistance in the newsgroups for a project like this may be asking a
bit too much. What most of us would be impressed with is if you put in
your best effort yourself, and ask pointed questions that fit the
newsgroup format. You can't really expect help if all you offer is
"here is the 50-page spec - how do I write my program?"

Additional help may be on the web in general: for example people have
written about how to call a SOAP method from VBA.

Of course you can also hire the talent to help you with this part of
your project, up to the point you can take it further yourself.

-Tom.
Microsoft Access MVP

 

[Owl]

You have misunderstood me entirely, as you will see if you read what I wrote.

I merely started by asking if it is possible, as I don’t want to embark on a
project if it is impossible to do it in Access.

Then I asked for help with understanding your answer.

Then I expressed the hope, that – if I did, in the future, embark on such a
project - that I could ask for help at the time (and there is nothing in what
I typed to indicate that what I would have asked would not be pointed
specific questions as they arose).

I cannot begin to imagine where you got the idea that I was “really
expecting help if all I offer is “here is the 50-page spec – how do I write
my program?â€â€

And, for that matter, you gave me no indication as to whether the spec would
be 3 sentences or 50 pages, so how would I know that 50 pages is possible?

I would have thought that the words, “Now I know where to begin†and the
pointed question I asked, being “if I get the .NET examples or the spec
itself, is it then a case of converting it into VBA?†(which, pointed
question, you didn’t answer, by the way) would alert you to my lack of bad
nettitude.

If you read all my posts in this thread and any other posts, you will see
that I have treated all responders with the utmost respect, and that all my
questions are pointed, specific questions and I have been grateful for all
help given, whether it has helped or not. You will also see that nobody on
Microsoft Discussions has ever spoken to me like this before.

I do not understand where your response has come from.

 

[david]

You download the bank statement, as a CSV file.
(Often called an 'excel' file).

Then you import the bank statement into your accounting
database.

You can automate this process so that it happens
automatically.

You will need an experienced Access or Excel developer to do this if you
want it to happen automatically.

(david)

 

[Owl]

Thank you very much for this information, David.

You download the bank statement, as a CSV file.
(Often called an 'excel' file).

Then you import the bank statement into your accounting
database.

You can automate this process so that it happens
automatically.

You will need an experienced Access or Excel developer to do this if you
want it to happen automatically.

(david)





.