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...

Hi Alex, Thanks again for the help. Will be working with this code. We had some crisis here which kind of upended priorities for a bit .... thanks again!! S.C.

Hi AC, They have split the addresses, separating the number from the street names and are now fixing the street names to be consistent. They are doing this in ACCESS and are planning to give the list to me when it is done. Can you explain me a little more about your code suggestion? I'm...

Thanks, Alex. I think I'm going to try a totals query. If I group by the field that has duplicates I think it will work. Thank you for the code, that will help. :)

Yes Remou, that was me [blush] before I realized what the data looked like .... I am still waiting to get the mega excel sheet ... S.C.

So, everyone..... We are working on fixing the addresses so they are in a uniform format and will eliminate the name problem by using "library patron" in the name field for all postcards. Once I get the excel sheet, assuming all the addresses are done correctly, can you help me with the steps...

Thank you, Lesley and Alex. I'm encouraged to keep at it .... it will be a miracle if we can do this by the end of the week! ... S.C.

Hi Skip, Either 16,448 rows or 19,448. aarrgh, I don't even have them all, they have just given me a few rows to figure out what to do! S.C.

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...

THANK YOU!!!!!!!!!!!! :)

Hi, Understand..obviously can't get the actual date, but I'd be happy if I could just get a year, (plus or minus one year not a problem at this point) for them for the time being, then our development people could target age groups for sending out mailings that might just be of interest to...

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.

oops, Pink Star it is, then!

Thank you RS and here is a large Gold Star!!!!! Slight modification Right([fldFirstName],2 instead of 1 in order to get the initial along with the period and you've set me up beautifully....test table successful, now I'm off to apply it to the real thing. Have a great weekend and thanx...

Hi again, Moving right along, this was very good and thank you. Now I seem to have a problem b/c I need, i think, a WHERE statement so that this update only happens to the records which actually have the middle initials in the FirstName field. I used WHERE (((tbltestOct28.[First Name]) LIKE...

Hi RS, Thanks so much for the tip. I'm having a little trouble with this, as I don't do this often enough. When I put that expression in a field, I get a parameter query. I'm struggling to figure out. (or i'll be fixing 2500 records one by one, ouch)... thank you again. PS

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.