Search results

Thanks very much. ;)

I did a compact and repair and the file size value changed to 17.13 so as you said, it will already display 2 decimal places Thanks much for your efforts today Isskint, I appreciate it.

Woohoo! Now it works beautifully! Just to be a pain in the rear end, at the moment it displays:- 18.2 MB Can I edit the function so that it displays 2 decimal places? Thanks so much for sticking with it :D Very happy chappy.

I have tried both with and without = If I enter the Control Source as =GetFileSize it automatically gets changed to :- =[GetFileSize]

Okay, the module now saves with no red lines. My form text box still just displays #Name? I triple checked the module to ensure I've written it just as you suggested. What else could be the problem. I knew there was a reason code scares me! That one line is the only one I should have edited huh?

Can't get it to work, it keeps highlighting that line in red when I enter the path. Could this be because the folder Dave's Collection contains an apostrophe and therefore it sees that as some sort of code? :confused:

Haha, being the twit I am, I copied your code word for word. Do I only change :- StrFilePathAndName = C:/Documents/Dave's Collection/New Library Do I also have to add the file extension for the database?

I knew I'd muck it up! My text box just displays #Name? What did I do wrong?

Thanks, Just playing with it now. I'll be sure to let you know how bad I go! :D

Okay, I'm guessing you mean normal module as opposed to class module. Do I have to name the module so it links to the text box control source? Outta my depth! :eek:

Thanks to you both, I'm a complete bonehead when it comes to creating code Isskint, how do I create a normal module? Is there a dumb-ass short tutorial you could link me to so I don't screw this up, or can you just tell me which icon I select in vba for a normal module. I'm using 2007. Thanks so...

Hi all, I remember seeing a thread regarding setting up an automated Compact & Repair process, but I can't seem to find that thread now. Could someone please direct me to a reliable version of this type of process. Thanks.

Hi all, I have created a form that acts as the main / home screen for my database. Is it possible to add a text box or other control that will display the database file size so I can monitor my database growth without going through My Computer or Windows Explorer? If so, how?

Thanks, but as it is, in the last few weeks I've had to try and grasp normalization, relationships, queries and many other small tit-bits just to get what I would consider the most basic of a database to function. I bit off more than I can chew in such a small amount of time and now my brain is...

Since a couple of people have asked, here is the clarification. By "better" I mean, safer, courteous, law abiding, in control, patient, has an understanding of the mechanical forces at work, has a good perception of the environment and conditions they are in and any other attribute they would...

Okay, so women drive 28% less than men at night, would that then mean that if they should decide to drive at night they'd have 28% more devastating statistical data to add to their gender rating. Just kidding! Oh, by the way, the lady in the pic hasn't got her seat belt on! Haha :D

I rest my case! And near a school bus too, just as I was mentioning earlier. Nice work Isskint, I love it!

Yeah, I was aware of that and I know you're right but I really didn't want to break them up like that and then attempt to bring them back together to display properly. Oh don't worry, this whole mess has been a massive learning curve for me, and I do appreciate the assistance everyone's been...

So true! The thing that amazes me is the zones are there to protect all children including their own, yet this is like a red flag to a bull to some!

Thanks Bob, That's just what I needed. Works beautifully now. I appreciate you perservering with me. Cheers :D