ACCESS FEED: Mei 2021

Jumat, 28 Mei 2021

Re: [MSAccessProfessionals] Display HTML content from Table in Webbrowser Control

After messing with this I think I have the solution. I forced a "set" on the object like this:

Private Sub Form_Load()

Dim objBrowser As Object

Set objBrowser = Me.WebBrowser3.Object

With objBrowser.Document

.Open

.Write "<HTML> <H1> hello world! </H1> </HTML>"

.Close

End With

Set objBrowser = Nothing

End Sub

Regards,

Bill Mosca

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of ozairkhalidozair
Sent: Thursday, May 27, 2021 5:42 AM
To: MSAccessProfessionals@groups.io
Subject: [MSAccessProfessionals] Display HTML content from Table in Webbrowser Control

[Edited Message Follows]

Hi all,

I found an interesting article and liked the idea very much.
https://www.devhut.net/2019/10/18/everything-you-never-wanted-to-know-about-the-access-webbrowser-control/

From this tutorial, I am actually interested in Dynamic Content on the Fly.

Unfortunately its not working in my file.
All I see is "Object variable or With block variable not set"
Can someone please help?

Copied Code
Private Sub Form_Current()

With Me.WebBrowser0.Object.Document

.Open

.Write "<HTML> <H1> hello world! </H1> </HTML>"

.Close

End With

End Sub

System Detail

Office 2016 64 Bit
Windows 10 64 Bit
EDIT : Not sure if it was needed but I already added Reference for "Microsoft HTML Object Library" anyway.

Best,
Ozair

Re: [MSAccessProfessionals] Display HTML content from Table in Webbrowser Control

Ozair,
There is a little Quote Post bubble on the left of the format bar above where you type. The first task before typing anything into a reply is to click the bubble which places the previous posts into the reply. Then type your response at the top of the message.

Regards,
Duane

On Fri, May 28, 2021 at 05:09 AM, ozairkhalidozair wrote:

Graham,

Thanks.
I am sorry I have no idea how to include or skip the whole thread
I simply wrote my answer and pressed the little green "Reply to Group" button located at the left bottom.
I am writing it from their website groups.in/g/MSAccessProfessionals/

Please educate me

OK - about the solution.

I tried many combinations that I could have think of.

But had to switch to another thread from another group - that worked in my case.
https://www.access-programmers.co.uk/forums/threads/display-html-code-in-web-browser.289555/

Best,
Ozair

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_

Re: [MSAccessProfessionals] Display HTML content from Table in Webbrowser Control

Graham,

Thanks.
I am sorry I have no idea how to include or skip the whole thread
I simply wrote my answer and pressed the little green "Reply to Group" button located at the left bottom.
I am writing it from their website groups.in/g/MSAccessProfessionals/

Please educate me

OK - about the solution.

I tried many combinations that I could have think of.

But had to switch to another thread from another group - that worked in my case.
https://www.access-programmers.co.uk/forums/threads/display-html-code-in-web-browser.289555/

Best,
Ozair

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_

Kamis, 27 Mei 2021

Re: [MSAccessProfessionals] Display HTML content from Table in Webbrowser Control

Hi Ozair

Please quote all the previous conversation when you post an answer, so we can see the whole thread.

When the code stops at the error, and ".Open" is highlighted, what happens if you type in the Immediate window:

?Me. WebBrowser0.Object

It should return with:
Microsoft Web Browser Control

If not, perhaps it is not a web browser control you have on your form.

(By the way, the code, copied and pasted from your question, works perfectly for me.)

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

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of ozairkhalidozair
Sent: Friday, 28 May 2021 16:42
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Display HTML content from Table in Webbrowser Control

Bill,

Thanks for your input.

Yes IntelliSense finds the webbrowser control name correctly. (As to confirm, I renamed it to "MyWebBrowserControl").
The error appears on first row AFTER "With" clause i.e. [.Open].

Any ideas?
Best,
Ozair

Re: [MSAccessProfessionals] Display HTML content from Table in Webbrowser Control

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_

Re: [MSAccessProfessionals] Display HTML content from Table in Webbrowser Control

see this demo.

open the form.

view the code behind the form.

Virus-free. www.avast.com

On Fri, May 28, 2021 at 3:16 AM Bill Mosca <wrmosca@comcast.net> wrote:

Ozair

Interesting idea. Often, copy and paste fails because of differently named controls. I noticed is the name of your web browser control is "WebBrowser0". Is that correct? Is the IntelliSense find it when you type "Me."?

Regards,
Bill Mosca

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of ozairkhalidozair
Sent: Thursday, May 27, 2021 5:42 AM
To: MSAccessProfessionals@groups.io
Subject: [MSAccessProfessionals] Display HTML content from Table in Webbrowser Control

[Edited Message Follows]
Hi all,

