Replies

Just a thought, but why don’t you put a combobox on the form that has two values…
FirstOfMonth… DateSerial(Year(Date()),Month(Date()),1)
FirstOfNextMonth… DateSerial(Year(Date()),Month(Date())+1,1)
That way the user would only be able to choose one of the two…

Does that help?

Okay… I’m no expert with Excel yet but … did you create the listbox using the Forms toolbar or the Control ToolBox toolbar?? … If you create the listbox using the Control Toolbox you’ll be able to reference it in code… I’ve done it quite a few times…

Okay… I’m no expert with Excel yet but … did you create the listbox using the Forms toolbar or the Control ToolBox toolbar?? … If you create the listbox using the Control Toolbox you’ll be able to reference it in code… I’ve done it quite a few times…

It does default to Admin, but personally I think it’s a BAD idea to have your users go in and change permissions themselves… It leads to…… well… exactly what’s happening to you now…

Check out Wendell’s tutorial that Charlotte mentioned… It’s a great place to start… We can hold your hand as you have questions after that…

It does default to Admin, but personally I think it’s a BAD idea to have your users go in and change permissions themselves… It leads to…… well… exactly what’s happening to you now…

Check out Wendell’s tutorial that Charlotte mentioned… It’s a great place to start… We can hold your hand as you have questions after that…

I’d do this in two queries…

First, in a Totals query… Group on the Account number field, and use Max on the Payment Date/Time field… That should give you the most recent payment date for each account…

Then I’d make a second query with an Inner Join of the original query and the totals query, joining on account number… The join will find records in both tables where the account number data matches…. In this query select the Date/Time field from the totals query and the account balance field from the original query…

This should get you what you’re looking for… HTH

I’d do this in two queries…

First, in a Totals query… Group on the Account number field, and use Max on the Payment Date/Time field… That should give you the most recent payment date for each account…

Then I’d make a second query with an Inner Join of the original query and the totals query, joining on account number… The join will find records in both tables where the account number data matches…. In this query select the Date/Time field from the totals query and the account balance field from the original query…

This should get you what you’re looking for… HTH

Whether the forms are visible or hidden is irrelevant… The Forms Collections only recognizes forms that are currently Open… If you want to manipulate the forms properties by code, you’ll have to (I believe…) open the form (visible or invisible as needed) before doing what you need to do…

Whether the forms are visible or hidden is irrelevant… The Forms Collections only recognizes forms that are currently Open… If you want to manipulate the forms properties by code, you’ll have to (I believe…) open the form (visible or invisible as needed) before doing what you need to do…

so much… Appreciate it!

so much… Appreciate it!

Okee dokee Steve…. Thanks!
Sounds like it’s time to resort to plain old control breaks…

Have a great day!

Okee dokee Steve…. Thanks!
Sounds like it’s time to resort to plain old control breaks…

Have a great day!

Thanks for the tips Hans! I reallllllyyy do appreciate any and all advice…

I made the change to the code to add “and not Grand Total” because when I added the “row – 1” bit to get the Currency, I ended up getting “U$, Grand Total” on the bottom row of the data…. It was a quick fix, so it may not be right…

I am getting the right data from the first sheet… It’s the amounts that I want to pull in from the “DIRByDept” sheet that aren’t… If you look at the third sheet you’ll see that the spot for the US Amounts from that sheet are coming in as the Canadian amounts… repeated from earlier rows…. I BELIEVE, because the code you helped me with is finding the first match for “001 Totals”, etc and stopping there… I need to SOMEHOW tell this thing that it’s now needing to find the US amounts OR to find the second match for “001 Totals” etc… Am I making any sense??

Thanks for the tips Hans! I reallllllyyy do appreciate any and all advice…

I made the change to the code to add “and not Grand Total” because when I added the “row – 1” bit to get the Currency, I ended up getting “U$, Grand Total” on the bottom row of the data…. It was a quick fix, so it may not be right…

I am getting the right data from the first sheet… It’s the amounts that I want to pull in from the “DIRByDept” sheet that aren’t… If you look at the third sheet you’ll see that the spot for the US Amounts from that sheet are coming in as the Canadian amounts… repeated from earlier rows…. I BELIEVE, because the code you helped me with is finding the first match for “001 Totals”, etc and stopping there… I need to SOMEHOW tell this thing that it’s now needing to find the US amounts OR to find the second match for “001 Totals” etc… Am I making any sense??