ACCESS FEED: Agustus 2022

Senin, 22 Agustus 2022

Re: [MSAccessProfessionals] Need advise!!!!

Norbert,

As long you are available
- Prepare detailed documentation for the new person.
- Add comments to your code to explain the flow of the program.
- Post your project to an online hiring platforms such as Upwork.
- Interview & shortlist candidates.
- Share those with your daughter so she may connect with them when needed.

Ozair

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_

Re: [MSAccessProfessionals] Need advise!!!!

I would be happy to have a look at the database and offer some suggestions. I've supported countless Access DBs over the years.

Stuart

On Monday, August 22, 2022 at 04:53:22 PM EDT, drnorbert2002 <drnorbert@msn.com> wrote:

On Sun, Aug 21, 2022 at 06:09 PM, Neil Woodnick wrote:

Hi Neil,

Please provide more info regarding:
No. of users: 10
No. of programs in total: 1

No. of utility programs used to verify data if data corruption occurs: FMS

No. of times you have been required

to fix a problem over the past 6 months: No issues mainly improvements

Response level required if a problem occurs e.g. 1 hour, 2 hour etc : No emergencies

Is weekend cover required.: No

All enhancements would be done on fixed price basis: Make sense

Support would be Remote Support only and charged on an agreed subscription basis. I would reserve the right to increase the subscription amount if level of support required was more than originally anticipated or annual review. : Not sure what do you mean by "subscription basis"

Re: [MSAccessProfessionals] Need advise!!!!

On Sun, Aug 21, 2022 at 06:09 PM, Neil Woodnick wrote:

Hi Neil,

Please provide more info regarding:
No. of users: 10
No. of programs in total: 1

No. of utility programs used to verify data if data corruption occurs: FMS

No. of times you have been required

to fix a problem over the past 6 months: No issues mainly improvements

Response level required if a problem occurs e.g. 1 hour, 2 hour etc : No emergencies

Is weekend cover required.: No

All enhancements would be done on fixed price basis: Make sense

Support would be Remote Support only and charged on an agreed subscription basis. I would reserve the right to increase the subscription amount if level of support required was more than originally anticipated or annual review. : Not sure what do you mean by "subscription basis"

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_

Minggu, 21 Agustus 2022

Re: [MSAccessProfessionals] Need advise!!!!

Please provide more info regarding:

No. of users
No. of programs in total

No. of utility programs used to verify data if data corruption occurs

No. of times you have been required

to fix a problem over the past 6 months

Response level required if a problem occurs e.g. 1 hour, 2 hour etc

Is weekend cover required.

All enhancements would be done on fixed price basis

Support would be Remote Support only and charged on an agreed subscription basis. I would reserve the right to increase the subscription amount if level of support required was more than originally anticipated or annual review.

Regards,

Neil Wood

On Monday, 22 August 2022, drnorbert2002 <drnorbert@msn.com> wrote:

Over many years I have designed an increasingly sophisticated program with MSAccess 2019 Front End and SQL 2019 Back End for my daughter's company - As a result, I am the only person who can trouble-shoot and repair or enhance the program if they run into a glitch or a problem or need upgrades.

Long term, this is not sustainable - we need some back up or alternative resource they can turn to if I am not available. The company is not large enough to hire a full-time (or even part time) programmer/IT person. I will appreciate any input or ideas about how we could go about obtaining this type of back up in case we need it in the future.

Thanks,
Norbert

--
Neil Woodnick

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_

[MSAccessProfessionals] Need advise!!!!

Over many years I have designed an increasingly sophisticated program with MSAccess 2019 Front End and SQL 2019 Back End for my daughter's company - As a result, I am the only person who can trouble-shoot and repair or enhance the program if they run into a glitch or a problem or need upgrades.

Long term, this is not sustainable - we need some back up or alternative resource they can turn to if I am not available. The company is not large enough to hire a full-time (or even part time) programmer/IT person. I will appreciate any input or ideas about how we could go about obtaining this type of back up in case we need it in the future.

