Recent content by Romper

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...