Senin, 21 September 2020

Re: [MSAccessProfessionals] Mouse ShorCut Problem

Hi Ahmed

If I understand your original question correctly, the problem is not that your database won't open, but that if you add /runtime to the command like the default right-click menus will not work. 

Am I correct?  If so, the problem is that "by design" (?!!) all built-in shortcut menus are disabled in runtime mode.  You need to create your own.

Best wishes,
Graham Mandeno [Access MVP 1996-2017]

 

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Neil Woodnick
Sent: Tuesday, 22 September 2020 10:02
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Mouse ShorCut Problem

 

remember that an ACCDE file built by a 32-bit version of Access can't be opened by a 64-bit version, and the same is true in reverse—ACCDE files created out of a 64-bit version of MS Access must be opened with another 64-bit version of the program.

 

Sent from Mail for Windows 10

 

From: ahmad beshari via groups.io
Sent: 21 September 2020 21:32
To: msaccessprofessionals@groups.io; MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Mouse ShorCut Problem

 

Arnelito Puzon

I am using Accde file not Accdb Can you try this please?

Ahmed

On Monday, September 21, 2020, 04:13:34 AM GMT+2, Arnelito Puzon <agpuzon@gmail.com> wrote:

 

 

how was the shortcut made?

this runs ok from my pc.

see the delimiters.

"C:\Program Files\Microsoft Office\root\Office16\MSACCESS.EXE" C:\Users\agpuz\OneDrive\Documents\mouseHover.accdb /runtime

 

On Mon, Sep 21, 2020 at 12:46 AM ahmad beshari via groups.io <a1_beshari=yahoo.com@groups.io> wrote:

Dears

I have an application i run it using shortcut on desktop if i add the command line /runtime the application shortcutmenu will not work

Please if any body can help

Ahmed

 


 

--

Arnelito G. Puzon

 

Diposting oleh di Tidak ada komentar:

Re: [MSAccessProfessionals] Mouse ShorCut Problem

remember that an ACCDE file built by a 32-bit version of Access can't be opened by a 64-bit version, and the same is true in reverse—ACCDE files created out of a 64-bit version of MS Access must be opened with another 64-bit version of the program.

 

Sent from Mail for Windows 10

 

From: ahmad beshari via groups.io
Sent: 21 September 2020 21:32
To: msaccessprofessionals@groups.io; MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Mouse ShorCut Problem

 

Arnelito Puzon

I am using Accde file not Accdb Can you try this please?

Ahmed

On Monday, September 21, 2020, 04:13:34 AM GMT+2, Arnelito Puzon <agpuzon@gmail.com> wrote:

 

 

how was the shortcut made?

this runs ok from my pc.

see the delimiters.

"C:\Program Files\Microsoft Office\root\Office16\MSACCESS.EXE" C:\Users\agpuz\OneDrive\Documents\mouseHover.accdb /runtime

 

On Mon, Sep 21, 2020 at 12:46 AM ahmad beshari via groups.io <a1_beshari=yahoo.com@groups.io> wrote:

Dears

I have an application i run it using shortcut on desktop if i add the command line /runtime the application shortcutmenu will not work

Please if any body can help

Ahmed

 


 

--

Arnelito G. Puzon

 

Diposting oleh di Tidak ada komentar:

Re: [MSAccessProfessionals] Mouse ShorCut Problem

Arnelito Puzon
I am using Accde file not Accdb Can you try this please?
Ahmed
On Monday, September 21, 2020, 04:13:34 AM GMT+2, Arnelito Puzon <agpuzon@gmail.com> wrote:


how was the shortcut made?
this runs ok from my pc.
see the delimiters.
"C:\Program Files\Microsoft Office\root\Office16\MSACCESS.EXE" C:\Users\agpuz\OneDrive\Documents\mouseHover.accdb /runtime

On Mon, Sep 21, 2020 at 12:46 AM ahmad beshari via groups.io <a1_beshari=yahoo.com@groups.io> wrote:
Dears
I have an application i run it using shortcut on desktop if i add the command line /runtime the application shortcutmenu will not work
Please if any body can help
Ahmed



--
Arnelito G. Puzon


