Search results

June7 I am a little lost with what is going on with that crosstab query, but after making the "Query1" and using the SQL to create the 2nd query; it is asking me for a parameter "Query1.StandardAction" Also, it is showing all the users when I need the report to be designed around only one...

If you want to use a static value, use "4" for the UserId. The two tables represent all the actions that the client has chosen to be responsible for. I need to make two separate tables because of the timed value in the "Weekly_StartTime_Challenges" and the "X" value in the "Weekly_Challenges"...

Like I said I was just trying stuff. Union was just a guess. Yes, I will be needing pulling up the report per user at any time throughout the 12 weeks.

Also, that query is named "ActionsByPlanWeek"

That's exactly right. What I usually do is start to open a report. Enter - Reporting Forms - Select a person"Rick Smith" is one I have been using the most for testing. - Select a week and a Day - Next. Once you hit Next the TempVars are assigned and you can go into the design view. They...

Hi June7, Thanks for the help with this. So here is the query that I came up with. It does what I want, but I need to weed out the duplicates. Some actions can be both timed actions and accountable actions. SELECT UserID, WeekNumber, StandardAction AS [Standard Action], Index FROM...

My file was too big to upload but I have a google drive link that has the whole project. If anyone can be of assistance, it would greatly be appreciated. Once you have the database and have any questions on what is actually needed, don't hesitate to ask. All the data in the database is...

It has a lot of forms and reports

Hi June7, Sorry, it has taken so long for me to get back. I had other things that came up. I'm trying to attack this issue again am willing to send you my database. It's all just made up information for testing purposes, but its 4MB and too big to upload here. Any other suggestions on how I...

Hello, I need to create a form that shows all the actions that have been chosen for each week. I am hoping to have all the actions for the first week in the first column and a column for each week's number up to 12. The only thing in the week field will be an "X" if they have chosen that...

If I use VBA, whatever I program happens to all the checkboxes in the subform. The IIf statement was in one of the examples IIf([Field1]=[Field2],"R","") - was the example. I think conditional formatting is the way to go, just need a little help with the statement.

So if I used conditional formatting on the Tab1 field. It would look something like this. Please make any corrections needed for this statement. =IIf([Tab1] Is Not Null, "STCYes.disabled"and STCNo.disabled", "STCYes.enabled"and STCNo.enabled" ) Just guessing here.

Hi Guys, I just wanted to put this one out there again. I have daily forms for the week and they have actions that need to be marked off with checkboxes. Depending on the value of one of my other fields, I want to hide or lock a couple of checkboxes. If I could even gray them out or...

I decided to just make the subform a little bigger and changing my record count. The scrollbar only shows up when I need it now. I'd rather have the extra space at the bottom instead of the scrollbar. Thanks for the help.

I don't think it would matter if it was zero-based seeing as it is going by the height of the subform. It just shows up when there are just enough records to fill the box. I don't need it until there are more records than the box can hold. I am not familiar with how to turn on the scroll bar...

Hi Guys, I have a subform that will increase in width when the number of records reaches 8. When it gets wider the scrollbar also appears. This problem is that I don't actually need it to get wider until the record count is 9, but the scrollbar appears at 8. If I change the VBA to accommodate...

I tried this, but it doesn't work, but I think something like this might. Maybe some pro's out there can help tweak this to work. If I can get it to work in one subform, then I should be able to get it to work in all of them. Private Sub StartTimeChallengeYes_Click() If...

dogs - Thanks, but I don't think I can use this. My checkboxes are linked to tables and need to be visible and able to check and uncheck. Interesting stuff though. Maybe I can use it in the future. Thanks. Still gotta work through this problem.

J7 - That is just the way my form is set up. My pointing system gives them achievement points just for checking the box. This is why I have to have a Yes and a No box. Not to mention I need the visual for the clients to see. Not sure why you keep questioning my design. My boss likes it.

Yes, they are Checkboxes, which makes it hard to conditionally format them. Maybe I can loop through the records? Not sure how I would do that. I read somewhere about using "Expression is", but can't find a good format for the expression. IIf[Null]...