Search results

Exporting an email list Hello and sorry for the late reply, If you've got it figured out then great! But I thought I'd show you what I use to export an email list: DoCmd.TransferText acExportDelim, , "QryEmailList", "C:\Database\emailList.csv", False with "QryEmailList" as my query to generate...

Hello, Well what you're trying to do sounds like a pretty tall order; going from a mail merge into a document, merged into an email. Question, do you have to merge personally identifiable info into the newsletter itself, ie name or organization info of the recipient? If not, you could create...

Hello, Well I am definitely not the authority on this... but since you haven't heard from anybody else I figured you'd appreciate any response on the matter. :) Basically, what I have learned about calculated fields, is that you should never store them in an actual table. You are on the right...

Hi, I have experienced the same thing you are talking about. While the front end does not show the relationship info, it is actually there. The only thing is that the front end doesn't bring over the layout that you set up in the back end. To view the relationships in the front end: open up...

Hello, In designing my db, I organized my relationships window just right to allow a good understandable view. When opened up with the front end, the relationships remain of course, but the layout of the relationships window definitely did not remain. All the tables were just piled up and...

Thanks for the concern of my crappy design Neil. :) However that was just an imaginary example... I was only thinking about the functionality of the primary key, and not the chosen fields for the primary key. Still, it's good to know people are looking out for one another! :) Thanks again, Dana

Well alrighty then.. I'll take your word for it but now I am DEFINITELY going to look back and see what the situation was with my old database. Thanks again! :) Dana

Thanks for the reply Roy. It is possible that what I thought was a composite primary key was just a compound index. It has been awhile since I worked with that database.... I'll have to dig it up and check for sure. It was done in Access 97 so I still think it's possible for that version to...

Hello, I have a basic question about choosing the primary key for a table. Now I am not really concerned on the particular field(s) chosen to be the primary key, but rather the potential states, if you will, that the key can be in. Say I choose a multiple field primary key for a contact table...

Thank you The_Doc_Man Doc Man, I would like to personally thank you for your input on my database design problem. This is by far the most complex database I have ever attempted to develop and I am under pressure for this project to succeed, in fact it MUST succeed, which is unfortunatley...

Followup thoughts... Thanks to llkhoutx and The Doc Man for posting their thoughts on my situation... llkhoutx, I think we're thinking on the same lines but just in slightly different contexts... the only trouble with one way communication such as this. However, I still value your opinions as...

My database structure needs further review! Actually it was determined that it is *possible* that an Individual could be related to more than one Organization. That is why I felt the need for the linking table for the possible many-to-many relationship. PLUS, I was advised by another member...

Database structure (many/many to many issue??) Hello, I am looking for someone's professional opinion to help me clear up some unresolved technical issues in my mind... =P Ok, I have a contact management database that would seem really straightforward to me except for the fact that I am dealing...

Thanks again! Roy, Wow, thanks for the insight with indexes... that really clears things up for me! Best regards, Dana S.

Thanks for the info! Hello and thanks for the info. :) I was wondering what determined that and now I know so thank you much! I understand the concept of indexes but haven't utilized them to their fullest extent most likely. It seems like Access automatically sets fields of the 'number' data...

Hello, I have a pretty basic question about creating relationships in Access. When in the relationship window that shows all tables and associated relationships, I am a bit confused as to whether you are to drag the parent field to the child field or vice versa. When trying both, it appears to...

Check out this mail merge example Hello, I found this MailMerge example VERY useful and it may do just what your are looking for. Check out the attached zip file to this message. It has a form that pops up allowing you to create a new mailmerge template, edit a current one, or use a currently...

<> usage... Wait... is <> used for 'not equal to' ??? I just saw an if else statement that appeared that way. Thanks in advance, Dana

Quick DLookup question and "=" vs "<>"?? Hello, I am rather new working with DLookup. I don't seem to be having any problems really with it yet, but I am only checking to see if a particular value is null or not. Will DLookup return an actual value is desired? If so would it be the...

Dlookup issue Ok, I'm trying to check for a duplicate value with the Dlookup and I'm getting an error: Compile Error: Sub or Function not defined. Here's my syntax: If(Not IsNull(DLook("[OrganizationName]", "Organization", "[OrganizationName] = '" & newdataRS!Organization & "'"))) Ok, the...