Search results

Hello all, I'm wondering if anyone could help me (again) I currently use some Vba and XML so send email to Mandrill to go out via their mail server. The problem I'm having is that the code I am using utilises SMTP which is making each send take a little too long (about 1 a second) The...

Yes to unbound and it looked like cheeky worked!! Could I ask what that did and why it worked for next time please? Thank you so much for helping!

Hi Paul - same issue I'm afraid. Thank you for trying to help

Hi Paul, Thanks for responding - I did find this page too - but I'm still at a loss as to what to do about it? Best, Phil.

Hello experts - I'm hoping someone can help me please? I'm having an issue (I think) with the VBA Date() function putting an american date in a field (even though is displays in British format) The whole issue is; I have a field calls Date_Today which is being updated with...

Right - well that got rid of the error - thanks very much again for your kind help - off to do the fun bit now and try to get it going! Thanks again! Phil.

Hi Paul - this looks really good and I've just put it onto my TS - however at the enclosed lines in the utility: Private Declare Function SHGetPathFromIDList Lib "shell32.dll" Alias "SHGetPathFromIDListA" (ByVal pidl As Long, ByVal pszPath As String) As Long Private Declare Function...

Hi Paul - I've not no. Thank you for responding - I'm off to take a look now

Hello all - I'm hoping someone can help me please? I have a terminal server with multiple users working on an FE / BE database. Each user has their own FE (I know they can work off one on terminal services - I won't bore you with why they each have one). When I make a change to an FE, I need...

Hello all, I'm using the below to send emails from access. I have a HTML file saved on my desktop which is linked to a mail server. I need to be able to reference that HTML file (D:\Files\letter.html) and send it in the body of an email. I've tried a basic file path on the .HTMLBody part of...

Sorry - to clarify - if I do an Is Null as part of a larger search (IE the other like or is null queries) then I get 0 results Just did an Is Null on that field as a standalone query and it returned the null values....

Hi, no it doesn't give a result when I do Is Null I also tried Like "" Thanks

I think that property value only applies to text, memo and hyperlink fields....

Hi, Thanks for the response - the field property in the query or on the form please? Thanks!!!!

Hi, I'm creating an advanced search form which is making use of Like queries and is Null. A working example is below: Like "*" & [Forms]![Frm_Data_Mine]![Combo_Primary_SIC] & "*" Or Is Null So this either returns matching values from the field, or basically ignores this if left blank. All...

Yep - that did the trick - thank you very much indeed!!

Hi - I've seen qutie a few posts on this, but I just cant seem to get my head round things and would really appreciate some help!! I have a combobox: "Combo_View_As" This sits on a form and get's it's datasource from the table: "luAutorisedUser" and the field: "AuthrisedUser" This gives me a...

Hi both, Thank you for your response - that's pretty cool and worked perfectly!! At the risk of being a little cheeky - is there a way this could be tied into a chart? The way I usually do my reporting forms are charts with a query as the control source - so I send to have to do 1 for avg...

Hello Exerts - this one has elluded me for ages!! I'd like to be able to change the Total Value in a select query using vba from say Avg to Sum The way I'd like to be able to work it is a from a combo box with Average Sum Count Then this change the Total value in the query. Is there anyway...

Hi, I'm hoping someone can help please? I have a db that is performing a mailmerge from access to word. All works fine. I'm trying to find how and where I can put a line in the below to print more than one copy if anyone can help please? Thanks in advance for any support!! Dim LWordDoc...