Diposting oleh di Tidak ada komentar:

Minggu, 20 September 2020

Re: [MSAccessProfessionals] Mouse ShorCut Problem

how was the shortcut made?
this runs ok from my pc.
see the delimiters.
"C:\Program Files\Microsoft Office\root\Office16\MSACCESS.EXE" C:\Users\agpuz\OneDrive\Documents\mouseHover.accdb /runtime

On Mon, Sep 21, 2020 at 12:46 AM ahmad beshari via groups.io <a1_beshari=yahoo.com@groups.io> wrote:
Dears
I have an application i run it using shortcut on desktop if i add the command line /runtime the application shortcutmenu will not work
Please if any body can help
Ahmed



--
Arnelito G. Puzon


_._,_._,_
Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#115755) | Reply To Group | Reply To Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_
Diposting oleh di Tidak ada komentar:

Re: Fw: [MS_AccessPros] MAX AND STANDARD DEVIATION

 

hi Ade,

here is a simplified idea you can adapt :

SELECT q.* FROM [queryname] as q
WHERE ( q.[field6] = dMax("field6", "queryname", "field7=""" & q.[field7] & """") )
OR ( q.[field6] = dMin("field6", "queryname", "field7=""" & qfield7] & """") )

kind regards,
crystal

Add New Data with NotInList VBA for Combo box (7:24)
https://www.youtube.com/watch?v=gwZt5pb62K4


On 11/27/2019 7:17 AM, Adeboyejo Oyenuga aoye_99@yahoo.co.uk [MS_Access_Professionals] wrote:
Hi Duane and all,

kindly help with the modification I need to make to the query below if I only want to return the records having the highest ( or lowest) value in field 6 when field 7 for all such records are the same.

I simplified the case to ease the solution.

Thanks.

Ade

----- Forwarded message -----
From: Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals] <ms_access_professionals@yahoogroups.com>
Sent: Monday, 9 March 2015, 13:20:57 GMT
Subject: RE: [MS_AccessPros] MAX AND STANDARD DEVIATION

 

Ade,
 
Any time you wish to calculate across fields, it suggests an un-normalized table structure. For your current table (if you can't change your structure), I would suggest first adding a primary key field if you don't have one and then creating a normalizing union query.
 
SELECT PKField, 1 as Fld, Field1 as TheValue
FROM tblTransactions
UNION ALL
SELECT PKField, 2, Field2
FROM tblTransactions
UNION ALL
SELECT PKField, 3, Field3
FROM tblTransactions
UNION ALL
SELECT PKField, 4, Field4
FROM tblTransactions
UNION ALL
SELECT PKField, 5, Field5
FROM tblTransactions
UNION ALL
SELECT PKField, 6, Field6
FROM tblTransactions
UNION ALL
SELECT PKField, 7, Field7
FROM tblTransactions;
 
You can then use this query in a totals query and group by the PKField and use SQL aggregate functions for your calculations.
 
SELECT PKField, Max(Thevalue) as MaxValue, Stdev(TheValue) as StandDev
FROM quniTransactions
GROUP BY PKField;
 
Duane Hookom MVP
MS Access

 
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Mon, 9 Mar 2015 10:59:52 +0000
Subject: [MS_AccessPros] MAX AND STANDARD DEVIATION



Hello all,

just to see if you could help out with applying the Max and StDev function across a record.

For ease of reference, hypothetical but relevant transactions are shown below.


 Field1 Field2 Field3 Field4 Field5 Field6 Field7
Record1 12 15 25 19 37 20 14
Record2 1 8 50 21 17 45 38
Record3 2 15 33 47 29 30 31


Thanks.

Ade



__._,_.___
Posted by: crystal viii <strive4peace2008@yahoo.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (2)

.

__,_._,___
Diposting oleh di Tidak ada komentar:

[MSAccessProfessionals] Mouse ShorCut Problem

Dears
I have an application i run it using shortcut on desktop if i add the command line /runtime the application shortcutmenu will not work
Please if any body can help
Ahmed

Diposting oleh di Tidak ada komentar:

Selasa, 01 September 2020

Re: [MSAccessProfessionals] Query & Report by Grouped by Name and Sorted by Date

Hi Duane and Jim:

After working most of the day confused, I submitted this question.  I finally figured it out and yes, it was the group/sort at the bottom of the report.

Thank you all for your help AND responding so quickly.  I have been a member of the Yahoo group for along time and it sent me to this group.  I'm glad it did!  

Celeste
_._,_._,_
Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#115753) | Reply To Group | Reply To Sender | Mute This Topic | New Topic

Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_
Diposting oleh di Tidak ada komentar:

Re: [MSAccessProfessionals] Query & Report by Grouped by Name and Sorted by Date

Hello Celeste,

Sometimes changing names messes with the group/sort that is set up. did you check the group/sort at the bottom of the report in design view to make sure that the grouping is not showing "Expression" instead of the name you changed it to?

Jim Wagner
From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of celestecpa <bcpatin@gmail.com>
Sent: Tuesday, September 1, 2020 2:07 PM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: [MSAccessProfessionals] Query & Report by Grouped by Name and Sorted by Date
 
MS Access 365 Pro Plus

I have a query listing names, product number and dates.
I want to group by names, but when I run the report, it breaks on each date that is different.

I had this report working and then I changed the name of a field and it now prints name, product for one date, then goes to the next person. 

Please help.

Thanks you,

Celeste
Diposting oleh di Tidak ada komentar:

Re: [MSAccessProfessionals] Query & Report by Grouped by Name and Sorted by Date

Hi Celeste,
The "breaks" are controlled by the Sorting and Grouping in the report design. Can you provide additional information about how this is set up in your report?

Do you have a fields named "Name" or "Date"?

Regards,
Duane

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of celestecpa <bcpatin@gmail.com>
Sent: Tuesday, September 1, 2020 4:07 PM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: [MSAccessProfessionals] Query & Report by Grouped by Name and Sorted by Date
 
MS Access 365 Pro Plus

I have a query listing names, product number and dates.
I want to group by names, but when I run the report, it breaks on each date that is different.

I had this report working and then I changed the name of a field and it now prints name, product for one date, then goes to the next person. 

Please help.

Thanks you,

Celeste
Diposting oleh di Tidak ada komentar:

[MSAccessProfessionals] Query & Report by Grouped by Name and Sorted by Date

MS Access 365 Pro Plus

I have a query listing names, product number and dates.
I want to group by names, but when I run the report, it breaks on each date that is different.

I had this report working and then I changed the name of a field and it now prints name, product for one date, then goes to the next person. 

Please help.

Thanks you,

Celeste
_._,_._,_
Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#115750) | Reply To Group | Reply To Sender | Mute This Topic | New Topic

Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_
Diposting oleh di Tidak ada komentar:

[belajar-access] File - Tata Tertib dan Aturan.txt

 


Tata tertib dan peraturan
Mailing List: belajar-access@yahoogroups.com

1. Mailing list ini membahas mengenai pemrograman Microsoft Access.
2. Tidak diperkenankan mem-posting topik yang tidak ada kaitannya sama sekali dengan pemrograman MS Access, peluang kerja atau tawaran kerja sama dengan keahlian di bidang MS Access, atau pengajaran/kursus MS Acces. Pelanggaran terhadap aturan ini akan di-ban dari keanggotaan milis ini.
3. Mohon berdiskusi dengan baik, dengan semangat membangun, demi kemajuan kita bersama. Hindarilah perbantahan (flame) yang bisa menjadi pertengkaran yang tidak perlu.
4 Hindari reply permintaan one-liner seperti 'saya minta juga dong', 'saya setuju', dan lain-lain yang tidak perlu.
5. Sedapat mungkin memberikan data-data yang lengkap dalam mengajukan suatu masalah untuk memudahkan rekan-rekan sesama member mengidentifikasi dan mencarikan solusi, termasuk memberikan subject yang sesuai dengan isi email, tidak dengan kata-kata seperti "tologing dong", "pusing...", "ada yang bisa bantu..", dll.

Moderator

__._,_.___
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (162)
SPAM IS PROHIBITED

.

__,_._,___
Diposting oleh di Tidak ada komentar:
Langganan: Postingan (Atom)