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

    Newby Needs Help W/ Insert Into Statement

    Sorry. I'm in uncharted territory here. Thanks anyway.
  2. ballbearing

    Newby Needs Help W/ Insert Into Statement

    I'm starting to get the hang of things, but SQL stuff is a bit frustrating. Anyway, I've been trying to get this to work but no luck. I've removed quotes, dots, $ signs and just about everything else. The statement is: INSERT INTO users VALUES (2, '.$_SERVER['REMOTE_ADDR'].', 'admin', 'admin'...
  3. ballbearing

    Right, Mid, Len..can't seem to get what I want.

    Sorry, Mintj, absolutely no disrespect intended there. It's just that a formula of that complexity is way beyond my comprehension. Obviously not your's. Thanks again.
  4. ballbearing

    Right, Mid, Len..can't seem to get what I want.

    DataF: Works well but I do have amounts exceeding 999. Had to check that first but there are. Thanks Fneily: I said it was probably a simple solution but =RIGHT(A1,LEN(A1)-FIND("*",SUBSTITUTE(A1," ","*",LEN(A1)-LEN(SUBSTITUTE(A1," ",""))))) Now WHY didn't I think of that one? I'm trying to...
  5. ballbearing

    Right, Mid, Len..can't seem to get what I want.

    223832 180/2 OZ COOKIE DOUGH ALL AMERICAN HOMESTYLE 52.84 221821 200/1.5 OZ COOKIE DOUGH CHOC CHIP LOW FAT 40.08 223956 2000/1.5 OZ COOKIE DOUGH CHOC CHIP W/M&M'S 143.56 236063 240/1 OZ COOKIE DOUGH CHOC CHIP HOMESTYLE 35.23 This is what I've got in Excel. (A1, A2, A3 and A4) I need to extract...
  6. ballbearing

    Date/Time stamp in FP

    I was thinking more along Java code for something to do that. Haven't done any VB for html pages unless, of course, Java was what you meant. I could always manually enter the time/date from the email itself, but was hoping it could be included with the form's results because it is imported into...
  7. ballbearing

    Date/Time stamp in FP

    We have on-line application form which the date and time are important. How do I have this date/time returned along with the application's results? With the B1 Submit button or perhaps some hidden field? We're using MS FrontPage 2002
  8. ballbearing

    Excel - Splitting Text Into 2 Columns

    Hmmm...good thought, Skip. I'll try it both ways and see what works best. Gotta tell you guys...get away from this stuff for a time and it's amazing how one forgets even the simplest things! Thanks to both Rybrookar and Skip!
  9. ballbearing

    Excel - Splitting Text Into 2 Columns

    I am certain this has been asked before but can't find the right words for searching. A B C Name:John LastName:Smith What formula would be needed to split everything left of the colon into column B and right of the colon into column C. I would like to end up with...
  10. ballbearing

    Can I have NO default email?

    I use 3 different email progs: Outlook, Outlook Express and another called "IncrediMail" (a lot like Express). It seems I have to set at least 1 of them as default. Is there a way I do not HAVE to have a default, because sometimes when replying or something, it starts one of the other email...
  11. ballbearing

    Command line to open OE maximized

    Thanks...I'll live with that! Gawd I love this Access stuff..too bad I don't know what I'm doing.
  12. ballbearing

    Command line to open OE maximized

    Anybody? Gawd I love this Access stuff..too bad I don't know what I'm doing.
  13. ballbearing

    Command line to open OE maximized

    I have a little prog that checks server for mail. When mail arrives I just click on the little tray icon and OE starts up but in a small window size. Is there a command line switch(i.e. blah/blah/Outlook Express\msimn.exe/maximize) I can use to start it up maximized? Gawd I love this Access...
  14. ballbearing

    Cat5 and Moister

    Hmmm...was afraid someone was going to say that. Thanks for the reply. Btw..."moister"? Gawd..I've been hangin' around the internet too long.
  15. ballbearing

    Cat5 and Moister

    Been having trouble with irratic download speeds and data transmissions stopping with wireless setup. Can't give ya too many specifics other than I have an outdoor antenna with an airbridge. (Hope that's enough). Anyway, while trouble shooting this headache, I replaced both rj-45 connectors on...
  16. ballbearing

    NTFS or FAT32 for pagefile drive.

    Thanks for the tip, Jason. I have 512mb (dinosaur by today standards) but I figure if I keep messing with it, it'll only go downhill from here. (experience talking, here). You're right, linney ..that IS a good article. Thanks all. Gawd I love this Access stuff..too bad I don't know what I'm doing.
  17. ballbearing

    NTFS or FAT32 for pagefile drive.

    I do have a RAID but no slots for it now. (Suppose I could remove the SantaCruz sound card and use the ESS built-in sound card.) Do you suppose it would be worth my efforts to use the RAID card? Gawd I love this Access stuff..too bad I don't know what I'm doing.
  18. ballbearing

    NTFS or FAT32 for pagefile drive.

    Have to admit..hadn't thought about that. Actually the second drive is partitioned into 2 drives...8 or so gigs of backup stuff and left 1 gig for pagefile only. I'm sure you can see, judging from the capacity, it is not a new drive. Maybe I'll just reclaim it and put more "stuff" on it. (c...
  19. ballbearing

    NTFS or FAT32 for pagefile drive.

    I have 2 HDs - 1 with XP using NTFS system. Does it matter if the other drive uses NTFS or FAT32 for it's pagefile? BTW..I've just re-installed XP using NTFS for the first time. I've noticed that unless I let Windows manage the pagefile on the second drive, and specify NO pagefile for drive C...
  20. ballbearing

    Possible to open a webpage within a form..not IE

    Oh..sweet! Thanks loads. I really do appreciate it. Gawd I love this Access stuff..too bad I don't know what I'm doing.

Part and Inventory Search

Back
Top