Recent content by ACTHelp

You guys are fast and very good. Let me explain this a little bit more. I am actually disabled and on full-time disability. I was an IT Project manager for a large corporation and have done some Microsoft Access programming in the past. Parkinson's disease robbed me of my career and my...

That's an interesting thought. The geographical area is rather small, so I could potentially create the zip code file myself. I'll look into it, thanks.

I have a database which contains within it the addresses of clients. I need to be able to calculate which clients are located west of a certain area. For instance I needed to calculate if they're located west of Washington Road? This particular city is not laid out in a good grid format where...

Sorry, accidently posted to the wrong forumm. This is an MSACCESS ?

I have a database which contains within it the addresses of clients. I need to be able to calculate which clients are located west of a certain area. For instance I needed to calculate if they're located west of Washington Road? This particular city is not laid out in a good grid format where...

Thanks to all for your responses. I used the union approach and it worked well. You've saved me a lot of time! Thanks, Cindy

Hi Ya'll, I have a table I'm importing that looks like this Customer Name Smith Brothers Product A Price of A Quantity of A Product B Price of B Quantity of B Product C Price of C Quantity of C and is a single row per customer. I'd like to convert this table into a real table like Customer...

Tony, Thank you so much that worked. However, you do say that this is rather poor design. What would be another approach to accomplish this? Thanks again for your help, Cindy

Follow this link to see whats happening http://pg.photos.yahoo.com/ph/cindyg1958/album?.dir=/4c67&.src=ph&.tok=phnD1YEBOhfmp8QC

I played with it some more this morning and discovered that if I remove my inserted page breaks and simply press enter forcing blank lines..the footers work perfectly. This is not how I'd like to do this thoughh.

2000

Hello All, I'm writing a user manual. I have three levels of headers...heading 1,heading 2 and heading 3. In the footer of my document I have {STYLEREF "Heading 1"}, and the same for headingss 2 and 3. With the idea being that you can flip through the bottom of the pages and view the...

Thanks so much...that worked great!

I'm trying to write a quick vb app to help replace server names in .ppx files. ppx files are Cognos PowerPlay files. The contain the server name that the .ppx is suppose to run against. We are a big PowerPlay shop. I'd like to write an access app which will allow them to identify the files...

Hey everyone, I have a table which was imported from another application. I need either a query or a report which will sequence the results by column heading. See example below (this is a simplified example...my actual data has 1800 fields...) So if my input is like this: City Address...