Recent content by Jibbadiah

Time to get some new software at work. Have a look at the following sites - http://www.vbaexpress.com/kb/getarticle.php?kb_id=875 http://www.jpsoftwaretech.com/save-outlook-2003-e-mail-attachments-automatically/ The combination should cover off most requirements but you'll need to tailor them...

Hi megatronixs, Think that I'd originally used Outlook 2010 and earlier. In 2013 you might find issues with improper decoding of attachments. No idea how to fix it. Some files seem to work and others don't. I've got it to partially work in 2013 but haven't had a chance to look further. If...

See point about modulus... Only updates if condition is true... I.e in example 100 times no matter how big tyhe recordset

I use a lot of progress bars in my forms because I regularly loop through many records (multiple emails, reports, files, etc). It is good to have the bar to tell the user how things are progressing and it is far better to have a % complete meter than those bullsh*t "night-riderish" moving...

Here is something that you might be able to alter for your own purposes...

Sounds like a strange approach. Use two list boxes. Once the first is selected it limits the second to dates greater than the first. Rather than hidden text boxes you can just set your lists to keep the date of the column selected. Then the user knows what they have selected as well. "Pick...

Unless the region table has a sub-dimension (e.g. suburb) then it shouldn't have multiple entries for an Area. If there are multiple developers working on the database then you had better just stick with the status quo. If it is just under your management now I would take a back up and have a...

Just a note... If I knew that my area lookup had duplicate entries... A) I would dedupe them and fix all references. B) Remove the possibility of getting duplicates in future. It is worth the effort to stop future workarounds in other parts of your dB. James.

Your message with a less than operator is being treated as an html tag. I guess the red ">" is telling you that you have an incomplete tag. Is there someway to enclose that message in double quotes or something?

Sorry... updated, cos pasted the wrong code Public Function Testing() Const booBold As Boolean = True Dim strText As String Dim strColor As String Dim strMessage As String strColor = "black" strMessage = "check failed:too short 500<1000231231" strText = "<div>" & Format(Now(), "hh:nn:ss") &...

You'll need to write that as a query first and then reference the query instead of the table. At some later stage you can try to investigate sub-queries, but that would be the easiest way for now.

In my case I was using this code to winzip and password protect attachments for emails. 1400+ personalised email attachments for memory. His scenario sounds similar and if you are outputting a thousand webpages and sending them via sftp in the same code to your server then yes... you might need...

Why not copy the file and then import or link? That way you don't interrupt other users and you aren't trying to view data sitting on a remote (and in my case often slow) sharepoint server. Use File System Object to copy sharepoint file to a local directory for use. Referring to a sharepoint...

Yep, agree with spikepl. I like to have all the code in one place but rarely do I follow my own rules. Sounds like you'll do this in a recordset and create multiple pages. You may want to take a look at the code below if you are going to call external scripts. It used to work well for my...

View image. Double click the join properties and choose the middle option. i.e. All records from Main table and only those from the other tables where join fields are equal. By doing that and setting the value to null you effectively remove them.