AAAAh, I got it. I looked in the help file and see that I have to click on the Indexes (lightning bolt) icon.
Now the problem is that that only solves a minor part of the equation. I've yet to figure out how to change a value in the query I just ran (add a new mailer ID to customers I just...
I just changed both mailer and customer fields in the JoinTable to "No Duplicates" and I'm not able to enter the same mailer id twice in the entire table, not just for one customer.
Maybe I misunderstood something lespaul and PHV have said.
I see what you mean, lespaul. Is it simply making the property change in the design view of the table Indexed (No Duplicates) to both the mailer and customer fields?
Thanks for the clarification.
Thanks for the reply, but I don't believe that would help. I don't want to prevent mailer or customer duplicates, I meant that I don't want to repeat the same information that was already there. For example, if my query showed that patient # 566 was sent mailer #999, when I try to append to the...
Hi all,
recently started using access queries and would like to know how to accomplish the following scenario:
I'm trying to build a mailing list DB (Using Access 2003 MDB, btw). Right now I have 3 tables:
- Mailer (holds information about mailer, date sent, media, etc.)
- CustomerList (info...
Hey everybody,
I've been researching how to send text messages and ringtones to cell phones. I've found out that one way is to use ASP which I can handle a bit. Thing is that it seems that you have to subscribe to a pretty costly service that will transmit your messages.
The only exception I've...
Hi all,
I'm trying to place a dashed stroke around an image. It was originally done in Photoshop. I opened it with Illustrator and tried to convert to objects and also flattening the image, but with neither option can I put a stroke around the image. I increase the stroke size, but nothing...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.