Search results

Ok, I'm going to bed after this post, but I wanted to get this out there. I took out the ORDER BY statements in Query1 and was able to add the TempVars as a Parameter(Thanks for that link). PARAMETERS [TempVars]![TmpUserID] Long; TRANSFORM First(Query1.Idx) AS FirstOfIdx SELECT Query1.UserID...

I will probably use the IN phase, I didn't forget about it, but was pleased to know that It will grab as many weeks that are in the database. I just updated the last entry, let me know what you think and I'll look over that link you sent.

I'm not sure why it didn't work either. I figured out how created a new crosstab query in the design view and got it to work(thanks to your example). My problem now is getting it to recognize a temporary variable. It gives me an error when I use them in either query. Here's what my queries...

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...