Kamis, 02 Maret 2017

Re:RE: [MS_AccessPros] How to get the path of the front end by code?

 

Graham-
Thanks a lot.
Best Regards,
Kevin



发自我的小米手机
在 "'Graham Mandeno' graham@mandeno.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>，2017年3月2日 16:01写道：

 

Hi Kevin

 

The easiest way is CurrentProject.Path.

 

Best wishes,

Graham

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, 2 March 2017 19:01
To: ms_access_professionals <ms_access_professionals@yahoogroups.com>
Subject: [MS_AccessPros] How to get the path of the front end by code?

 

 

Dear All,

Would you please tell me how to get the path of the front end by code. By the way, there's no tables in the front end. The reason for doing this is that I want to create folders in the folder where the front end locates. Thanks in advance.

Best Regards,

Kevin

__._,_.___
Posted by: qingqinga <qingqinga@yahoo.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (3)
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

.

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

Rabu, 01 Maret 2017

RE: [MS_AccessPros] How to get the path of the front end by code?

 

Hi Kevin

 

The easiest way is CurrentProject.Path.

 

Best wishes,

Graham

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, 2 March 2017 19:01
To: ms_access_professionals <ms_access_professionals@yahoogroups.com>
Subject: [MS_AccessPros] How to get the path of the front end by code?

 

 

Dear All,

Would you please tell me how to get the path of the front end by code. By the way, there's no tables in the front end. The reason for doing this is that I want to create folders in the folder where the front end locates. Thanks in advance.

Best Regards,

Kevin

__._,_.___
Posted by: "Graham Mandeno" <graham@mandeno.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (2)
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

.

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

[MS_AccessPros] How to get the path of the front end by code?

 

Dear All,
Would you please tell me how to get the path of the front end by code. By the way, there's no tables in the front end. The reason for doing this is that I want to create folders in the folder where the front end locates. Thanks in advance.
Best Regards,
Kevin

__._,_.___
Posted by: qingqinga <qingqinga@yahoo.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (1)
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

.

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

[MS_AccessPros] SQL Statements documentation

 

Hello all,


I was looking for the SQL statements in the System tables and I could not find them. But they are an option to show in the documenter. Where are the statements stored?


Thank You


Jim Wagner

__._,_.___
Posted by: luvmymelody@yahoo.com
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (1)
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

.

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

Re: [MS_AccessPros] Formatting disapperas on calculated fields

 

Perfect, thank you very much.

I thought that calculated fields were automatically set to locked yest and enable no.

This is a good way to fix the problem I have.

I wonder why it does what it does now.

It makes the formatting go away.

I think that is kind of weird.

Jorge


On Wednesday, March 1, 2017 8:22 AM, "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:


 
Jorge-

First, it's never a good idea to store calculated values in a table.  If the calculations are based on other data in the table, it's better to build a query to do the calculations.

Having said that, why would you want to be able to click in calculated fields?  If you're displaying the data in a form, you can set Enabled = No to prevent clicking in the control that displays the field.

John Viescas, Author
Effective SQL
SQL Queries for Mere Mortals 
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
http://www.viescas.com/ 
(Paris, France)




On Mar 1, 2017, at 3:11 PM, muralles_r12@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:



Hi Folks, I hope you are well.

I need some help.

I have a table a use to calculate the cost and percentage profits for my products.

I know this might not be the best design but it works for me.

This table has some calculated fields.

Most of the currency one is a number I display as percentage.

The form looks good, but when I click the calculated fields, the formatting disappears.

So the currency fields do not show the $ sign and the percentage field shows the number as decimals with out the % sign.

Thanks for the help.

Jorge Muralles








__._,_.___
Posted by: <muralles_r12@yahoo.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (3)
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

.

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

Re: [MS_AccessPros] Formatting disapperas on calculated fields

 

Jorge-


First, it's never a good idea to store calculated values in a table.  If the calculations are based on other data in the table, it's better to build a query to do the calculations.

Having said that, why would you want to be able to click in calculated fields?  If you're displaying the data in a form, you can set Enabled = No to prevent clicking in the control that displays the field.

John Viescas, Author
Effective SQL
SQL Queries for Mere Mortals 
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
(Paris, France)




On Mar 1, 2017, at 3:11 PM, muralles_r12@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:



Hi Folks, I hope you are well.

I need some help.

I have a table a use to calculate the cost and percentage profits for my products.

I know this might not be the best design but it works for me.

This table has some calculated fields.

Most of the currency one is a number I display as percentage.

The form looks good, but when I click the calculated fields, the formatting disappears.

So the currency fields do not show the $ sign and the percentage field shows the number as decimals with out the % sign.

Thanks for the help.

Jorge Muralles






__._,_.___
Posted by: John Viescas <johnv@msn.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (2)
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

.

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

[MS_AccessPros] Formatting disapperas on calculated fields

 

Hi Folks, I hope you are well.

I need some help.

I have a table a use to calculate the cost and percentage profits for my products.

I know this might not be the best design but it works for me.

This table has some calculated fields.

Most of the currency one is a number I display as percentage.

The form looks good, but when I click the calculated fields, the formatting disappears.

So the currency fields do not show the $ sign and the percentage field shows the number as decimals with out the % sign.

Thanks for the help.

Jorge Muralles



__._,_.___
Posted by: muralles_r12@yahoo.com
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (1)
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

.

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