ACCESS FEED: Agustus 2019

Sabtu, 31 Agustus 2019

[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 (182)

Please zip all files prior to uploading to Files section.

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

__,_._,___

Rabu, 28 Agustus 2019

[MS_AccessPros] Re: Form issues

Bill - It sounds like the form has some corruption. Two things that should fix it:

1. import it into a new, blank database, delete the form in the original db, compact, import from that new db.

2. Save form as text, delete the existing form, load from text.

To do #2:

press Ctrl+G to open Immediate window.

Type: SaveAsText acForm, "yourformname", "full file path"

Delete existing form & compact

Immediate window again: LoadFromText SaveAsText acForm, "yourformname", "full file path"

-Bill Mosca

---In MS_Access_Professionals@yahoogroups.com, <Bill.Singer@at-group.net> wrote :

I have Office 365 running on a Windows 10 machine

I have a form that has been running for years. The form pulls information from a query that just reads a table.

I have been asked to add a field to the form. No big deal.

However, once I make a change to the form it will not open again. I can open and close the form and it works fine. I can go into design mode and back to form mode and as long as I don't make any changes, no problems. However, as soon as I go to design mode and make one single change, such as moving a field a millimeter, and then close the form, I can't open it again. Periodically it tells me that I can't open a form that is already open. However, I can't see anything so I don't know why it is thinking the form is open. I can still right click the form and hit design mode and the form pops up but as soon as I try to save and go to form mode from design mode, the form disappears.

Any Idea what is going on? I have tried compact and repair. I started making changes yesterday and it worked fine. But now I have issues.

I am just thinking, there may be a person that is tapped into the back end database and they did not shut down their computer.. and I made some changes to the back end.

Any help would be appreciated.

Bill

Bill Singer

__._,_.___

Posted by: wrmosca@comcast.net

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (2)

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

__,_._,___

[MS_AccessPros] Form issues

I have Office 365 running on a Windows 10 machine

I have a form that has been running for years. The form pulls information from a query that just reads a table.

I have been asked to add a field to the form. No big deal.

However, once I make a change to the form it will not open again. I can open and close the form and it works fine. I can go into design mode and back to form mode and as long as I don’t make any changes, no problems. However, as soon as I go to design mode and make one single change, such as moving a field a millimeter, and then close the form, I can’t open it again. Periodically it tells me that I can’t open a form that is already open. However, I can’t see anything so I don’t know why it is thinking the form is open. I can still right click the form and hit design mode and the form pops up but as soon as I try to save and go to form mode from design mode, the form disappears.

Any Idea what is going on? I have tried compact and repair. I started making changes yesterday and it worked fine. But now I have issues.

I am just thinking, there may be a person that is tapped into the back end database and they did not shut down their computer.. and I made some changes to the back end.

Any help would be appreciated.

Bill

Bill Singer

__._,_.___

Posted by: <bill.singer@at-group.net>

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

__,_._,___

Selasa, 20 Agustus 2019

Re: [MS_AccessPros] Re: link child/master field on subreport

wonderful! glad you got it Sarah

(creative minds think alike ~ same logic but love how you explain things, Graham )

~crystal

On 8/20/2019 2:25 PM, sarahk@schemesoftware.com [MS_Access_Professionals] wrote:

Thank you, was able to resolve this.

Sarah

BTW Crystal: TABLE was a typo on my part, its actually PTABLE

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

Hi Sarah

As you've discovered, you cannot link two fields when they are both Null, because technically Null does not equal Null - the relationship between them is undefined.

However, you can use the Nz() function to convert the Null to something else - even a zero-length string (ZLS) - for the purpose of matching.

(I understand "table" is the master field and "shift" is the child field, right??? If it's the other way around, just switch the names below.)

On your main form, add a hidden textbox named txtTableLink with??

ControlSource: =Nz([table],"")

To the RecordSource query of your subform, add a field:??

txtTableLink: Nz([shift],"")

If your RecordSource is a table, then create a query based on that table with this additional field.

Now set both the LinkMasterFields and LinkChildFields properties of the subform to txtTableLink

(Note that LinkMasterFields can be a field OR a control, but LinkChildFields must be a field - hence the need to add it to the RecordSource.

Best wishes,

Graham [Access MVP 1996-2016]

__._,_.___

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 (5)

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

__,_._,___

[MS_AccessPros] Re: link child/master field on subreport

Thank you, was able to resolve this.

Sarah

BTW Crystal: TABLE was a typo on my part, its actually PTABLE

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

Hi Sarah

As you've discovered, you cannot link two fields when they are both Null, because technically Null does not equal Null - the relationship between them is undefined.

However, you can use the Nz() function to convert the Null to something else - even a zero-length string (ZLS) - for the purpose of matching.

(I understand "table" is the master field and "shift" is the child field, right? If it's the other way around, just switch the names below.)

On your main form, add a hidden textbox named txtTableLink with

ControlSource: =Nz([table],"")

To the RecordSource query of your subform, add a field:

txtTableLink: Nz([shift],"")

If your RecordSource is a table, then create a query based on that table with this additional field.

Now set both the LinkMasterFields and LinkChildFields properties of the subform to txtTableLink

(Note that LinkMasterFields can be a field OR a control, but LinkChildFields must be a field - hence the need to add it to the RecordSource.

Best wishes,

Graham [Access MVP 1996-2016]

__._,_.___

Posted by: sarahk@schemesoftware.com

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (4)

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

__,_._,___

Senin, 19 Agustus 2019

[MS_AccessPros] Re: link child/master field on subreport

Hi Sarah

As you've discovered, you cannot link two fields when they are both Null, because technically Null does not equal Null - the relationship between them is undefined.

However, you can use the Nz() function to convert the Null to something else - even a zero-length string (ZLS) - for the purpose of matching.

(I understand "table" is the master field and "shift" is the child field, right? If it's the other way around, just switch the names below.)

On your main form, add a hidden textbox named txtTableLink with

ControlSource: =Nz([table],"")

To the RecordSource query of your subform, add a field:

txtTableLink: Nz([shift],"")

If your RecordSource is a table, then create a query based on that table with this additional field.

Now set both the LinkMasterFields and LinkChildFields properties of the subform to txtTableLink

(Note that LinkMasterFields can be a field OR a control, but LinkChildFields must be a field - hence the need to add it to the RecordSource.

Best wishes,

Graham [Access MVP 1996-2016]

__._,_.___

Posted by: graham@mandeno.com

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (3)

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

__,_._,___

Re: [MS_AccessPros] link child/master field on subreport

hi Sarah,

the only way to link Null to Null is for them NOT to be Null ...

put this field in the record source for both forms, and use it in LinkMasterFields and LinkChildFields. Be sure to put a control on each form with this in it too -- control can have Visible=No

Table_: nz([Table],"")

"Table" is a reserved word -- hope this doesn't create issues for you

http://allenbrowne.com/AppIssueBadWord.html#T

have an awesome day,
crystal

free code you can use in your projects
https://msaccessgurus.com/code.htm

connect to me, let's build it together
http://www.msaccessgurus.com

On 8/19/2019 7:00 PM, sarahk@schemesoftware.com [MS_Access_Professionals] wrote:

I have a report that links child / master fields on main report and subreport. there are 2 fields: 'shift' and 'table'. everything works , except when 'table' is blank (legitimate for this entry).

Question: how can I link blank table on main from to blank table on subform?.

Thanks for your help

Sarah

__._,_.___

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 (2)

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

__,_._,___

[MS_AccessPros] link child/master field on subreport

I have a report that links child / master fields on main report and subreport. there are 2 fields: 'shift' and 'table'. everything works , except when 'table' is blank (legitimate for this entry).

Question: how can I link blank table on main from to blank table on subform?.

Thanks for your help

Sarah

__._,_.___

Posted by: sarahk@schemesoftware.com

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

__,_._,___

Jumat, 16 Agustus 2019

Re: [MS_AccessPros] Time Line

Youssef,

I assuming a horizontal line control in your report. You can find the width code in the On Format event of the section containing the line control:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)

MsgBox "Line0 width is: " & Me.Line0.Width

End Sub

Regards,

Duane

From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of youssef2309@gmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Friday, August 16, 2019 11:33 AM
To: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com>
Subject: [MS_AccessPros] Time Line

I have a report that contains fields :

Task description / start time / end time + a line that present the period length of this task

how can I calculate the line length on the report depend on the time fields

thanks in advance

__._,_.___

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 (2)

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

__,_._,___

Re: [MS_AccessPros] Mobile message

hi Youssef,

if you know the mobile carrier, you can construct an email message such as phonenumber@vtext.com for Verizon, or phonenumber@tmomail.net for T-Mobile, where phonenumber is 1234567890, or whatever the number is

have an awesome day,
crystal

On 8/16/2019 11:34 AM, youssef2309@gmail.com [MS_Access_Professionals] wrote:

In Access is there any tool than can I use the send a text message to a mobile??

thanks in advance

__._,_.___

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 (3)

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

__,_._,___

RE: [MS_AccessPros] Mobile message

Yes, for instance VOIP buster just needs a get-URL you can invoke in an iFrame in Access.

https://www.voipbuster.com/myaccount/sendsms.php?username=uuuuuuuuu&password=pppppppp&from=sssssssssl&to=+1999999999999&text=voipbuster%20test

You can test in in a browser after you created an account. I thing Azure has a service like that too.

You can fill in your own phone number to test.

It's probably also documented on VoipBuster.com

You can also order a GOIP (a mobile gateway uses a mobile phone card as a voip gateway. You can have incoming and outgoing call as well as send textmessages. But you'd have to create a webservice for that as a front-end.

Kind regards

rob

From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com>
Sent: vrijdag 16 augustus 2019 18:35
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Mobile message

In Access is there any tool than can I use the send a text message to a mobile

thanks in advance

__._,_.___

Posted by: Rob Koelmans <r.koelmans@metamicro.nl>

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (2)

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

__,_._,___

RE: [MS_AccessPros] Re: Web-Based Microsoft Access?

Hi Crystal,

Depending on your bandwidth it should go to HDMI quality after two or three seconds when you have the video set to full screen. Perhaps that doesn't work right because it's probably on a Youtube server on my side of the atlantic.

There's no sound. We should do this better but are very occupied with projects getting done.

The one with Access is quite spectacular. It implies that you're done with all the client-server hassle in Access. You just have it ask for a license key and – supplied – the application works from anywhere in the world with just internet. We have it completely safe with a new SHA256 digital signature as a token each time Access is talking to the service. It's blazingly fast with hardly any code. You create, manage, monitor and troubleshoot the service superbly in Flow with hardly any training. An IT-team creating REST or SOAP services can never do a better job than you will in Flow.

You can create your own organization on our Website, create an AWA and you're set to create your Flow in Office365. The datamacros you create in Access Web Apps are seen as Stored Procedures in Flow. Always use Exec Query in Flow, nothing else (no get-rows etc. The Exec Query just throws your script to SQL-server. That way you can always do everything in one roundtrip from Flow to SQL-server.

Here's how to create an organization on our site. Use +1 in the mobile number not 0.

The password you create should contain special characters and numbers.

You have to log in 3 times (sitecollection, Access Web App, Access Desktop to develop). All three store a secure cookie that will be valid for a month providing you log in from the same client machine.

The trick in Access Desktop in the video is that we fill an Ado virtual recordset with data from JSON parsed by Flow. We use the same flow services in PowerApps, Excel, PowerBI and from AWA to AWA.
Kind regards,
Rob

[cid:image003.jpg@01D55463.C1CFE360]

[cid:image004.jpg@01D55463.C1CFE360]

From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com>
Sent: vrijdag 16 augustus 2019 17:29
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Re: Web-Based Microsoft Access?

hi Rob,

thanks for the link! I looked at a couple of the videos, but there isn't any audio. I had a hard time following with the small text (1280x720 is a good resolution for recording and results in everything being easier to read than using a higher resolution). I saved the link to look at for when I have an actual use and would be more familiar with what you're showing as I'm sure it must be valuable.

have an awesome day,
crystal

http://www.YouTube.com/LearnAccessByCrystal

On 8/15/2019 11:33 AM, Rob Koelmans r.koelmans@metamicro.nl<mailto:r.koelmans@metamicro.nl> [MS_Access_Professionals] wrote:
Hi Crystal,
Access Web Apps is alive and kicking in Access 2019 (kicking may be overstated but alive certainly ????) But you do need Sharepoint 2016 or 2019 Enterprise with Access Web App services installed.
??
We have some videos on using Flow from Access Desktop and PowerApps. From AWA to AWA works in the same way but creating forms in AWA is a breeze as long as the functionality can be simple. When things become complex AWA forms become a nightmare. We???ve been working on one for two weeks now with two persons. I had to pull all the AWA tricks of my sleeve I gathered from 2012 till 2017. Practically all of them are crazy.
??
Videos: https://metamicro.nl/nl-nl/Home/Videos
Cheers Rob.
??
??
??
From: MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com> <MS_Access_Professionals@yahoogroups.com><mailto:MS_Access_Professionals@yahoogroups.com>
Sent: donderdag 15 augustus 2019 17:30
To: MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com>
Subject: Re: [MS_AccessPros] Re: Web-Based Microsoft Access?
??
??

hi Rob,

Flow sounds interesting -- have you made any video tutorials on how to use it? Or where would a beginner start?

As for being depreciated, I was referring to Access versions ... nothing past Access 2010 can make an Access web database. The latest version of Access is 2019. I think one reason they failed is because performance was very slow compared to Access desktop applications, as well as being a totally different design experience with a big learning curve. Naturally, when the back-end is in the cloud, things get slower. While remote desktop does have some costs, in the long run I think it wins out because of much better performance especially to reduce frustrating waiting time, being able to use VBA for greater power, and being able to keep company information on premises, which is my preference for those who can backup and maintain their files in-house. To each their own on that though.

(try to keep message history so the thread stays intact, thanks)

Nice to have your input and perspective, Rob!

have an awesome day,
crystal
On 8/14/2019 7:02 AM, r.koelmans@metamicro.nl<mailto:r.koelmans@metamicro.nl> [MS_Access_Professionals] wrote:
We still have Access Web Apps that you can try for free (for 3 months on SPLA regulations provided we don't charge you anything). It's only deprecated on SharePoint Online, not on SharePoint 2019 Enterprise. SPLA??
??
Regardless what client or backend you use, always use Flow as the middle tier. Client/Server is truly depreciated. Remote Desktop Licensing is quite expensive.??
??
The main reason we still use Access Web Apps is its datamacros compile to t-SQL scripts in the server. They run completely independent from Access and will be seen as stored procedures in Flow. The https initiator that invokes the Flow in case can be used from any client including other Flows, Access Web Apps, PowerApps, Access Desktop Applications, Excel, Word, PowerBI, PowerShell etc. The can be both GET and POST services and are easy made safe/secure.
Rob

[Non-text portions of this message have been removed]