Senin, 30 November 2015

RE: [MS_AccessPros] Re: weird page visibility issue

 

Liz


I can sympathize. I've got dye eye syndrome and blur up from time to time so much I can't read anything on my monitor.

Just remember, a tab control has pages. Why they are not called tabs, Mosca don't know. Mosca only pawn in game of life.


Bill


---In MS_Access_Professionals@yahoogroups.com, <liz_ravenwood@beaerospace.com> wrote :

Bill, THANKS! 

 

Okay, you want to know something embarrassing?  I selected the tab control to see what the name was so I could follow this syntax and guess what?  I had named it "Archiving."  So  yes, I was effectively setting the whole thing to invisible. 

 

In my defense.  I have multiple eye issues with the latest being meibomian gland dysfunction.

 

Arrgh.

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Monday, November 30, 2015 1:03 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: weird page visibility issue

 



Liz

 

You have to refer to the tab control's Pages.

Me.myTab.Pages("Archive").Visible = False

 

Regards,

Bill Mosca, Founder - MS_Access_Professionals

Microsoft Office Access MVP

My nothing-to-do-with-Access blog

 

 






This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

__._,_.___
Posted by: wrmosca@comcast.net
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (6)

.

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

RE: [MS_AccessPros] Re: weird page visibility issue

 

Bill, THANKS! 

 

Okay, you want to know something embarrassing?  I selected the tab control to see what the name was so I could follow this syntax and guess what?  I had named it "Archiving."  So  yes, I was effectively setting the whole thing to invisible. 

 

In my defense.  I have multiple eye issues with the latest being meibomian gland dysfunction.

 

Arrgh.

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Monday, November 30, 2015 1:03 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: weird page visibility issue

 



Liz

 

You have to refer to the tab control's Pages.

Me.myTab.Pages("Archive").Visible = False

 

Regards,

Bill Mosca, Founder - MS_Access_Professionals

Microsoft Office Access MVP

My nothing-to-do-with-Access blog

 

 






This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

__._,_.___
Posted by: Liz Ravenwood <Liz_Ravenwood@beaerospace.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (5)

.

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

RE: [MS_AccessPros] Re: disable keyboard

 


until someone thinks to copy/paste the input...

---In MS_Access_Professionals@yahoogroups.com, <liz_ravenwood@...> wrote :

I guess I'm not getting the "right time" Bill since I need to do a txtInput.setfocus and well, there's the rub.

 

BUT…  I wrote a little piece of code that has tested out in development that is on the keypress event that accrues the time and if it is > 20 milliseconds I know it is manual entry and if it is less then I know it is from the scanner.

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Wednesday, November 25, 2015 2:53 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: disable keyboard

 



Liz

 

Yes, unless you disable it...like I told you.

Me.lblFake.Visible = False

Me.txtuserName.Enabled = False

 

Of course, you have to reverse that stuff at the right time so you are back to the label showing on top.

 

-Bill



---In MS_Access_Professionals@yahoogroups.com, <liz_ravenwood@...> wrote :

Hey Bill, I'm finally to this stage of the project and it all looks pretty good and well, but when the focus is on the underlying text box, it is exposed to keyboard entry too.

Hmmmmm…..

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Wednesday, November 18, 2015 3:18 PM
To: MS Access Professionals
Subject: Re: [MS_AccessPros] Re: disable keyboard

 



Yes, that's my suggestion. By putting a label over the text box, the user can't enter anything there. But the scanner should be able to "see" it and enter the number. The AfterUpdate event would hide the label thus exposing the text box. Then you disable the box so the user can't change it.

 

Regards,

Bill Mosca

From: "Liz Ravenwood liz_ravenwood@... [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>
To: "MS_Access_Professionals@yahoogroups.com" <MS_Access_Professionals@yahoogroups.com>
Sent: Wednesday, November 18, 2015 1:23:37 PM
Subject: RE: [MS_AccessPros] Re: disable keyboard

 

 

Is this it?

"hmm... Maybe use a label as a dummy place holder with a text box behind it. use the AfterUpdate event to hide the label and switch the text box to disabled."

 

I'm not sure this would work.  I have a text box where the requirements request is to only allow the input of that text box to come from a scan gun and not from the keyboard.  That way, the operator scans in the number and can't fudge someone else number.

 

 

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Wednesday, November 18, 2015 2:19 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Re: disable keyboard

 



Liz - See message 112768. Somehow it broke away from the thread.

 

-Bill



---In MS_Access_Professionals@yahoogroups.com, <liz_ravenwood@...> wrote :

Wait.  That was my message.  What method did you suggest?  I don't see it other than looking to see what intellisense provides. 

 

application.Screen.???

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Wednesday, November 18, 2015 11:31 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: disable keyboard

 



Liz - So I take it you don't like they method I suggested?

 

-Bill



---In MS_Access_Professionals@yahoogroups.com, <liz_ravenwood@...> wrote :

