Jumat, 30 November 2018

[AccessDevelopers] File - Monthly_Notices.txt

 


Monthly notices:

Hi Kids!:

Don't forget to check out our "Links" section at the website for helpful sites. Also take a peek at books that others have found worthwhile in our books database under the 'Database' link of the main AccessDevelopers page. Feel free to add any books or links that you have found useful.

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (173)

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.


Please zip all files prior to uploading to Files section.

SPONSORED LINKS
.

__,_._,___

Kamis, 29 November 2018

Re: [MS_AccessPros] Associate a image to command button

 

hi Art,

adding on to Duane's comment:

To specify a picture for a command button:

1. select the command button

2. in the property sheet, click Picture (Format tab)
and then the builder button ... on the right, or press Ctrl-F2
When Picture Builder dialog box opens with pictures you can choose, click the "Browse..." command button to pick a file.

3. When the file dialog boxs opens, by default it will display BMP files but maybe what you have is a JPG or PNG. In the lower right, to see all files, change to "All Files (*.*)" Access handles BMP files the best, however (I get errors picking other file types). You can use Paint to Save As BMP.

4. Now that the button has a Picture, you can set the Caption property for the text

5. and then the Picture Caption Arrangement property for the location of text with relationship to the picture (ie: Top, Bottom, Left, Right)

6. You can add spaces before or after the Caption if you want.
No-break space, in case you need it, is 160:
ï؟½ï؟½ a.ï؟½ press and hold ALT
ï؟½ï؟½ï؟½ b. type 0160 on the numeric keypad
ï؟½ï؟½ï؟½ c. release ALT

7. If you want more space around the picture, add space in the picture file when you save it.

You could also, as Duane mentioned, add text to the picture when you save it (instead of using Caption and Picture Caption Arrangement ) -- that way, you can position text as you like by the picture.

~~~
On a menu where there aren't any data controls, you could probably just use all Image controls (instead of command Button) and there shouldn't be problems with Click in those cases. Problems sometimes happen when there are other control types since Image controls can't take the focus.

~crystal


On 11/29/2018 12:54 PM, Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals] wrote:
I would simply create the image required in an application that allows you to mix text and images. Then use the image on the button. You shouldn't need to modify this at run time.

Duane

From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of Art Lorenzini dbalorenzini@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Thursday, November 29, 2018 11:30 AM
To: crystal 8 strive4peace2008@yahoo.com [MS_Access_Professionals]
Subject: Re: [MS_AccessPros] Associate a image to command button
ï؟½


I see what is happening. If the command button is the default when the screen opens or the button is clicked, I lose my image. I have put up a screen shot in Needs Assistance for y our revies


With Warm Regards,
ï؟½
Arthur D. Lorenzini
IT System Manager
Cheyenne River Housing Authority
Wk.(605)964-4265ï؟½ Ext. 130
Fax (605)964-1070

"Valar Dohaerisï؟½






On ï؟½Thursdayï؟½, ï؟½Novemberï؟½ ï؟½29ï؟½, ï؟½2018ï؟½ ï؟½01ï؟½:ï؟½36ï؟½:ï؟½24ï؟½ ï؟½AMï؟½ ï؟½CST, crystal 8 strive4peace2008@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:


ï؟½

hi Art,

command buttons have a PICTURE property for an image.

btw, I uploaded another version of MyContacts today -- enhanced the list functionality. This version is a lot more simple than the other one.

http://msaccessgurus.com/tool/MyContacts.htm

respectfully,
crystal

On 11/28/2018 5:10 PM, dbalorenzini@yahoo.com [MS_Access_Professionals] wrote:
Is there a way to associate and image object to a command button? I was able to do it with a label control. What I am doing is I have created a command button and overlaid it with a label and an image. The label works but the image acts like its being covered up by the command button. I am doing this to customize the look of the command button.

Any ideas?

Thank youï؟½

Art Lorenzini
Sioux Falls, SD


__._,_.___

Posted by: crystal 8 <strive4peace2008@yahoo.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (8)

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.


SPONSORED LINKS
.

__,_._,___

Re: [MS_AccessPros] Associate a image to command button

 

I would simply create the image required in an application that allows you to mix text and images. Then use the image on the button. You shouldn't need to modify this at run time.

Duane

