Search results

Hello, could someone tell me what I did wrong here. These statements are a bit tricky with the syntax. It was working once and I forgot to save it and now I can't get it to work again. I'm probably just overlooking something simple. Here is the code...

I'm not sure I can get the size down. What is the limit? Right now it's at 3,843 KB zipped.

I checked and the calculations are going through. strCriteria is getting the proper values.

Yes, I have and it seems to be hitting an error on "Me.Filter = strCriteria". The row source is a query. The SQL for the query is SELECT tblActionsPerWeeklyPlan.ActionsPerWeeklyPlanID, tblActions.Action AS Meal, Format([StartTime],"h:nn AM/PM") AS [Time], tblChallenges.ChallengeDate AS [Meal...

I am filtering a form based on the value of a textbox and when I click the next button it queries the main form and I'm trying to query the list box as well, but it is not working. There is no control source on the box, but there is a row source. Any suggestions. I tried to just query the...

Ok, so I found my problem. My bad. I was accessing a plan that wasn't created yet. I feel pretty stupid. My code is a little cleaner now, thanks!

That does make complete sense. I changed it, but it still shows the same error.

Sorry, I should have included that. It's the first line of code. "If Me.chkMealPlanStatus.Value = True Then"

I have a checkbox that is not checked and I am checking the value of it in the code with an if statement. I keep getting this error "You entered an expression that has no value." I am stumped. I have used this format before and it works, but for some reason, it is not working now. Here is the...

Wow! I just want to thank everyone for their responses. I certainly better understand the formatting process. I ended up using Time: Format([StartTime],"h:nn AM/PM") Worked like a charm. Thanks again.

is that supposed to be an "nn" or is that a typo?

Hi, I have a time field that I pulled in from a table. when I run the query it gives me 2 extra zeros. ie: 7:00:00 AM Not sure how to fix this. The fields name is StartTime and I tried StartTime:Format([StartTime], "hh:mm AM/PM") with no success. Any help would be appreciated.

Thanks, but I played around with it and got it to work. This is what I ended up with. [Forms]![frmSelectWeektoCreateMealPlan].[Form]![frmPersonalFoodItems_subf].Requery Works great. I can see the changes as I enter the data in the other form. Thanks for responding.

Hello, I can't seem to get this right. I have searched online and nothing seems to work. I have a main form with two subforms. One of the subforms is a list that when I hit a button I can add new records to it with a nice data entry form that pops up. You can still see the original list and...

Wow, so sorry. So many things in my head, not sure how I missed that. I did try that before, must have done something wrong. My bad. Thanks for all your help.

I do appreciate all the feedback on this topic. I found a simple fix. I set the resize value on the form to "No". When the form popped up, I resized it to the dimensions I needed and when I closed it and reopened it, the form kept the size. Yeah!

I tried the code and it didn't work. I did repeat for all the other subforms. The height of the detailed section will not change. The subforms need to be this height or all the actions won't appear. I somehow need to shrink the detailed section while keeping the subforms in the detailed...

Thanks for all the input. I found that the subforms were not big enough to show all the records, hence the scroll bars weren't showing. The scroll bars appear now, but my problem now is that the form is not big enough to show all the data and the footer. Is there a way I can make the Detail...

It's not off to the side at all, the form centers when opened. I tried reducing the form width and still no scroll bar. I did change the resolution and the scroll bar appeared. How can I fix that problem? I am sure that many screens will be at this resolution (1920 X 1080).

Hello, you might remember me when you see the program. I posted this a while back and didn't hear back from you, so I sent it again in a direct reply. 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...