Search results

Hello, Thanks for hanging in there with me. Work has been overwhelming, and I haven't had any time to dedicate to this project. I will try to do better starting next week. Thanks!

I want you to know how grateful I am for all the help you have given me over the last weeks and months. You have saved me numerous times and I know this most recent problem has been a problem. If you cannot help, I understand. Otherwise, I would genuinely appreciate the opportunity to explain...

The points are all about accountability. After reading the one comment I sent you, I can understand the confusion. I had to understand this a long time ago, but I do remember how confusing it was when we first started. When the client is filling out their reporting form, whether they complete...

What can I do to help you understand this better? I, too, have struggled with this. The person who came up with this idea approached me a long time ago. I genuinely think this is more of a hobby for her. I have been working slowly on this application for years and she keeps finding things to...

Yes, because of the points. Not only are they being calculated on the form, but they are also being stored for tracking. They get points for checking the yes and no fields and then another point if its a yes.

Hi, I am sorry this isn't easier to understand. Let me try again. With this report, I am pulling the points earned throughout the weeks of the program. The points are put in with the "Enter User's Progress" button on the Main Menu and filling out those forms. The report lists planned points...

It is a poor design, but making a crosstab for all those fields is beyond me, and that was the only way I could get it to work. But it doesn't work. If you have more time to take a look at it, I would greatly appreciate it.

As far as the other report. You asked me to show you the query that pulls all the data. The report is Weekly Progress by Standard Action, and I am using twelve sub-reports to get all the data for all twelve weeks. The query is shown below. The issue is that I don't get all the labels if I...

Yes, when I hit "Output" on the SelectLoopReport form. I took out the code, that wasn't needed. This one guy who was helping me a while back suggested using "con" as a variable type because the crosstabs didn't like the temp variables. Looks like I'm not using that anymore. Ok, so that is...

Hello, I haven't had much time to work on this, but before I start the report I was talking about. I have the rptNSAByPlanWeek and am using John Accelerator in the example. This report is very similar to the Standard Actions by Plan Week report that you helped me with. The main difference is...

Thanks, DHookom; I did find the conditional formatting and fixed the bolding issue. Enjoy your time off, and if you can look at the subsequent report at your leisure, that would be great.!

I do have one more report that I need to fix. This one is set up strangely. Probably to know surprise! LOL. As with this last report I am having difficulty with the crosstab function. I can only include a certain amount of fields when I create the query. Using the same program you already...

Great, got it! I tried to figure out why the one action is showing in bold. Any idea?

I am still trying to clean up the report on my work computer. I was able to get the X's in, sort it by the index, and change the source of the text boxes in the header, with the exception of the Name. I am still stumped on why it is pulling double of a few of the actions.

I am so frustrated. I thought it was my computer, so I went out and bought a new one. Nice one, too. Alienware with an i9 processor. I went to run the query, and it did the same thing. Blue circle for a few seconds, and then the application closes. It is only with that query. I went and...

Well, this would all be great if I could get in and access the query. I'll have to wait till I'm back on my work computer. I did a fresh install of Windows, and I still can't open the query without it crashing. Still have the issue of duplicated actions.

I am trying all the suggestions with no success. I am resetting my computer. It doesn't make sense that it works on my work computer and not my personal one. I'll let you know. So, if I do get this to work, my next question is to ask why there is a W0. It doesn't seem very clear. I tried...

Thanks for that information. I did the scans and ran a malware scan; it got a few things, but nothing major. It's still happening every time I go to access that query. I'm perplexed. My next option is to complete a Windows installation, reinstall 365, and see what happens. It is troubling...

So I did a complete reinstall of 365, and as I said, it worked for the first time. I could see the query, but the next time I tried, it crashed. I looked in the Event Viewer, and this is what was found. Faulting application name: MSACCESS.EXE, version: 16.0.18324.20168, time stamp: 0x677829a1...

Something is messed up with my Access application. I pulled up this program on my work computer, and it's working. It still needs some tweaks, but it crashes when I open the query on my personal computer. I uninstalled and reinstalled MS 365 and got into the query once, but after that, it...