vba - Restrict Attachment File Size Access 2007 -


currently have database system has been designed log calls coming department. other agents on phone system information allowed attachments photographs, letters etc. allow attachments added there attachments control on form allow additional documentation added mentioned above.

the problem is, have found lot of people using system store large copies of manuals. causing file size of database shoot exponentially.

what know is, possible restrict file size of attachment through vba? example restrict 6mb.

to answer question following code return file size others mentioned above don't think want store attachments in access database database grow , may become unstable.

private sub checkfilesize(strmyfile)   dim objfilesys scripting.filesystemobject   dim objmyfile file   set objfilesys = createobject("scripting.filesystemobject")   set objmyfile = objfilesys.getfile(strmyfile)   if objmyfile.size > 6000000     msgbox "file big.", vbokonly   else     msgbox "file ok.", vbokonly   end if   set objfilesys = nothing   set objmyfile = nothing end sub

Comments

Post a Comment

Popular posts from this blog

apache - Remove .php and add trailing slash in url using htaccess not loading css -

i have add following code htaccess file removing .php extension , add trailing slash urls. worked fine reduced page loading speed , css code not loading @ all. pages ugly. please help rewriteengine on rewritebase / ## hide .php extension snippet # externally redirect /dir/foo.php /dir/foo rewritecond %{the_request} ^[a-z]{3,}\s([^.]+)\.php [nc] rewriterule ^ %1/ [r,l] # add trailing slash rewritecond %{request_filename} !-f rewritecond %{request_uri} !/$ rewriterule . %{request_uri}/ [l,r=301] # internally forward /dir/foo /dir/foo.php rewritecond %{request_filename} !-d rewritecond %{request_filename}.php -f rewriterule ^(.*?)/?$ $1.php [l] we can rewrite urls using .htaccess files. before writing in .htaccess files need verify kind of server using. can check server adding a <?php phpinfo(); ?> in php page. ensure mod_rewrite module enabled in apache server. can identified checking phpinfo included page. common methods used url rewriting follows ...
Read more

javascript - jQuery show full size image on click -

pretty self explanatory not workking . i want display full image when user click on image... yes know there tons of plugins but i want keep simple. any idea ? css : .full { display: none; width: 500px; height: 500px; margin-left: 100px; margin-top: -300px; position: fixed; background-color: #f00; z-index: 6; } .thumbnail { width: 50px; height: 50px; } html: <img class="thumbnail" src="http://4.bp.blogspot.com/-uhbdp2esxng/txneptvi92i/aaaaaaaaaky/upfqis7zto0/s1600/rihanna-wallpaper.jpg"> jquery: $(document).ready(function() { $('.thumbnail').on('click', function() { var img = $('<img />',{src:this.src,'class':'full'}); $('.full').html(img).show(); console.log('done!'); }); }); try looking how jquery works. $(document).ready(function() { $('.thumbnail').on('click', function(...
Read more