PC Review


Reply
Thread Tools Rate Thread

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

 
 
Owl
Guest
Posts: n/a
 
      9th Apr 2010
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.
 
Reply With Quote
 
 
 
 
Tom van Stiphout
Guest
Posts: n/a
 
      9th Apr 2010
On Fri, 9 Apr 2010 04:14:01 -0700, Owl <(E-Mail Removed)>
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


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

 
Reply With Quote
 
Owl
Guest
Posts: n/a
 
      9th Apr 2010
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" wrote:

> On Fri, 9 Apr 2010 04:14:01 -0700, Owl <(E-Mail Removed)>
> 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
>
>
> >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.

> .
>

 
Reply With Quote
 
Tom van Stiphout
Guest
Posts: n/a
 
      10th Apr 2010
On Fri, 9 Apr 2010 15:19:01 -0700, Owl <(E-Mail Removed)>
wrote:

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



>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" wrote:
>
>> On Fri, 9 Apr 2010 04:14:01 -0700, Owl <(E-Mail Removed)>
>> 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
>>
>>
>> >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.

>> .
>>

 
Reply With Quote
 
Owl
Guest
Posts: n/a
 
      10th Apr 2010
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.


"Tom van Stiphout" wrote:

> On Fri, 9 Apr 2010 15:19:01 -0700, Owl <(E-Mail Removed)>
> wrote:
>
> 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
>
>
>
> >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" wrote:
> >
> >> On Fri, 9 Apr 2010 04:14:01 -0700, Owl <(E-Mail Removed)>
> >> 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
> >>
> >>
> >> >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.
> >> .
> >>

> .
>

 
Reply With Quote
 
david
Guest
Posts: n/a
 
      13th Apr 2010
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" <(E-Mail Removed)> wrote in message
news:7496A9AB-94AC-4544-BF41-(E-Mail Removed)...
> 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.



 
Reply With Quote
 
Owl
Guest
Posts: n/a
 
      21st Apr 2010
Thank you very much for this information, David.

"david" wrote:

> 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" <(E-Mail Removed)> wrote in message
> news:7496A9AB-94AC-4544-BF41-(E-Mail Removed)...
> > 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.

>
>
> .
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Bank Account Database Design Joe Williams Microsoft Access Form Coding 5 13th Mar 2011 02:16 AM
BCM account creation not getting linked into Accounting devilgas Microsoft Outlook BCM 4 23rd Sep 2008 02:30 AM
Bank account database & sum of column Rasoul Khoshravan Azar Microsoft Access Queries 2 4th Feb 2006 03:46 AM
Bank account database & sum of column Rasoul Khoshravan Azar Microsoft Access Getting Started 2 4th Feb 2006 03:46 AM
Trying to access online bank account chris casartelli Windows XP Help 4 12th Sep 2005 03:09 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:02 PM.