I found an interesting article and liked the idea very much.
https://www.devhut.net/2019/10/18/everything-you-never-wanted-to-know-about-the-access-webbrowser-control/

From this tutorial, I am actually interested in Dynamic Content on the Fly.
Unfortunately its not working in my file.
All I see is "Object variable or With block variable not set"
Can someone please help?
Copied Code
Private Sub Form_Current()
With Me.WebBrowser0.Object.Document
.Open
.Write "<HTML> <H1> hello world! </H1> </HTML>"
.Close
End With

End Sub

System Detail
Office 2016 64 Bit
Windows 10 64 Bit
EDIT : Not sure if it was needed but I already added Reference for "Microsoft HTML Object Library" anyway.

Best,
Ozair

Arnelito G. Puzon

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_

Re: [MSAccessProfessionals] Display HTML content from Table in Webbrowser Control

Ozair

Interesting idea. Often, copy and paste fails because of differently named controls. I noticed is the name of your web browser control is "WebBrowser0". Is that correct? Is the IntelliSense find it when you type "Me."?

Regards,

Bill Mosca

[Edited Message Follows]

Unfortunately its not working in my file.
All I see is "Object variable or With block variable not set"
Can someone please help?

Copied Code
Private Sub Form_Current()

With Me.WebBrowser0.Object.Document

.Open

.Write "<HTML> <H1> hello world! </H1> </HTML>"

.Close

End With

End Sub

System Detail

Office 2016 64 Bit
Windows 10 64 Bit
EDIT : Not sure if it was needed but I already added Reference for "Microsoft HTML Object Library" anyway.

Best,
Ozair

[MSAccessProfessionals] Display HTML content from Table in Webbrowser Control

[Edited Message Follows]

Unfortunately its not working in my file.
All I see is "Object variable or With block variable not set"
Can someone please help?

Copied Code
Private Sub Form_Current()

With Me.WebBrowser0.Object.Document

.Open

.Write "<HTML> <H1> hello world! </H1> </HTML>"

.Close

End With

End Sub

System Detail

Office 2016 64 Bit
Windows 10 64 Bit
EDIT : Not sure if it was needed but I already added Reference for "Microsoft HTML Object Library" anyway.

Best,
Ozair

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_

[MSAccessProfessionals] Display HTML content from Table in Webbrowser Control

Unfortunately its not working in my file.
All I see is "Object variable or With block variable not set"
Can someone please help?

Copied Code
Private Sub Form_Current()

With Me.WebBrowser0.Object.Document

.Open

.Write "<HTML> <H1> hello world! </H1> </HTML>"

.Close

End With

End Sub

System Detail

Office 2016 64 Bit
Windows 10 64 Bit

Best,
Ozair

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_

Rabu, 26 Mei 2021

Re: [MSAccessProfessionals] How to secure Front end which i give to my client along with .accde file

Hi Kahlid,

I always reply through email rather than the group website. This includes the previous messages by default. I think I posted something a while back about clicking a box or something that includes previous messages without having to copy and paste.

Can we assume you are developing an Access application for a customer? You should always have a front-end file with everything except the tables. The back-end file has only the tables. As per Daniel's site there are lots of tasks you can perform on your front-end to protect your designs based on your requirements. All of my customers work for the same employer as me so I don't employ all of his recommendations. You should only need to make an accde that gets sent to your customer. Each user should have their own copy of the front-end accde file.

I'm not sure how you can do any development or testing of your application if you don't have a copy of their back-end file.

Regards,

Duane

From: Khalid Tanweer via groups.io

Thanks Duane,

The best resource I have read on securing an Access front end is from Daniel Pineault https://www.devhut.net/2016/09/01/securing-your-ms-access-database-front-end/.

I don't understand how front end changes will affect "his latest inputs and changes in data". Updates to the front end should not make any difference with the data in the back end.

Duane

I would expect that you would have both front-end and back-end files for you to develop and test. I typically include some code at startup that changes the linked table connections to the customer's back-end file.

You may want to occasionally get a new copy of the back-end file from your customer to be a little more realistic in terms of amount of data etc.

When you reply please include the previous messages in the email.

Regards,

Duane
...................................................
Duane,
Is this correct to paste previous messages from you or email is something else like on your email address. The things you mentioned in your last message could you please explain me more in this regard. Do you mean to say that i should keep my own back end and front end, particular not securing my own front end, and giving my end user another secured front end, and further it makes no harm that he should have his own back end which i may get a copy of it occasionally.
Regards,
Khalid

Re: [MSAccessProfessionals] How to secure Front end which i give to my client along with .accede file

Thanks Duane,

The best resource I have read on securing an Access front end is from Daniel Pineault https://www.devhut.net/2016/09/01/securing-your-ms-access-database-front-end/.

I don't understand how front end changes will affect "his latest inputs and changes in data". Updates to the front end should not make any difference with the data in the back end.

