Replies

Sorry for the late reply on this. For some reasons, I still do not get a notification e-mail when someone reply to the post. I thought I set up notification already.

We actually have over 72k providers. Obviously, this is the issue as the limit is 65K. I’m trying to adopt the workaround by Allen browne http://allenbrowne.com/ser-32.html

HiTechCoach, I’d like to learn how the following is implemented…

I avoid using a combo box for lists over 1024 (1k) rows. I use a pop-up form in continuous view or datasheet mode.

TIA,

HiTechCoach,

Thank you for feedback. At this moment i’m running the report for the user as needed.

Regards,

HiTechCoach,

I converted the production FE in accde format, re-linked to the production BE etc., and copied it to the user’s PC who is having an issue. The user still is unable to run the report: when prompt appears, input a name, click OK, nothing happens & no error.

Other than that, I noticed the benefit of converting it to accde format. Users used to get ‘debug’ window, and vba code etc. This is not the case now.

When you log onto their machine, are you using the same front end database file or do you get your own fresh/clean copy?

Yes, I’m using the same FE (everyone uses the same FE)

TIA

Regards,

Mark,

Thank you for the code,

Regards,

HiTechCoach,

Many thanks. Setting up trusted locations solved the issue.

Now, I should be able to make mods & test locally.

Regards,

HiTechCoach,

Actually, I used the original logon form, not the modified logon form. I did this to see if I can logon to my newly created dev. environment.

TIA,

RetiredGeek /HiTechCoach

I’m not sure where I went wrong, but using the built-in Link Table Manager, I did re-link my FE to the BE, but I was unable to open the form successfully.

My folder structure locally (desktop) is as follows

two folders

a. Copy folder –> I copied both BE/FE from the shared drive to this folder (just to be safe)

b. Development folder –>  Another copy of the BE/FE where I perform my mods.

And, below are steps I took to re-link:

1. Open the FE (shift + open)
2. Right Click the table, select ‘Linked Table Manager’
3. Select All & check ‘Always prompt for new location’
4. Browse to desktop to the ‘Development folder’ and select the BE, click open

I got a message saying ‘All selected linked tables were successfully refreshed” click ok and close.

When I opened the FE, the login form opened, I typed in my credentials and clicked ok. Nothing happened.

TIA

Thank you both for your feedbacks.

RetiredGeek,
re: … did you make the change in the FE to relink the tables?
No, I didn’t. That is probably my main issue.
I appreciate for sharing your code. Where can I add this code, and do I need to modify it?

HiTechCoach
This is exactly the type of best practice I was looking for.

Regards,

Thanks for the reply post.

HiTechCoach,

re: You did not mention if you deployed(copied) a new working front end…
The FE that is linked to the BE was deployed prior to I came aboard

re: What, if any, error message displays….
No error. Users click run report > Open Case Report > Prompted to enter a name & click OK, nothing happens

I’m not sure if the following test I performed give us any lead to the cause(s) of this issue:

1. I can run the report fine from my computer.

2. When I’ve the managers who are unable to run the report come to my desk and log in to ms access using their own credentials, the
report runs fine for them.

3. When I’m at the managers’ machine (they logged in windows) I attempted to run the report using ms access credentials, I was unable
to run the report.

4. I then used my windows login at the managers’ machine, log into ms access using my credentials, I was unable to run the report

I checked the reference file on managers’ pc, and determined to be the same as mine.

Though not sure, one of the manager thinks the issue started after ms office was upgraded to office 2016.

TIA

Regards,

Thanks for the reply post.

HiTechCoach,

re: You did not mention if you deployed(copied) a new working front end…
The FE that is linked to the BE was deployed prior to I came aboard
re: What, if any, error message displays….
No error. Users click run report > Open Case Report > Prompted to enter a name > click OK, nothing happens

I’m not sure if the following test I performed give us any lead the cause(s) of this issue:
1. I can run the report fine from my computer.

2. Few managers are unable to run the report: But, when I’ve them come to my desk and have them login using their MS access credentials on my PC, the report runs fine for them.

3. I then used my ms access credentials to log into manager’s PC, I was unable to run the report.

4. I checked the reference file on managers’ pc, and determined to be the same as mine.

Though not sure, one of the manager thinks the issue started after ms office was upgraded to office 2016.

TIA

Regards,

Thank you all for the reply post.

I’ll definitely look into the method suggested by RG to adopt in our environment.

HiTechCoach,
No, the same FE was deployed to everyone at the same time, as they all are in the same program/department.
And, the way the report is set up: first they click ‘Reports’ button  ‘Open Case Report  they will then be prompted to enter a ‘case worker name’
so far so good. After they enter the name, nothing happens (no error either)

I’m not sure if the following test I performed this morning give us any lead the cause(s) of this issue:

1. I can run the report on my PC fine.
2. I’ve managers who are unable to run the report at their PC come to my desk, have them login into ms access (using their credentials) the report runs fine for them.
3. I then went to one of the manager’s office, used my ms access credentials to log into ms access, but I was unable to run the report.

Though not sure, one of the manager thinks the issue started after ms office was upgraded to office 2016.

TIA

Regards

Thank you all for your reply post.

HiTechCoach

re: To test the theory about computer name you could log onto one of the PC where they were unable to run the report…
Do I log in to their PC (windows) using my credentials, or just application level using my ms access credentials?

re: For the uses that are unable to run the report, do other parts of the Access application run OK?
Yes, as far as I know other parts of the access application works ok.

RetiredGeek
If I understand it correctly, your code can be used every time modification is made to the BE & the FE will automatically be updated and end users will have the latest updates next time they access the FE. Correct?

Paul T
Is this done by right click my db (BE) > Security and set permission etc.?

TIA

Regards,

Thank you for the reply,

I accessed general settings >Messaging & Notification and checked Receive Email options.

In terms of permissions, I’ve couple of managers log into my PC using their own ms access credentials and run the same report that they were unable to run from their PC.
I was surprise to see they could run the report without any problem.

Can this be a network permission issue somehow attached to computer name?

How/where do I check this?

TIA,

Thanks HiTechCoach for the reply.

1. Correct, once I added the new field, my plan is to create a new query/form and report to reflect the new field.
2. Yes, everyone has the same copy. I ran the report just fine. I also watch another manager run the same report without any issues. However, there is a new manager on board that was unable to run it. That is why I’m guessing this is
a ‘permission’ issue. I’ve to investigate how the person before me set up the security.

By the way, where do I set e-mail notification so I’m notified whenever someone reply to my questions?

TIA,

Regards,

Don,
Thank you, it is working now. I’m not sure if the following answers your question..
re. how the sheets are populated and to further automate the rest in one click.

So far, everything worked as intended the next step in the manual process was to perform a visual comparisons between the two reports (order & Receiving). Let’s just take for example order # 51300 and it’s corresponding distribution amount. Following are possible scenarios:
a. If order # 51300 exists in order report, but not in receiving – we can display a message like “not in receiving”,
or ‘missing” etc.
b. if order # 5103’s distribution amount = $465.67 in both reports we get “0” (order – receiving) or 465.67 – 465.67
and we are not interested in this value
c. if distribution amount for order report is different than the receiving distribution amount (delta) we want to know this
value
So, once everything works as intended, what is the best way to utilize this macro every month? For example, I’ll be getting January’s file in the beginning of next week?

TIA
Regards

As an example let’s take

Following is o Omit records that = 0
o Missing  record is available in order report, but missing from receiving report
o Negative values 
o Positive values 