Thanks,
Norbert

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_

Selasa, 16 Agustus 2022

Re: [MSAccessProfessionals] Report, when field blank look up standard note

In addition to Paul's comments, I will sometimes use a text box in place of a label. For instance, if there is a field [MaidenName] that might be null, you could use a text box for the label with the control source of:

="Maiden Name: " + [MaidenName]

Make sure the width of the text box is just wide enough to show the quoted text. If the field is null, the entire expression becomes null.

Duane

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of michael simpson via groups.io <saccity101=yahoo.com@groups.io>
Sent: Tuesday, August 16, 2022 4:01 PM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: [MSAccessProfessionals] Report, when field blank look up standard note

Good day -

I am working on updating automating my database to send out invoices,

I have two issues,

I have a Form (fmWO) which I publish to a report (rptWO) and then print to a PDF to email to clients.

First I generally us a standard warranty on my work orders, so I don't type it in unless something atypical.

Want to if field WarrantyNote = "" then lookup standard note.

Second issue: if some fields are not filled in then hide the label and message box

First thought was to put something on the on load event, however, getting "invalid use of Null" error.

The on current event is triggered when I close the form,

Take care,

Mike the Plumber

Sac City Plumbing

_._,_._,_

Re: [MSAccessProfessionals] Report, when field blank look up standard note

Greetings from just over the hill east of you (I assume). You haven't shown your code so it's hard to know what might be going wrong with it. In general:

If Len(Me.WarrantyNote & vbNullString) = 0 Then

Me.WarrantyNote = DLookup(...)

End If

You can use a similar test to hide the labels. The place to do that is typically the format event of the section containing them on the report.

Paul

------ Original Message ------

From "michael simpson via groups.io" <saccity101=yahoo.com@groups.io>

To "MSAccessProfessionals@groups.io" <MSAccessProfessionals@groups.io>

Date 8/16/2022 2:01:02 PM

Subject [MSAccessProfessionals] Report, when field blank look up standard note

Good day -
I am working on updating automating my database to send out invoices,
I have two issues,
I have a Form (fmWO) which I publish to a report (rptWO) and then print to a PDF to email to clients.

First I generally us a standard warranty on my work orders, so I don't type it in unless something atypical.
Want to if field WarrantyNote = "" then lookup standard note.

Second issue: if some fields are not filled in then hide the label and message box

First thought was to put something on the on load event, however, getting "invalid use of Null" error.
The on current event is triggered when I close the form,

Take care,
Mike the Plumber
Sac City Plumbing

[MSAccessProfessionals] Report, when field blank look up standard note

Good day -

I am working on updating automating my database to send out invoices,

I have two issues,

I have a Form (fmWO) which I publish to a report (rptWO) and then print to a PDF to email to clients.

First I generally us a standard warranty on my work orders, so I don't type it in unless something atypical.

Want to if field WarrantyNote = "" then lookup standard note.

Second issue: if some fields are not filled in then hide the label and message box

First thought was to put something on the on load event, however, getting "invalid use of Null" error.

The on current event is triggered when I close the form,

Take care,

Mike the Plumber

Sac City Plumbing

Selasa, 02 Agustus 2022

Re: [MSAccessProfessionals] Textbox is populated with the "#NAME?" error code. after upgrading computers RESOLVED

hi Sarah,

you did it! Just no message ... or is it "OK I got it." -- maybe show quoted post BELOW instead of above message?

kind regards,
crystal

On 8/2/2022 12:10 PM, novice012000 wrote:

On Mon, Aug 1, 2022 at 11:40 AM, crystal (strive4peace) wrote:

here's a more direct link to Duane's image:

https://groups.io/g/MSAccessProfessionals/photo/249167/2977001

~crystal

On 8/1/2022 1:36 PM, crystal (strive4peace) via groups.io wrote:

hi Sarah,

glad it's working again!!!

how to Quote Post .. Duane uploaded an image on how to quote post in a reply to show previous messages using the web interface here:

