Search results for query: *

We have a phd dissertation with tables on landscape oriented pages. The page numbers on each of these landscape pages need to have the number in portraait style so that when the paper is printed and the page is rotated the page number appear on the bottom. Which, I believe, means we have to...

Hello again .... We have a problem.... and since I am most familiar with access in our organization (have not TOUCHED Access in over 2 years)I get to work on it. By the end of the week our organization would like to have a mailing list ready. The data is in EXCEL. The name column has names...

Hi all, I'm sure I asked this question years ago but it's been a long time since I've had to work with Access and now we have a large mailing list. Problem: There may be many family members with the same last name (obviously different first names) at the same address and we would like to...

I work in a public library district and am on the committee to help develop a new website. My work at the library involves acquisitions so I am not really a techie, more a techie-wannabe. Our committe is researching how to go about advertising a position as webmaster if the district decides...

Hello all... I have made some changes to the table and form of a little database. The fields are all in the table propeties list in design view and they all appear on the form. However, when I click view, tab order, there is a new field missing and one or two which I thought I had eliminated...

Does anyone know how to do this? I have a list of over 2,000 children, their ages, and the date these were obtained. Is there a way to come up with a date-of-birth globally, instead of having to calculate each one individually? Thank you.

Hi all... Has anyone imported a list where middle initials were in the same field with first name? Is there a relatively easy way to pull them out and put them into my middle initial field without having to fix them individually? Thank you.

Hi, Does anyone know if ACCESS is capable of using address barcodes? It would save some money with the post office if we could include these with our addresses. At this time, I save the list as a textfile from a query to a disc in ascii format, delimited with commas and give it to the...

I changed the orders of columnns in a table in order to perform a sort by last name, then first. How can I fix it so that the records will reflect the new sort in the form we use to enter the data? It took the last name sort, but not the first name. Thank you.

I have merged a few excel sheets into my access table, which is a flat list of names with a variety of characteristics. Since then, it was decided that this new list would only be used annually and that new names would only be added to the original, smaller list for our normal mailings. So, I...

Hi all! As usual, advice needed at the 11th hour...usually I produce mailing label reports for a newsletter where there are multiple individuals at some street addresses. I have it set up to just print the last name and the address so that only one gets to each household, using "show...

As far as I know, there is no limit to the amount of records you can put into an Access db for it to work effectively. Can anyone confirm this? I have someone who is worried that the little db I designed for her will not work if she enters over 12,000 records. Thank you! Peg

Has anyone ever heard of a database product called "QUEST" We had been using a product, ReportBuilder by Centura, which was a kind of add-on to a database product which we bought from a book vendor. Having had mega problems with ReportBuilder, the vendor is now suggesting that they...

Anyone have any ideas? Local History dept of a library has 2 huge files of handwritten index cards, done in the '30s. One file is "deaths", one of "marriages" going back to early 19th century, at least. Each card describes "event" ie death or marriage as reported...

I have 2 seperate access databases. One much larger than the other. They each contain records of people with assorted info, but I'm interested in creating a huge mailing list incorporating names and addresses from both. Is this possible? Please, if anyone can help me do this I'd be grateful...

I have an ACCESS db which i'm using for a mailing list. We have several members of a family at the same address and would like to do a query to pull records so only one member of such families appears. I can do a query with distinct addresses but cannot figure out how to have the rest of the...

I have a database of about 1700 records, mainly children, with addresses, phone no. and other info. Often there are several siblings in a family. Quaterly we send a newsletter and would like to send only one newsletter per family. I would like to produce the mailing label report and pull only...

I am trying to avoid sending duplicate newsletters to families on our mailing list. Our list consists of over 1600 children, several of whom are siblings. I would like to know how to pull records for mailing label report so that only one record per family appears on mailing labels. Have been...