Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ACTHelp

    Calculating direction

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

    Calculating direction

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

    Calculating direction

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

    Ideas on calculating direction

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

    Ideas on calculating direction

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

    This is probably easy..but I can't figure it out!

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

    This is probably easy..but I can't figure it out!

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

    STYLEREF in Footers

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

    STYLEREF in Footers

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

    STYLEREF in Footers

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

    STYLEREF in Footers

    2000
  12. ACTHelp

    STYLEREF in Footers

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

    Help. Double quotes in text data

    Thanks so much...that worked great!
  14. ACTHelp

    Help. Double quotes in text data

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

    Need to sort column headings in query or report

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

    File Sharing Lock exceeded - when saving vb code

    I managed to resolve this myself. Part of this application opened Excel spreadsheets and PPX files from PowerPlay. These resources were not being released. When the release of these resources was added, the problem was resolved.
  17. ACTHelp

    File Sharing Lock exceeded - when saving vb code

    Unfortunately, that doesn't seem to be it either, I've checked the running processes and msaccess is not there nor do I see any references to anything that looks like vb. Still stumped.. By the way, we are running Windows 2000, Access 2000 (9.06926 sp3) and VB 6.3
  18. ACTHelp

    File Sharing Lock exceeded - when saving vb code

    I've seen the file sharing lock exceeded error on this board many times for when the Access application is running, but I am experiencing this problem when trying to save a vb module... What would cause this problem?
  19. ACTHelp

    Forms and visibility

    Thanks so much Ginger...MODAL was set to No, but Popup was set to yes. Changed Popup to no and it now works great! Thanks Again
  20. ACTHelp

    Forms and visibility

    I have an application that runs on a pc and loads data. This application runs for quite awhile so I've developed a few screens to let the users know where in the load process the program is. So.. first I have a main status form which has the high level steps the application goes through: Step...

Part and Inventory Search

Back
Top