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'...
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.
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...
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...
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...
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
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!
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...
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...
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...
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...
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.
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.
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.