ACCESS FEED

Rabu, 06 November 2024

Re: [MSAccessProfessionals] Moving contacts from Access to outlook

Bill

Take a look at this:

https://support.microsoft.com/en-us/office/import-or-link-to-contacts-from-an-outlook-address-book-e2ff9669-5b95-483e-be8d-83590c2085a3

Regards,

Bill Mosca

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Bill Singer via groups.io
Sent: Sunday, November 3, 2024 6:36 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Moving contacts from Access to outlook

Bill,

Let me know more. I did some reading on the link that was provided to me and I do believe I am in over my head.

Bill

Bill Singer

From: MSAccessProfessionals@groups.io On Behalf Of Bill Mosca via groups.io
Sent: Sunday, November 3, 2024 4:53 PM
To: MSAccessProfessionals@groups.io; MSAccessProfessionals@groups.io <digestnoreply@groups.io>
Subject: Re: [MSAccessProfessionals] Moving contacts from Access to outlook

I know you've got a response on this, but did you know you can link to your contacts as if it were an external table. At least, I've done it in the past.

Regards,

Bill Mosca

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Bill Singer via groups.io <Bill.Singer=at-group.net@groups.io>
Sent: Friday, November 1, 2024 8:24:21 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: [MSAccessProfessionals] Moving contacts from Access to outlook

This January when work is slow I really want to add the ability for my Access Database to open access and input my Access Contacts to my Outlook Contacts.

However, I need help. Does anyone have anything like this that I can use to start with.

Thanks.

Office 365

Window 11

Bill

Bill Singer

Minggu, 03 November 2024

Re: [MSAccessProfessionals] Moving contacts from Access to outlook

Bill,

Let me know more. I did some reading on the link that was provided to me and I do believe I am in over my head.

Bill

Bill Singer

I know you've got a response on this, but did you know you can link to your contacts as if it were an external table. At least, I've done it in the past.

Regards,

Bill Mosca

This January when work is slow I really want to add the ability for my Access Database to open access and input my Access Contacts to my Outlook Contacts.

However, I need help. Does anyone have anything like this that I can use to start with.

Thanks.

Office 365

Window 11

Bill

Bill Singer

Re: [MSAccessProfessionals] Moving contacts from Access to outlook

I know you've got a response on this, but did you know you can link to your contacts as if it were an external table. At least, I've done it in the past.

Regards,

Bill Mosca

This January when work is slow I really want to add the ability for my Access Database to open access and input my Access Contacts to my Outlook Contacts.

However, I need help. Does anyone have anything like this that I can use to start with.

Thanks.

Office 365

Window 11

Bill

Bill Singer

Jumat, 01 November 2024

Re: [MSAccessProfessionals] Moving contacts from Access to outlook

I automate Outlook email all the time, you'd just be dealing with contact items instead of email. See if this gets you started:

https://learn.microsoft.com/en-us/office/vba/outlook/concepts/getting-started/automating-outlook-from-a-visual-basic-application

Paul

------ Original Message ------

From: "Bill Singer via groups.io" <Bill.Singer=at-group.net@groups.io>

To: MSAccessProfessionals@groups.io

Sent: 11/1/2024 8:24:00 AM

Subject: [MSAccessProfessionals] Moving contacts from Access to outlook

This January when work is slow I really want to add the ability for my Access Database to open access and input my Access Contacts to my Outlook Contacts.

However, I need help. Does anyone have anything like this that I can use to start with.

Thanks.

Office 365
Window 11

Bill

Bill Singer

[MSAccessProfessionals] Moving contacts from Access to outlook

This January when work is slow I really want to add the ability for my Access Database to open access and input my Access Contacts to my Outlook Contacts.

However, I need help. Does anyone have anything like this that I can use to start with.

Thanks.

Office 365

Window 11

Bill

Bill Singer

Minggu, 27 Oktober 2024

Re: [MSAccessProfessionals] Calculate overnight electricity consumption

Hi Duane,

Thank you so much for your help. It works perfectly as shown in the output below.

ActivityDate	Activity	Residents	StartTime	FinishTime	InitialReading	FinalReading	Consumption	OverNight
22/10/2024	Normal + cook	2	06:00	20:00	322.87	307.28	15.59	6.55
23/10/2024	Normal + laundry	2	06:00	20:00	300.04	284.04	16.00	7.24
24/10/2024	Normal + cook + pump	2	06:00	20:00	274.00	255.30	18.70	10.04
25/10/2024	Normal	2	06:00	20:00	249.38	234.38	15.00	5.92
26/10/2024	Normal + pump	2	06:00	20:00	228.42	211.41	17.01	5.96

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_

Sabtu, 26 Oktober 2024

Re: [MSAccessProfessionals] Calculate overnight electricity consumption

It looks like readings decrease through the day. Does this work for you? I changed column names to remove spaces and made up a table name.

SELECT ElectricityConsumption.ActivityDate, ElectricityConsumption.Activity, ElectricityConsumption.Residents,

ElectricityConsumption.StartTime, ElectricityConsumption.FinishTime, ElectricityConsumption.InitialReading,

ElectricityConsumption.FinalReading, ElectricityConsumption.Consumption,

(SELECT FinalReading FROM ElectricityConsumption C

WHERE ElectricityConsumption.ActivityDate = C.ActivityDate +1)-[InitialReading] AS OverNight

FROM ElectricityConsumption;

Duane

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of asanteza@gmail.com <asanteza@gmail.com>
Sent: Friday, October 25, 2024 11:33 PM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: [MSAccessProfessionals] Calculate overnight electricity consumption

Hi Everyone,

I am trying to keep a database of my prepaid electricity consumption in MS Access 2019 version. As the table shows, I am able to calculate the daily usage from the initial and final readings of my meter. However, I am struggling to figure out the formula for Overnight usage (Final reading of previous day minus Initial reading of current day).

Activity date	Activity	Residents	Start time	Finish time	Initial reading	Final reading	Consumption	Overnight
21/10/2024	Normal + laundry	2	06:00	20:00	348.20	329.42	18.78
22/10/2024	Normal + cook	2	06:00	20:00	322.87	307.28	15.59
23/10/2024	Normal + laundry	2	06:00	20:00	300.04	284.04	16.00
24/10/2024	Normal + cook + pump	2	06:00	20:00	274.00	255.30	18.70
25/10/2024	Normal	2	06:00	20:00	249.38	234.38	15.00