https://groups.io/g/MSAccessProfessionals/album?id=249167

Groups IO interface
file name: GroupsIOQuoteReply.png
By Duane Hookom
Uploaded: 06/22/20
Size: 45 kB

kind regards,
crystal

On 8/1/2022 12:24 PM, novice012000 wrote:

Crystal,
just wanted to let you know that the problem was caused by an issue with the Microsoft Office license. Once that was resolved the error disappeared.
Thanks for your help
Sarah
PS-I still dont see the option to include message thread in groups.io. sorry for not including.

OK I got it.
Thanks
Sarah

Re: [MSAccessProfessionals] Textbox is populated with the "#NAME?" error code. after upgrading computers RESOLVED

On Mon, Aug 1, 2022 at 11:40 AM, crystal (strive4peace) wrote:

here's a more direct link to Duane's image:

https://groups.io/g/MSAccessProfessionals/photo/249167/2977001

~crystal

On 8/1/2022 1:36 PM, crystal (strive4peace) via groups.io wrote:

hi Sarah,

glad it's working again!!!

how to Quote Post .. Duane uploaded an image on how to quote post in a reply to show previous messages using the web interface here:

https://groups.io/g/MSAccessProfessionals/album?id=249167

Groups IO interface
file name: GroupsIOQuoteReply.png
By Duane Hookom
Uploaded: 06/22/20
Size: 45 kB

kind regards,
crystal

On 8/1/2022 12:24 PM, novice012000 wrote:

Crystal,
just wanted to let you know that the problem was caused by an issue with the Microsoft Office license. Once that was resolved the error disappeared.
Thanks for your help
Sarah
PS-I still dont see the option to include message thread in groups.io. sorry for not including.

OK I got it.
Thanks
Sarah

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_

Senin, 01 Agustus 2022

Re: [MSAccessProfessionals] Textbox is populated with the "#NAME?" error code. after upgrading computers RESOLVED

here's a more direct link to Duane's image:

https://groups.io/g/MSAccessProfessionals/photo/249167/2977001

~crystal

On 8/1/2022 1:36 PM, crystal (strive4peace) via groups.io wrote:

hi Sarah,

glad it's working again!!!

how to Quote Post .. Duane uploaded an image on how to quote post in a reply to show previous messages using the web interface here:

https://groups.io/g/MSAccessProfessionals/album?id=249167

Groups IO interface
file name: GroupsIOQuoteReply.png
By Duane Hookom
Uploaded: 06/22/20
Size: 45 kB

kind regards,
crystal

On 8/1/2022 12:24 PM, novice012000 wrote:

Crystal,
just wanted to let you know that the problem was caused by an issue with the Microsoft Office license. Once that was resolved the error disappeared.
Thanks for your help
Sarah
PS-I still dont see the option to include message thread in groups.io. sorry for not including.

Re: [MSAccessProfessionals] Textbox is populated with the "#NAME?" error code. after upgrading computers RESOLVED

hi Sarah,

glad it's working again!!!

how to Quote Post .. Duane uploaded an image on how to quote post in a reply to show previous messages using the web interface here:

https://groups.io/g/MSAccessProfessionals/album?id=249167

Groups IO interface
file name: GroupsIOQuoteReply.png
By Duane Hookom
Uploaded: 06/22/20
Size: 45 kB

kind regards,
crystal

On 8/1/2022 12:24 PM, novice012000 wrote:

Crystal,
just wanted to let you know that the problem was caused by an issue with the Microsoft Office license. Once that was resolved the error disappeared.
Thanks for your help
Sarah
PS-I still dont see the option to include message thread in groups.io. sorry for not including.

Re: [MSAccessProfessionals] Textbox is populated with the "#NAME?" error code. after upgrading computers RESOLVED

Crystal,
just wanted to let you know that the problem was caused by an issue with the Microsoft Office license. Once that was resolved the error disappeared.
Thanks for your help
Sarah
PS-I still dont see the option to include message thread in groups.io. sorry for not including.

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_