Search results

Exactly!! lol I'll try the refresh and let you know ;)

Hi, My code: Private Sub cboAgent_AfterUpdate() Forms("NavPage").Controls("NavigationSubform").Form.Controls("frmTermAgent").Requery Forms("NavPage").Contkrols("NavigationSubform").Form.Controls("rptAgentsTerm").Requery End Sub Is supposed to take the agent from cboAgent and use it...

Well crap then... I need the cumulative sums etc... Yes they can export to excel (with formatting), but not with the group footers (totals) working properly. I can save an export (with formatting and layout) so that the footers show properly, but if I assign that saved export to a command...

With the world moving to paperless it would be great to see the purpose of the reports change... I will take a look at converting my reports to forms when I figure out how to get it to do what I want it to. Thanks, Canadian

Hi, Is there any way to code my report to freeze panes like MS Excel? When I scroll right I lose track of the Agent name and when I scroll down I lose the headings. On large reports this creates more confusion than I would like. Is there anything that will assist me with this? VBA / header...

I set it up the night before last. Just figured I'd let it do it's thing a couple of times before confirming. :)

The code provided by @pr2-eugin worked beautifully. The file was closed each morning when I came in. Also, you guys may be interested in a file given to me by @TimW. It can be found in my post [Solved] Identify users with db open. The file is called "Remote Close". I've added that to my db...

I ended up getting the Remote close to work it it's marvelous! Thank you all so much!

Ok thanks pbaldy. I'll consider it. :)

Are you guys under the assumption that I have the users working from the mdb file? I save it as ACCDE for the users and they stay out of my mdb file. Any time the ACCDE file closes it automatically saves the record. Any forms with code that asks if the users want to save however, I'm unsure...

MarkK, I know how you feel about this, as we have had this discussion before, but that's not how this place is set up. Everything is on the network, we don't have access to the C:\ drive. IT has locked us out of everything so we HAVE to work off the network. I know it's not ideal, but it...

Because the users are driving me nuts... ;) Each time I make a change to the database (the boss adds forms and reports all the time) I have to save over the front end and people never close it before they leave at night. I have a few more complicated solutions, but they're a little over my...

Fair enough, and absolutely no offence taken or intended to be given. I just appreciate the help and any laughs I can get out of my detour filled path to success. :) Next time I will mention that it failed, and how it failed. In this case, my code failed so bad it did nothing... which means...

I was unaware that asking questions was bothering people Ken. I was also unaware that assumptions are appropriate. I did test it, it failed, so I asked the question. Although your initial answer did crack me up.

Wow is right... hahahaha I knew I had something wrong in the planning, just wasn't entirely sure what... I had played with On Timer, but still wasn't sure how to make it work and was obviously lacking in the logic department... Totally understand the logic now thanks to you guys. I'll try the...

Hi, New to VBA here... Will this code shut down my database at 2AM each night? Private Sub Form_Current() If Time$() = 7200 Then DoCmd.Quit End Sub I have it set to On Current in my navigation page... Thanks, Canadian

Galaxiom: Your assistance is always appreciated. :) TimW & Galaxiom: I will take a look at your zip files then decide which one I want to use. Both appear to do exactly what I asked for. Thank you both. :)

The advantages are not lost as splitting has other benefits.

All users use the same FE, but yes I've split the db. This leaves me hunting people down. :( Usually it's just a good laugh that I need to kick everyone out. The issue is when I can't figure out who still has it open.

Hi, I'm wondering if there's any way to find out who has a database open. I've saved the file as an ACCDE for the users and kept the ACCDB file as my working file. Whenever I make changes to the db I need to save a new ACCDE file on top of the existing one. In order to do that, I need to...