Recent content by XLEAccessGuru

Thank you! It's actually not a user prompt, I'm searching for monthly reports that we run automated. I'm getting there though!

PS - I won't always be searching for "ABC" as the 1st 3 characters. It may be the last three or in the middle of 50 other characters in the file name.

I know file system object properties code, but I'm over-complicating how to search a file name for a string. For example, I want to find all files in C:\MyFolder that contain "ABC" in the file name. Like I said, I'm overcomplicating this. Brain fried today so any help on what's probably...

In 2007 when I want to refresh an external data link to an Access DB, 2007 won't allow me to if the database is open, even if nothing is open in design view or in the code window. I do not have the DB set to open exclusively. Because of this I'm having difficulty automating automated external...

Awesome, it worked like a charm (the first one). Thanks so much for your time and help.

Thanks to both of you. pbaldy, I did read that post you linked me to prior to asking this question, but perhaps I read too fast. Same w/the help article. I read it prior to asking this but totally missed the rounding part. I feel stupid now. :o So if someone could point me in the right...

Anyone know why "99.5 Mod 10" would return 0? I'm using Access VBA 2007 and Mod doesn't seem to be working right. Data types being used are currency although I did try changing the variable data type to see if it would make a difference. Try the code below like this -...

Got it. Nevermind. I figured it out finally. For anyone wondering, it's in Access Options..., Current Database, Document Window Options. Select Overlapping Windows

OK. I'm totally embarrassed to be asking this b/c I'm quite an advanced Access developer, but 2007 has me stumped on something really simple. I'm developing my first db in 07 and have tried everything from help searches to msdn to googling. How the HECK do I resize a form window in 2007 and...

I searched help and this forum to no avail. Anyone know the code to initialize the attachment manager in Access 2007? Also, anyone have any suggestions for testing the file sizes of the attachments users are adding? For example, if I want to test that the file(s) attached are no more than 3...

thanks wazz. for some reason, the form was losing the focus resulting in the error. I just added a "Me.Setfocus" command that resolves the error. Thanks! :)

I have code behind a form that looks for missing data. When it finds missing data in the recordset, it finds the record on the form that matches the record ID in the recordset. It has worked fine until now. Nothing has really changed but all of a sudden I'm getting error # 2137 "You can't use...

Also filled Array out of order! In addition to your help, I wanted to post this also because I had trouble getting the "Last" idea to work at first because I was filling the array based on text box values. Problem was, it was not filling the names in order because when you use a loop to loop...

Thanks for all your help fellas (or ladies - not sure). Both of your posts helped me work it out. I turned out to be quite simple, but like I said, I'm not so great at arrays.

Hi everyone, I'd like to use an array to store a list of names. Then I would like to search the array to see if my name is the last value in the array. In essence, I need to determine if the person currently filling out this form is the last person in a list of names stored in an array. Make...