Recent content by Abiart

Aha - I think I have solved the problem. Just because the ID field is the PK, doesn't mean it should be the bound field. I changed the bound field to "2" and it all fell into place!

Hi there, I have been doing this long enough to know that lots of people see using a combo box on a table as bad, and having it on the form instead is preferable. On my current project I have the opportunity to take heed of this advice at the beginning, but I think I'm a litte confused as to...

Thanks for your suggestions. I'm going to have a go at the structure table method. Unfortunately I can't simplify it to the point of saving SQL statements, as the mailing database that holds the list of email addresses etc is held externally, and we can only access it via a web client :( .

I took the plunge, hid the table (right-click, Hide), then re-showed it (right-click, Show Table....) and it reappeared more sensibly positioned and MOST IMPORTANTLY: the relationships remained! At least they [the Access programmers at Microsoft] got that bit right!

Hi Everyone, I need an intelligent way to store complex location criteria for e-marketing campaigns, which will allow consistent and useful reporting of which messages were sent where. I’m designing a DB to record and report statistics for e-marketing campaigns. It does not contain mailing...

Hi guys, Somehow one of the tables displayed in my Relationships window has crept above the top edge of the window, and I can't pull it back down as I can't get to the title bar. It's really annoying as I can't see the fields at the top of the list! I've been looking for some sort of "tidy...

I regret to say that I've tried both of those things and it's made no difference whatsoever. Setting the EditMessage property to "True" doesn't result in the New Message being opened for editing. I believe that the message is put together by the Assemble Message function, so the failure of the...

The syntax: rst!EmailAddressField doesn't work for me: in debugging mode if I hover over EmailAddressField using this syntax, the bubble text says: rst!EmailAddressField = <not found in this collection>. Whereas if I use rst(EmailAddressField), the bubble text says: rst(EmailAddressField) =...

Thanks for the tip, Gemma. That error (and subsequent similar issues) has been resolved. I'm now getting a different error, with the same field. The code runs ok up to the SendObject command. Then code fails and a line is written to the logfile which says there is a missing or empty field, and...

Hi guys, I've made leaps and bounds with my current little project today, but there's a frustrating error which is keeping me from testing my procedure. I have a form which contains 2 controls: a button "btnMailIt", and a subform, "qryMessagesMerge subform". MsgBodyText is a text field in the...

Thanks guys for all your advice and suggestions - I hadn't come across name colon syntax before as Gemma mentioned, but now I've used/edited it and it seems quite handy!

Hi everyone, This is a small part of a bigger problem, but it's one step at a time so here goes: DoCmd.SendObject outputformat:=acFormatTXT, _ To:=rst(EmailAddressField), _ subject:=Me.Controls(MsgSubjectField), _...

Hi everyone, This is a small part of a bigger problem, but it's one step at a time so here goes: DoCmd.SendObject outputformat:=acFormatTXT, _ To:=rst(EmailAddressField), _ subject:=Me.Controls(MsgSubjectField), _...

Thanks, Pat, for your helpful response. Regarding linking a table in a .mdb to Exchange: I'd like to be able to specify which fields are created in the linked table. It doesn't look like this is possible as I'm not given an option to set this by the Get External Data wizard. It has just...

Hi all, First of all I hope this question is relevant to this part of the forum, I thought this was the best place to put it, but my ignorance of the subject may mean it ends up being more closely related to one of the other areas. I'm struggling with some statistical reporting on Email...