Duane

You may want to occasionally get a new copy of the back-end file from your customer to be a little more realistic in terms of amount of data etc.

When you reply please include the previous messages in the email.

Regards,

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_

Re: [MSAccessProfessionals] How to secure Front end which i give to my client along with .accede file

Hi Duane, what would that code look like?

Giorgio

On 05/26/2021 9:34 PM Duane Hookom <duanehookom@hotmail.com> wrote:

Khalid,

I would expect that you would have both front-end and back-end files for you to develop and test. I typically include some code at startup that changes the linked table connections to the customer's back-end file.

You may want to occasionally get a new copy of the back-end file from your customer to be a little more realistic in terms of amount of data etc.

When you reply please include the previous messages in the email.

Regards,

Duane

From: Khalid Tanweer

Hello Duane,
This is the point which i am not clear up to now. Up to now i have been giving modified acce.de to my client and he has a copy of back end with him, in this case i know it will not effect to his data or changes. But i have read and heard at many places that back end should remain with me and a copy of front end and acce.de should be provided to the client. My question was in this regard. If i am wrong please help and guide me in this context.
Thanks Khalid
_.

Re: [MSAccessProfessionals] How to secure Front end which i give to my client along with .accede file

Khalid,

You may want to occasionally get a new copy of the back-end file from your customer to be a little more realistic in terms of amount of data etc.

When you reply please include the previous messages in the email.

Regards,

Duane

From: Khalid Tanweer

Hello Duane,
This is the point which i am not clear up to now. Up to now i have been giving modified acce.de to my client and he has a copy of back end with him, in this case i know it will not effect to his data or changes. But i have read and heard at many places that back end should remain with me and a copy of front end and acce.de should be provided to the client. My question was in this regard. If i am wrong please help and guide me in this context.
Thanks Khalid

Re: [MSAccessProfessionals] How to secure Front end which i give to my client along with .accede file

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_

Re: [MSAccessProfessionals] How to secure Front end which i give to my client along with .accede file

Hi Khalid,

The best resource I have read on securing an Access front end is from Daniel Pineault https://www.devhut.net/2016/09/01/securing-your-ms-access-database-front-end/.

I don't understand how front end changes will affect "his latest inputs and changes in data". Updates to the front end should not make any difference with the data in the back end.

Duane

Securing Your MS Access Database Front-End | DEVelopers HUT

MS Access 25 responses on " Securing Your MS Access Database Front-End " Merrikay Lee October 19, 2017 at 12:29 pm. Thank you, Daniel. I found the step to make the production front end user-bullet proof. Don't want them messing with forms or queries…or even knowing they are there.

www.devhut.net

From: Khalid Tanweer

Hello everyone,
My client has asked me to make some changes and add some new forms as per his requirement, up to now I am giving him back end and acce.de file. My question is if i give him new front end and acce.de file how do i secure the front end. Do i have to keep the original front end with me and give him secured front end. Secondly the thing which is confusing me is how his latest inputs and changes in data will not be disturbed or changed if in future he has another demand for some changes or needs some new forms.
Help is required so that i may not ask this question in future.
Thank you Khalid

[MSAccessProfessionals] How to secure Front end which i give to my client along with .accede file

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_

Selasa, 18 Mei 2021

Re: [MSAccessProfessionals] Summary Query Issue

Hi Sean,

Thanks for the clarification.

This is expected behavior in SQL since "blank" is actually Null which I like to think of as "unknown". You can't compare anything to unknown so it's unknown whether it equals "X" or not.

You would need to change the WHERE clause in the query to:

CatA & "" <>"X"

Adding a zero length string to CatA changes it from unknown/null to "" which can be compared to "X".

Regards,

Duane

From: Sean Cooper

I actually did that before asking the question to see if I can replicate the problem in a much easier framework and I can.

Consider the simple table

ID CatA Value

1 1

2 X 2

3 Y 3

If you create a sum query with Criteria CatA of "X" you correctly get a 1 row query "X 2"

If you create a sum query with "where" Criteria CatA of "X" you correctly get a 1 row 1 cell query "2"

But

If you create a sum query with Criteria CatA of <>"X" you incorrectly get a 1 row query "Y 3", it drops row1 the value where "A" was blank.

Same If you create a sum query with "where" Criteria CatA <>"X" you incorrectly get a 1 row 1 cell query "3" not "4"

Sean

On Monday, May 17, 2021, 04:17:52 PM CDT, Duane Hookom <duanehookom@hotmail.com> wrote:

Hi Sean,

I typically simplify and test. Consider removing the Group By and check the results. If that isn't enlightening, then remove the criteria and test. If you still don't understand, copy some data to Excel and use the data tools there to check the values of XYZ.

Duane

From: Sean Cooper

I have a summary query which groups on several fields and then sums several other fields.