Yep.  I recently discovered that.  I couldn't see how to do this and might have to think of a different way to go about this.

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Wednesday, November 18, 2015 9:53 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] RE: disable keyboard

 



Liz - That method is for Excel, not Access. Open the Immediate Window and type Application. As soon as you type the dot an IntelliSense list ops up. Note there is no ScreenUpdating available.

 

-Bill



---In MS_Access_Professionals@yahoogroups.com, <liz_ravenwood@...> wrote :

Just found something like this and am going to try it this afternoon.

 

Application.screenupdating = false

 

 

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Monday, November 16, 2015 2:30 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] disable keyboard

 

 

Pros, I have a need for the users to input by a scanning gun and by disallowing keyboard entry to a field on a form.

 

Is there a way?

 

Respectfully,

Liz Ravenwood

Programmer / Analyst

B/E Aerospace | Super First Class Environments

 

1851 S Pantano Road | Tucson, Arizona 85710

Office +1.520.239.4808 | Internal 814-4808

beaerospace.com

Passion to Innovate. Power to Deliver

 

 

 



This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

 



This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

 

 



This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

 





This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.






This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

__._,_.___
Posted by: yahoo@craven.de
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (29)

.

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

[MS_AccessPros] Re: weird page visibility issue

 

Liz


You have to refer to the tab control's Pages.
Me.myTab.Pages("Archive").Visible = False

Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com

 

__._,_.___
Posted by: wrmosca@comcast.net
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (4)

.

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

RE: [MS_AccessPros] weird page visibility issue

 

Thanks Duane. I'm checking the detail line property that says visible = true. All pages say visible = true.
I commented out the other code that didn't work to be able to walk through with the debugger and this is what is still not working:

Dim strAsk As String
strAsk = InputBox("visible? y/n")
If LCase(strAsk) = "n" Then
Me.Archiving.Visible = False
End If

I have 2 other pages: Operations and Preparation, and they become invisible, although in the immediate window when I
?me.operations.visible

Shows true

Arrgh. Google search didn't snow me anything.

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Monday, November 30, 2015 12:01 PM
To: Access Professionals Yahoo Group
Subject: RE: [MS_AccessPros] weird page visibility issue

Liz,

Can you share your code?

Duane Hookom, MVP
MS Access

________________________________
> Date: Mon, 30 Nov 2015 17:45:28 +0000
>
> Pros, I have a form with 3 tabs. When I use code to set one of them to
> invisible, nothing shows. I run the debugger and the properties to the
> other pages say they are visible, but they still don't show. Anyone
> else encountered this?
>
> Respectfully,
> Liz Ravenwood

------------------------------------

------------------------------------

------------------------------------

Yahoo Groups Links

This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

__._,_.___
Posted by: Liz Ravenwood <Liz_Ravenwood@beaerospace.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (3)

.

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

RE: [MS_AccessPros] weird page visibility issue

Liz,

Can you share your code?

Duane Hookom, MVP
MS Access

________________________________
> Date: Mon, 30 Nov 2015 17:45:28 +0000
>
> Pros, I have a form with 3 tabs. When I use code to set one of them to
> invisible, nothing shows. I run the debugger and the properties to the
> other pages say they are visible, but they still don't show. Anyone
> else encountered this?
>
> Respectfully,
> Liz Ravenwood



------------------------------------

------------------------------------


------------------------------------

Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/
Diposting oleh di Tidak ada komentar:

RE: [MS_AccessPros] Re: Sending email from Access

 

Retired for five years.  I still lurk.  I had a set of programs that compiled sales data, created excel pivot tables, and emailed them to the sales managers in the  middle of the night.   To get around the security issues I used "Click Yes", which at the time was free.  Apparently it still is around and now costs something, but it I am sure is worth it  if you need to do stuff like this.

 

http://www.contextmagic.com/express-clickyes/pro-version.htm

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Monday, November 30, 2015 9:16 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Sending email from Access

 

 

Hello Jim

 

Whilst I'm new to this, and there are members of the forum who will no doubt solve you problem easily, you post tempted me to reply.

I have code that allows a user to fire up Outlook, create an email, edit it and then send.  It doesn't go into the Outbox first.  Here it is (which is very similar to your post)

    ' Get a pointer to Outlook - late binding

    Set objOL = CreateObject("Outlook.Application")

    Set objMail = objOL.CreateItem(olMailItem)

    objMail.Subject = strSubject

    objMail.To = strTo

    objMail.BodyFormat = olFormatHTML

    objMail.Body = strMsg

    objMail.Display

 

    Set objMail = Nothing

    Set objOL = Nothing

 

The only difference I can see is the use of CreateObject and the above doesn't use a With loop.  If this works for you, great, though perhaps someone could explain why it works.

 

Best regards

Ray

 

 

 

__._,_.___
Posted by: "Carolyn" <carolamrt@earthlink.net>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (5)

.

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