Search results

So in my solution, I ran across a little clitch. It's should be very simple to most that monitor this site. I am using a Select Case statement and am getting the error "Object variable or With block variable not set" Here's the code that is getting flagged. Case 217 If...

I think I came up with a solution. I could use code when the value is being entered on the form. When the client checks the box, I will run it through a Select Case statement. Not sure where I should put it. I'm thinking "AfterUpdate" or "LostFocus". I could also do it when I calculate all...

I am using 2016, so creating the graph is going to be different on my end. The actions are the same. In one query they are "Actions" and the other they are "StartTime Actions". I was wondering if there was a way to do a function or something in SQL. Something like- If Action = StartTimeAction...

The chart is pretty much what I need. It does only need to show the 7 days, not 8. I'm a little worried about the issue of combining the PlannedAC and the ActualAC values to the Planned and Actual values in the other query. The final query should have the two values combined for the action...

I grabbed it off this site and opened it fine, not sure why it's not working for you. Since you didn't have a problem with the Google Drive link, I provided an updated one. https://drive.google.com/file/d/1PK7ZJLQneyx1YZEollB19XlwsvIJCFLU/view?usp=sharing That should help. Good night, I'll...

Micron, Thanks for posting that, but I made a lot of changes since that version. Hopefully for the better. The cut-down version only has what is needed for creating the graphs. I still would love to know how you condensed that one version of the database. It was over 13MB. I got this one...

This Full database does have a lot in it and it does an awful lot of things. The cut-down version only has a couple tables and a few queries. I just double-checked the DB and everything is there that is needed to create the charts. Yes, June7 I'm quite sure you remember the first version, you...

I know that people are skittish about using a link to access the database. I was finally able to condense everything down to under 2MB in a zip file. I have just the queries and tables that I am using to pull the data. I made some progress in organizing the data to get it ready to make the...

Sorry, I forgot the excel file.

I cut down my database so it only has what is needed to make the charts. I'm using the planned and actual query and am hoping to get a chart for each action. I made a quick sample chart in Excel to show you what I'm looking for. The text on the X-axis should only have the week numbers, but...

You see I am using a Yes checkbox and a No checkbox because The client gets accountability points even if they didn't complete there challenge. So, I need both boxes.

I have a query that has the "UserId", "WeekNumber", "Action", "Planned", and "Actual" as columns. I need a chart for each action that compares the "Actual"(Days Performed) against the "Planned"(Days Performed). The Y axis would have 1 - 7 for Days of the week and the X axis would have the Week...

I'd be very happy just disabling no box If the yes box was checked or vice versa.

Sorry, I did forget the file. I working on something else that is blowing my mind. I might make a post on it in another thread. Heres the file that I believe you zipped to make it small enough to upload. I still would like to know how you did that.

Hello, I have a subform that has two sets of Yes No checkboxes. The second set of checkboxes doesn't need to be used unless there is a tab reference in the record. My wish is to have the boxes set that you can only check yes or no, not both. The other wish is to have the checkboxes disappear...

Thanks, Micron. I'm not sure how you did that, but thanks.

Yes, it's still 4.03 MB

Is there any service or site you do trust? The database is over 4MB zipped. I agree I need to take the bulk out of it and would love to approach this more professionally, but I can't risk deleting anything without replacing it and testing its functionality.

Tried using this DLookup and getting the value for week 1 instead of week 3. Any advice. I think I need a "&" somewhere or missing quotes. =DLookUp("[TotActAcntPts]","[PointsQuery]","UserID = [TmpUserID]" And "WeekNumber =3")

This isn't the first time I have had criticism on the design of my database. This is my first time doing anything like this and although the design is not traditional, it is working well. I appreciate all the constructive criticism and would love to sit down with a few of you and redesign the...