Search results

Hey folks, I've just created my own website where I'm trying to promote something that I have concocted out of Microsoft Access, Excel and Outlook using VBA. Are we allowed to post our websites to obtain feedback about layout and content or is this a big "No No"... Thanks, James

Hi folks, I am wanting to track down the path for the files that Access uses for it's form navigation bitmap images (first, last, previous, next). I want to get copies of these images so that I can use them in an Excel Form. I was able to create some similar nice looking images in...

If you look outside now you may get to see the moon, jupiter and venus in an alignment that makes a happy face :) ... apparently this doesn't happen very often. Gives you a warm glow inside!! :D http://www.news.com.au/story/0,23599,24732092-421,00.html

Hi everyone... it's been a while... Hope that you're all well. Using Excel 2002 on Windows XP... I'm Attempting to loop through 25000+ rows in a column and check if the cell value is between a given currency range. I will then save the row number of each matching record in an array and allow the...

A colleague found this website for me and it works a treat when you need to get around outlook security settings. No need for extra dll's, no need for Redemption or ClickYes... All you do is paste some code in Outlook and tailor your Access code slightly. I have just tested it on a 1000 emails...

I have some code to do this but it is long and laborious (and to be honest... quite rubbish) and I would love to see what other people can come up with... something short and sweet that does the job and nothing more. When I set-up my code a couple of years ago I remember having all sorts of...

Folks, I have been using a piece of code from Ghudson for some time and it works really well. It is used to display the files in a directory as a value list in a combo box. I use it as a way of allowing the users to link to archived files and reload them if they need to view an old report...

Hi folks, I have a bit of experience using a combination of vb, sql, unix scripting, access, dos etc. As well as very basic use of HTML and some static webpage design through Dreamweaver. I am considering an attempt at creating my own dynamic website with a MySQL db behind it, and I will need...

Hi folks, I recently had a requirement to send many reports via email with sensitive customer data. The only thing that IT would allow was a strong password-protected winzip file. I will include a little of the code here - the remainder you should be able to glean from other posts. I read...

Hi, I have some existing code that works fine. It allows me to output a report to a local drive, then zip and password protect the file, then I send the file on to the recipient. I have just been informed that the recipients won't have a copy of winzip... so I have to make it self-extracting...

Howdy folks, I have been trying to glean little ideas from different folk to come up with robust error trapping. I have put together something below that I quite like, but I was hoping to get some feedback to see if there is anything else that I can do. Code and explanation as follows...

Folks, I have a file transfer form on my database which works well. Sometimes the files get transferred in the wrong format (ascii versus binary transfer methods) We can't ascertain which format will be correct in advance (sometimes a bigger file requires a different method). Currently the way...

Gents/Ladies, I have created a database with an "on-open" function that creates a temporary directory and certain program files on the local drive of a users pc. This directory is used for FTP and archiving of sensitive customer data, so when the database is closed it runs code that deletes...

Afternoon Folks, I have a database that multiple users have access to. We all have new pcs of exactly the same spec. We all have the same oracle ODBC, which is linking to tables in an oracle database on a Sun F15k Server. The linked tables are set-up using my oracle account with saved...

Hey folks, I have worked on this for a bit... and have finally given up. The filter works for the other variables, but the dates don't work. My regional settings are set to UK, but I think it may be converting them to US format in Access. The filter on dates either applies and brings back...