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!

Register Log in
  • Congratulations derfloh 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. gymbeef

    Foxpro vs Access

    A friend asked me if I could do some work for him in Foxpro, but I am totally unfamiliar with that program. For someone familiar with Access\VBA, would it be relatively easy to pickup? Also, what's special about it - why would you pick Foxpro to do an app in versus something else? Thanks in...
  2. gymbeef

    manipulating cell references

    Total excel novice here again.... What I want to do is (for example), if an entered value or a formula resulting in "1". then the result would be displayed in cell A1. If the answer is "17", then it would display in cell A17, etc. In other words I want the value or result...
  3. gymbeef

    Summing alternate cells?

    Total excel novice here, so apologize if a simple question, but... I'm trying to write a spreadsheet that would display accumulated values based on a user-entered frequency. Is there a way to change the SUM function to skip values, or is there another function that would do what I need? By...
  4. gymbeef

    wininet "entry point" error?

    A search turned up some simple functions for testing the status of an internet connection, but I'm getting an error. Not sure if the info was obsolete, if I'm misunderstanding how they work, or if its just a simple syntax mistake. The error message that pops up says: "Can't find DLL entry...
  5. gymbeef

    default email app

    Got the default email app (which happens to be Outlook on this machine) to come up and preload the fields OK. But the FIRST thing it does, before Outlook loads, is a pop-up from Windows itself (I assume) asking to select a "profile". I assume this is an XP thing. Is there a way to...
  6. gymbeef

    default email app

    In case I can't get my email routine to work, here's my contingency: just call up the default email program and fill in the blanks. I've done some searches and found a lot of routines that call Outlook, but they specificaly call "Outlook". How do I do call up whatever windows has as...
  7. gymbeef

    SMTP server question

    Not real familiar with the technicalities of the internet here. Unfortunately, I'm working on an app that performs email right out of Access. The app requires specifying the SMTP server you're connecting to, and I have a pretty good conceptual idea of what that's all about, but I'm having a...
  8. gymbeef

    AOL IM interfacing

    I'm not satisfied with the various response-bots I've seen, so I've decided to make my own. I'm relatively well versed in Access and VBA, but this app involves something I've never really done before, namely interacting with another program. Most all my previous aps have been pretty much...
  9. gymbeef

    Long processing weirdness

    I have an application that sometimes has some pretty heavy processing going on that might take up to several minutes to complete. And some odd things are going on that I'm hoping someone can explain. The routine itself is pretty simple - its just searching a matrix for a particular value and...
  10. gymbeef

    Access vs VB

    Not sure which forum to put this under but... I have an application I've been working on for some time, which I plan to distribute as a stand-alone executable. It doesn't really involve a lot of data, in fact, its not really a database application, but I started doing it in Access because...
  11. gymbeef

    out of memory, but not out of memory??

    Oops! That was just a typo. My control was originally numbered Text113, I changed it to TextBox2 for the example to make it more clear, and wasn't paying close enough attention.
  12. gymbeef

    Scrolling large text box navigation simulation

    well, it kinda works, using SelStart to position the cursor. But the problem is that SelStart positions by character count, but its not a "solid" textbox. What I mean is that if it was "shoulder-to-shoulder" with characters throughout, then you could step through it based...
  13. gymbeef

    out of memory, but not out of memory??

    Thanks for the suggestions guys, but upon closer examination my problem seems to be something very specific. It seems related to the clipboard and not "memory" in general. Here's whats happening: I have TextBox1 that gets filled with a string value, and that string is also copied...
  14. gymbeef

    concatenation operator

    When doing string concatenation, is there any practical difference between using + versus & ? Anytime one should prefer one over the other, or not use one or the other? thanks
  15. gymbeef

    out of memory, but not out of memory??

    Not sure what I did or what's changed, but a previously OK app is now giving me headaches: During the course of running an app under Access (running within Access, not as a standalone), I get an Access Error message that says I'm out of memory, and to close some open programs and try again. My...
  16. gymbeef

    Closing recordset operations question

    I've been going through my application doing some housekeeping to make it run faster and better, and I had a question regarding a recordset operation. I know enough to use them, but not enough to know if I'm doing it the best way, or sometimes even the right way! I want to make sure I close...
  17. gymbeef

    Database cleanup by import loses something

    Thanks Star, but your answer reveals a new wrinkle: The list of references is not the same!! I'm opening the databases with the same program on the same machine, but when I look at the references list for each database, there are some in the first that are not in the other, and vice versa...
  18. gymbeef

    Scrolling large text box navigation simulation

    I have a large unbound text box on a form that is essentially used as a text editor. If I click on the box, I can then "scroll" up and down using the keyboard's arrow keys to see text that falls "off the page". The textbox must be enabled however for that to work, and the...
  19. gymbeef

    Database cleanup by import loses something

    A tip posted on one of the forums about cleaning up and reducing the size of your database file, suggested creating a new (blank) database, and importing all the objects from the application being developed. The import worked fine without errors and the new file is a third the size of the old...
  20. gymbeef

    How to print directory listing?

    This isn't an Access or VBA question, but this is the only forum I read or post to, plus I'm not sure where I'd ask this otherwise. Simple problem, but it has me a little stumped and surprised I haven't run across it before: I saved a bunch of demos, shareware, and freebies which I collected...

Part and Inventory Search

Back
Top