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

    # days between 2 dates - excluding weekends

    Well thank you kindly! That was fast, and i knew the solution had to be posted somewhere :P I appreciate the effort; cheers!
  2. psykoProgrammer

    # days between 2 dates - excluding weekends

    All, I'm going to be a little bold and start thanking you ahead of time, because i'm certain someone out there knows how to do this fairly easily. :) I'm a VB programmer, and as such can do this in that language, but am a newbie when it comes to VFP9; hence the reason i could use a hand...
  3. psykoProgrammer

    Records Between Dates

    After you have changed your fields to Date fields you will (as far as i know) still have to make some changes to your SQL statement. I believe that the Date field will actually hold more detail than needed (in this case), and so you should place the date you are searching for between #...
  4. psykoProgrammer

    Office2000 Tasks Tab question

    Hi all, My "boss" has a Tasks section within Outlook 2000 that he shares with the rest of the office. He wants it to appear the same regardless as to who logs in, from whichever station connects to his Tasks folder. That's all fine, and he's been using it for awhile now. The trouble is, he...
  5. psykoProgrammer

    replace current access db reports/macros with vb interface

    Sorry, Sheco...i'm not sure i get what you mean :s I want to use VB6, don't get me wrong, but i don't readily see how to easily create the same reports that already exist. In access it appears you simply drag 'n drop the items you want in order to determine the layout, and then query the data...
  6. psykoProgrammer

    replace current access db reports/macros with vb interface

    Okay, another one for the gurus (you know who you are!). We currently have an access db with forms for user interaction, and built in macros. The users use this to generate reports (also embedded within the access db). The trouble is, the developer is now gone, and the db is a mess (spaghetti...
  7. psykoProgrammer

    VB creates Table in PowerPoint, but can't auto-format column size!

    Thanks for your time and effort Skip. I appreciate you even willing to give it a go ;) As it turns out, i still can't find any reference in any technical papers regarding PowerPoint on how to do this, but i'm no longer certain it really matters. You see, if every column were to contain these...
  8. psykoProgrammer

    VB creates Table in PowerPoint, but can't auto-format column size!

    hmmm, i'm afraid i don't fully understand how i would do that :( I have tried: oPPPress.Slides(lSlideCtr).Shapes(n).TextFrame.AutoSize = ppAutoSizeShapeToFitText And that obviously didn't work, and i've tried to make adjustments using: oPPPress.Slides(lSlideCtr).Shapes(n).Table.Cell(n,m)...
  9. psykoProgrammer

    VB creates Table in PowerPoint, but can't auto-format column size!

    I have a VB6 front end that transfers data back and forth from an Access db. Some of the functionality of the application is to provide users with reports. I can instantiate and populate data to both MS Word and PowerPoint, but on one such report i'm having trouble. This is where i need a...
  10. psykoProgrammer

    DTPicker, year scroll bars always visible...but how?

    Okay, probably an easy one for some of you, but i haven't yet figured out how to make the year scrollbar always visible. The trouble is, when a user clicks on the DTPicker, the Monthview is displayed, but they forget how to get the year to change (ie. click on year, the toggle shows up...
  11. psykoProgrammer

    DTPicker, can year scrollbars be visible?

    Okay, i think i've posted this in the wrong forum :( Sorry about that. I can't find how to delete a post once you've made it though, so this apology is the best i can offer. I'll now make a copy of this post, and place it in the Microsoft: Active X forum.
  12. psykoProgrammer

    DTPicker, can year scrollbars be visible?

    Okay, probably an easy one for some of you, but i haven't yet figured out how to make the year scrollbar always visible. The trouble is, when a user clicks on the DTPicker, the Monthview is displayed, but they forget how to get the year to change (ie. click on year, the toggle shows up...
  13. psykoProgrammer

    powerpoint presentation instantiated by VB6 unable to set hyperlinks

    Amazing! I just tried it, and within a few seconds it was all but done! This little program generates some fairly robust presentations by pulling data from the db, and populating grids, arrows, etc, etc, throughout a massive presentation (4 slides per project, 21 projects in db). The user...
  14. psykoProgrammer

    powerpoint presentation instantiated by VB6 unable to set hyperlinks

    Thanks for all of the help, Combo! The star was well deserved; i could not have moved on without the aid you have given me. I tried a few dozen web sites to no avail with this problem, and was unable to find any documentation to explain how to do this (hyperlinks to websites and other programs...
  15. psykoProgrammer

    powerpoint presentation instantiated by VB6 unable to set hyperlinks

    Ah, the 3 parameters you indicated were ever so nice. I hadn't found anything indicating all three before, and had tried something along the lines of .subaddress using just a single "Slide n" value to no avail. This may come in handy! Sorry about not placing this in the right forum; is there...
  16. psykoProgrammer

    powerpoint presentation instantiated by VB6 unable to set hyperlinks

    I have an Access db, and a custom VB6 user interface for interactions. The user wants to click a generate button, and have a powerpoint presentation automatically built based on details within the database. This works fine...and am quite pleased with the results! But, the user wants...

Part and Inventory Search

Back
Top