If I add another column XYZ and "Group By' that column everything looks good.

if I then change XYZ from a "Group By" to a "Where" column, and add criteria ="teststring", everything still looks good. ie it correctly only sums data where XYZ has the value "teststring"

if I keep XYZ as a "Where" column, but change the criteria to <>"teststring" though it now only sums columns of XYZ that are blank. ie it eliminates all data where XYZ has and value not just "teststring"

Any ideas?

Re: [MSAccessProfessionals] Summary Query Issue

I actually did that before asking the question to see if I can replicate the problem in a much easier framework and I can.

Consider the simple table

ID CatA Value

1 1

2 X 2

3 Y 3

If you create a sum query with Criteria CatA of "X" you correctly get a 1 row query "X 2"

If you create a sum query with "where" Criteria CatA of "X" you correctly get a 1 row 1 cell query "2"

But

If you create a sum query with Criteria CatA of <>"X" you incorrectly get a 1 row query "Y 3", it drops row1 the value where "A" was blank.

Same If you create a sum query with "where" Criteria CatA <>"X" you incorrectly get a 1 row 1 cell query "3" not "4"

Sean

On Monday, May 17, 2021, 04:17:52 PM CDT, Duane Hookom <duanehookom@hotmail.com> wrote:

Hi Sean,

Duane

From: Sean Cooper

I have a summary query which groups on several fields and then sums several other fields.

If I add another column XYZ and "Group By' that column everything looks good.

if I then change XYZ from a "Group By" to a "Where" column, and add criteria ="teststring", everything still looks good. ie it correctly only sums data where XYZ has the value "teststring"

Any ideas?

Senin, 17 Mei 2021

Re: [MSAccessProfessionals] Summary Query Issue

Hi Sean,

Duane

From: Sean Cooper

I have a summary query which groups on several fields and then sums several other fields.

If I add another column XYZ and "Group By' that column everything looks good.

if I then change XYZ from a "Group By" to a "Where" column, and add criteria ="teststring", everything still looks good. ie it correctly only sums data where XYZ has the value "teststring"

Any ideas?

[MSAccessProfessionals] Summary Query Issue

I have a summary query which groups on several fields and then sums several other fields.

If I add another column XYZ and "Group By' that column everything looks good.

if I then change XYZ from a "Group By" to a "Where" column, and add criteria ="teststring", everything still looks good. ie it correctly only sums data where XYZ has the value "teststring"

Any ideas?

Jumat, 28 Mei 2021

Unfortunately its not working in my file.All I see is "Object variable or With block variable not set"Can someone please help?

Copied CodePrivate Sub Form_Current()

With Me.WebBrowser0.Object.Document

.Open

.Write "<HTML> <H1> hello world! </H1> </HTML>"

.Close

End With

End Sub

Kamis, 27 Mei 2021

Unfortunately its not working in my file.All I see is "Object variable or With block variable not set"Can someone please help?

Copied CodePrivate Sub Form_Current()

With Me.WebBrowser0.Object.Document

.Open

.Write "<HTML> <H1> hello world! </H1> </HTML>"

.Close

End With

End Sub

Unfortunately its not working in my file.All I see is "Object variable or With block variable not set"Can someone please help?

Copied CodePrivate Sub Form_Current()

With Me.WebBrowser0.Object.Document

.Open

.Write "<HTML> <H1> hello world! </H1> </HTML>"

.Close

End With

End Sub

Unfortunately its not working in my file.All I see is "Object variable or With block variable not set"Can someone please help?

Copied CodePrivate Sub Form_Current()

With Me.WebBrowser0.Object.Document

.Open

.Write "<HTML> <H1> hello world! </H1> </HTML>"

.Close

End With

End Sub

Unfortunately its not working in my file.All I see is "Object variable or With block variable not set"Can someone please help?

Copied CodePrivate Sub Form_Current()

With Me.WebBrowser0.Object.Document

.Open

.Write "<HTML> <H1> hello world! </H1> </HTML>"

.Close

End With

End Sub

Rabu, 26 Mei 2021

Selasa, 18 Mei 2021

Senin, 17 Mei 2021

Unfortunately its not working in my file.
All I see is "Object variable or With block variable not set"
Can someone please help?

Copied Code
Private Sub Form_Current()

Unfortunately its not working in my file.
All I see is "Object variable or With block variable not set"
Can someone please help?

Copied Code
Private Sub Form_Current()

Unfortunately its not working in my file.
All I see is "Object variable or With block variable not set"
Can someone please help?

Copied Code
Private Sub Form_Current()

Unfortunately its not working in my file.
All I see is "Object variable or With block variable not set"
Can someone please help?

Copied Code
Private Sub Form_Current()

Unfortunately its not working in my file.
All I see is "Object variable or With block variable not set"
Can someone please help?

Copied Code
Private Sub Form_Current()