Search results

Hey Paul (just seen your name in your sig) - this is really helpful, and I have copied the Maximum function into a new module, but how would I load the four dates from my continuous sub form into that function, and then add the correct text ("Last Chased:" or "Broadcast:" in front of the max...

Hi Spike, thanks for the input - sadly, I'm working on databases that have been implemented previously (without my input)! I'm all up for renovating where I'm able to, but most of my Database work is reactive as opposed to proactive due to other work duties!

How do you mean?

Yo, no need for that pbaldy - I appreciate the help, suggestions and feedback from you! Also, thanks for the link about relational design...I'll definitely check that out when I get some time, be good to get some history on the subject. I agree with (and welcome the idea of) anything that...

Lol, I guess so!! But seriously, three chases are all we are prepared to do for the artwork (so only need three chase date fields), and the next part of that process is to Broadcast.

We'll just add the new field in to the pre-existing table.

Hi pbaldy, thanks for the link - I'll take a look now! The date fields are all in a table together, although not a separate table - they're housed with a bunch of other data in tblAllocation that deals with our Direct Marketing campaigns. Cheers!

Hi guys! I'm hoping someone will be able to assist me in providing a piece of code in order to achieve the following, please! We're looking at a way that we can easily display what stage our clients' email marketing campaigns are at - in one section of our CRM our Campaign Manager will enter...

Hi guys - thanks again for all your suggestions and assistance, and apologies for the very late reply...been kinda busy here again, so dropped off this project! Finally manage to solve the problem, by using the following: vSQL = " INSERT INTO tblProduction_LogDate ( HistoryID, LogDate...

Hi guys, I'm finally back on this project again, and I have to say that I'm still stumped!!!

Hi Rain, Thanks for checking up - we've been moving offices for the past week, and today is the first day I've sat back down at my desk! I have a ton of reports to catch up on, but this project is my next priority so once I've caught up on everything else I'll pick this back up again and feed...

Hi RainLover, thanks for the response - this is what I'd done originally, and was having trouble with. Probably should have mentioned that to start with! :)

Hey jdraw, thanks for the response! I have been playing around with a similar INSERT INTO statement elsewhere in my database, and that works, so I've copied the same format and set the following variables to read fields from the form that I'm running the code from. These variables are HisID...

Hi guys, I'm trying to run an INSERT INTO statement via docmd.RunSQL, and I'm stumped - I keep getting the following syntax error: Syntax error (missing operator) in query expression '(((tblHistory.HistoryID) = 42848) AND ((LookUpAllocater.Publication) = AHCP) AND ((LookUpAllocater.Issue) =...

Hi CJ_London, So sorry for not replying to this sooner - been pulled away to a different project so this one has been on the back burner! In the end I had to create a list of additions/amendments/deletions as per your instructions, but update the records on the database manually...a lovely...

Hey CJ_London! Thanks for all this info, it's really useful - I've managed to cut down the 60 records to the 14 that actually have changes that are relevant to us (contact and site info)! I should have mentioned that I'm rocking 2007 though...will the above link still be relevant to me? Also...

Hey CJ_London, this works perfectly, but this query has returned 60 records that have changed in some way - do you know of some way of highlighting only the fields that have changed at all, please? Thanks in advance!

That's absolutely brilliant - thanks so much, I'll give these a try tomorrow and let you know! :)

Hey CJ_London, thanks again for the response! Well, for the most part we'll be able to match against individual membership numbers, but obviously sooner or later those will all change as the members renew. I'm not sure if there's a specific period when memberships run from/to (Jan-Dec, for...

Hello again CJ_London, and thanks for your reply! So the MD has replied, and apparently the main membership database is operated by our main competitor (which I didn't know) - anyway, long and awkward story short, the data files we receive are not going to be changing any time soon in terms of...