From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of Art Lorenzini dbalorenzini@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Thursday, November 29, 2018 11:30 AM
To: crystal 8 strive4peace2008@yahoo.com [MS_Access_Professionals]
Subject: Re: [MS_AccessPros] Associate a image to command button
 


I see what is happening. If the command button is the default when the screen opens or the button is clicked, I lose my image. I have put up a screen shot in Needs Assistance for y our revies


With Warm Regards,
 
Arthur D. Lorenzini
IT System Manager
Cheyenne River Housing Authority
Wk.(605)964-4265  Ext. 130
Fax (605)964-1070

"Valar Dohaeris"






On ‎Thursday‎, ‎November‎ ‎29‎, ‎2018‎ ‎01‎:‎36‎:‎24‎ ‎AM‎ ‎CST, crystal 8 strive4peace2008@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:


 

hi Art,

command buttons have a PICTURE property for an image.

btw, I uploaded another version of MyContacts today -- enhanced the list functionality. This version is a lot more simple than the other one.

http://msaccessgurus.com/tool/MyContacts.htm

respectfully,
crystal

On 11/28/2018 5:10 PM, dbalorenzini@yahoo.com [MS_Access_Professionals] wrote:
Is there a way to associate and image object to a command button? I was able to do it with a label control. What I am doing is I have created a command button and overlaid it with a label and an image. The label works but the image acts like its being covered up by the command button. I am doing this to customize the look of the command button.

Any ideas?

Thank you 

Art Lorenzini
Sioux Falls, SD


__._,_.___

Posted by: Duane Hookom <duanehookom@hotmail.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (7)

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.


SPONSORED LINKS
.

__,_._,___

[MS_AccessPros] New file uploaded to MS_Access_Professionals

 

Hello,

This email message is a notification to let you know that
a file has been uploaded to the Files area of the MS_Access_Professionals
group.

File : /2_AssistanceNeeded/Main Menu 2.png
Uploaded by : dbalorenzini <dbalorenzini@yahoo.com>
Description : Missing Image object

You can access this file at the URL:
https://groups.yahoo.com/neo/groups/MS_Access_Professionals/files/2_AssistanceNeeded/Main%20Menu%202.png

To learn more about file sharing for your group, please visit:
https://help.yahoo.com/kb/index?page=content&y=PROD_GRPS&locale=en_US&id=SLN15398

Regards,

dbalorenzini <dbalorenzini@yahoo.com>

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1152)

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.


SPONSORED LINKS
.

__,_._,___

Re: [MS_AccessPros] Associate a image to command button

 

Art,
An image controls  have a On Click events. Can't you use this? 

You can also place a transparent command button on top of an image control.

Regards,
Duane

From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of Art Lorenzini dbalorenzini@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Thursday, November 29, 2018 8:47 AM
To: crystal 8 strive4peace2008@yahoo.com [MS_Access_Professionals]
Subject: Re: [MS_AccessPros] Associate a image to command button
 


The PICTURE property of the command button does not allow for the manipulation of the size of the picture or other properties that an image object gives you. Your new Contacts looks great. I can't wait to go through it.


With Warm Regards,
 
Arthur D. Lorenzini
IT System Manager
Cheyenne River Housing Authority
Wk.(605)964-4265  Ext. 130
Fax (605)964-1070

"Valar Dohaeris"






On ‎Thursday‎, ‎November‎ ‎29‎, ‎2018‎ ‎01‎:‎36‎:‎24‎ ‎AM‎ ‎CST, crystal 8 strive4peace2008@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:


 

hi Art,

command buttons have a PICTURE property for an image.

btw, I uploaded another version of MyContacts today -- enhanced the list functionality. This version is a lot more simple than the other one.

http://msaccessgurus.com/tool/MyContacts.htm

respectfully,
crystal

On 11/28/2018 5:10 PM, dbalorenzini@yahoo.com [MS_Access_Professionals] wrote:
Is there a way to associate and image object to a command button? I was able to do it with a label control. What I am doing is I have created a command button and overlaid it with a label and an image. The label works but the image acts like its being covered up by the command button. I am doing this to customize the look of the command button.

Any ideas?

Thank you 

Art Lorenzini
Sioux Falls, SD


__._,_.___

Posted by: Duane Hookom <duanehookom@hotmail.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (5)

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.


SPONSORED LINKS
.

__,_._,___