Invoices Access

[Silviall]

Hello,

I'm new in Access, I've design a database in Access 2003, table tasks,
clients, prices. Now I would like to create the invoice automatically. Is it
possible?. I have tasks in the outlook with hours can I download they in
Access automatically?
Could you give me some ideas?

My apologize for my English,

Thanks for all,

SilviaLl.

 

[SJ]

I think your going to have to be a bit more specific.

You can do most things in Access, including linking to outlook, but you are
going to need to get some programming skills because you might need to
troubleshoot this in the future.

All you've said so far is that you have 3 tables in Access.
Then you ask "can i create the invoice automatically" what invoice?

As far as outlook goes, set a reference to the outlook type library and
declare some variables like this
Dim objOutlook As Outlook.Application
Dim objOutlookMsg As Outlook.MailItem
Dim objOutlookRecip As Outlook.Recipient
Dim objOutlookAttach As Outlook.Attachment

you will probably want a Dim objOutlookTask As Outlook.Task

then have a play around...

if you can't do that , or don't know what i mean, then you had better get
someone else to do it.

 

[Silviall]

Hello,

I always program with vb .net 2005, but now I need to do a program with
access.
The database has a lot of tables like client, tasks, prices, and others. I
would like that I can do month invoices automatically, it generates excel,
access reports for all clients.

Thanks for all,

SilviaLl.