Search results

Hello, you might remember me when you see the program. I am redesigning this application the way it should have been done in the first place. I have a friend that is helping me through this, but even he is stuck on this. When you open the database, it will open to the “Main Menu” and from...

Hi, I have a form that has several subforms on it and when I open it in a modal view, the vertical scroll bar disappears. It is there if I take it out of modal, but I really want to be able to use the modal feature. I hoping to have the program act as an app that the user doesn't see any of the...

I thought so too, but it still put the year on. This solution is working well. Thanks for the help.

I figured it out. =Format(DateAdd("d",7,[TempVars]![TmpStartDate]),"(mm/dd)")

I'm getting an #Type! in the text box instead of the date. I tried the (mm/dd) and took of the parenthesis in the control source and it is ignoring the format. It's putting it with the year.

I am positive. I am using the Start Date on the form I'm working with and it shows up in that field.

Hello, I am having trouble getting a date formatted correctly. I just want the mm/dd to show in parenthesis. ie: (3/9) It was working when I created the text boxes, but when I went to display the forms it didn't work. In the control source, I am using a temp variable "TmpStartDate" and...

MajP, You Are The Man! This solution works great, it took me a little time to get it all straight and looking professional, but I got it. Thanks to you.

My apologies MajP, it does work for the one action that is showing. My hopes were to pull up the list of actions and select which ones I would like to print. I would think that there will be times when more than one, but not all, will need to be printed. Just trying to accommodate all...

I do realize that this database has a lot of issues, but believe it or not, it does work well. There are many reasons why things are the way they are and when the next version of this comes out, all of these issues will be addressed. The needs of this project were not given all at once, but...

I have a cut down version of my database that focuses on only the problem at hand. Still too big to attach, but I have a google drive link to download the database. https://drive.google.com/file/d/1a_HL1137PP5ChK_A4izQNOWPy_4UCemK/view?usp=sharing If you open the AchmntProgress form and...

I just tried adding the field to the two tables but seeing that it has run through two other queries the field is not updateable. If I can add a boolean field to just the ActionQuery, I think i can get this to work.

The ActionsQuery is actually the result of two other queries. Instead of adding a field to the two tables that were used to create those queries, I need to add a boolean field to the ActionsQuery. Not sure how to define it in the query. Can you help with that? I was also thinking that the...

I was thinking about trying to add a checkbox field to the ActionsQuery. That way I can use a form to check which actions I want and then use the criteria to sort which records I want to print. I just don't know how to add a column to a query.

Hello again, Well, I was able to get pretty far. The form looks good (The one in the cutdown version doesn't look as good as the one I'm using) and I have the report version done as well. My problem is that I'm am not sure the best way to get only certain actions to print. I am using the...

Hello again guys, This is kind of a continuation of another thread but wanted to start fresh. I have created a form with a chart that shows the Planned and Actual values of Actions throughout the 12-week plan. I linked a combo box to the chart to see the different actions. This alone took...

Thanks guys, I got it. IIf(PlanAndActPointsUNION.Index between 200 AND 300, PlanAndActPointsUNION.Action & " Start Time", PlanAndActPointsUNION.Action)

I have a field named action and there are sometimes actions with the same name, but different indexes. I would like to add the words "Start Time" to actions that have an index between 200 and 300. I tried something like this --- IIf(PlanAndActPointUNION.Action between 200 AND 300...

Having a hard time grasping this. I did make the two separate crosstab queries, but not sure how to combine them. I uploaded a new cutdown version of my database on google drive. https://drive.google.com/file/d/1cL05Pm7ZjwQDmNIEIOwiVwwaH-5X9VM8/view?usp=sharing

Hello, I am trying to create a crosstab query that has two values under the cross tab columns. I am attaching an excel file that shows what I am looking to accomplish. The first sheet has the data and how it comes up in the query I made and the second sheet shows how I am hoping to get the new...