Search results

Hey vbaInet, thanks for the tip...I'm going to try this out now!

Hey vbaInet, thanks for the reply! It's actually a bit more simple than I probably made out, but I used more or less the same code as PNGBill's: Command Button code (with all the other fluff taken out): If Me.OrderType = "TUCO" Then TempVars!OrderType = "TUCO" End If Report Open Event Code...

Thanks guys for this thread, it's been helpful to me today in solving a new problem that's arisen with making text boxes etc visible based on different variables when creating a PDF report and attaching it to an email without opening the report first! :)

Hey vbaInet - thanks for the reply! Well, in my defence here, I didn't actually write this code - it was already in place when I took over the role! I know a few of the naming conventions for prefixing control/field names (cmd, txt, cbo, chk etc), and I always use them when initiating new code...

Hey, Uncle Gizmo - thanks for the reply and the bump! I've done the above, and this fires okay... *EDIT: also worth mentioning, the Proceed button is visible at this point!

Hi guys, this is a bit of a weird one, and probably more to do with my rubbish VBA skills than anything else, but I'm hoping someone is able to clarify either way!! We use our CRM for entering client orders, which is done through our 'OrderEntry' form. On that form we have a subform that we use...

Hi Dave, Just as you posted this I realised what you were talking about, currently fOSMachineName is only marked as Function fOSMachineName() As String But I've now changed that to Public Function. fGetUserName and fGetUserType are both public, but as they both use fOSMachineName I guess...

Hi Dave, thanks for the quick response here - I'm not sure, as those functions were already in the system when I took over the role! Would you be able to advise how to check, please? Thanks, Jeff.

Hi guys, So I have a bit of an in-depth problem here, so I'll try to be brief but include as much information as I can! Our CRM is an Access 2007 database and we use it for all sorts of things, including raising orders for our clients. When our users open the database they are presented with...

So I've just cracked a way of only attaching the queries that contain data: Private Sub cmdWeeklyEmail_Click() Dim MyDate As Date Dim MyWeekday As Integer MyDate = Date MyWeekday = Weekday(MyDate, vbSunday) If MyWeekday = vbThursday Then 'obviously this will be Friday, I'm just using...

Hi guys, Yet another random request from me that I'm hoping someone will be able to assist with - this time based around a membership database that we're currently running on behalf of a client. The database holds around 2,000 members, each with their own expiry date, and each week we email a...

Hey, thanks for this! So I just replaced: strHTML = strHTML & ts.readLine With this: strHTML = replace(strHTML, "DearName", rsE1!DearName) And the emails fire up with the correct EmailTo and Subject, but the actual body text is blank. Also, when I run the code I'm now getting 'Compile...

Hello! Thanks for this advice! I've amended the code accordingly, and I will certainly take on board good practice of declaring all variables in the first block of code in the future. I've set a reference to Microsoft Scripting Runtime, and that error no longer appears! :) Unfortunately, the...

This year is our daughter's first Christmas, and she'll also turn a year old on New Year's Day - so it should be pretty cool. I've had enough of it already though, there have been too many Xmas ads on the TV for far too long already, plus most shops on the high street (or online) are shoving...

Hey, absoloutely no problems at all - thanks for taking the time to get back to me. So I've set these parameters here: Select Case Report Case "60 Days Email" Dim MyItem, OL, strHTML, strLine As String Dim fs As New FileSystemObject Dim f As File Dim...

So, further to the above, I've had a bit of a play around and after a lot of googling I found that just 'dimming' FS, F and TS without specifying a type works - as in, it maintains the commas from my original report, but the text is all over the place...if someone can tell me how to add an...

Hey, thanks again for this - and apologies for taking ages to reply, I've been super busy and this project has kinda sunk to the bottom of the pile for a bit!! I've implemented this code, but I just need to know what to set fs, f and TS as (string, integer, boolean), please? Thanks! :)

Hey, Thanks for replying - apologies for not getting on here sooner, I've been out of the office for a couple of days...I'm going to check these solutions out and then get back to you to let you know how I get on!! ;)

Hi guys, I've been looking at this for the last couple of days, and I've got as far as I can with it - so I'm on the lookout for some assistance, if anyone here is able to do that! I am very much a layman when it comes to Access terminology, so I won't get offended if you guys explain things...

Hi Michael, Thanks for posting all that up - my apologies for not specifying whether I was using VBA or SQL! :o I didn't realise you could place an If...THEN...ELSE statement in a Select Case statement, so that's interesting. I think between this and Rx_'s suggestion I have what I need - so...