Search results for query: *

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

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

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

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

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

Is there a procedure I can use to open a hyperlinked webpage within a form instead of, say, IE or Netscape? If so, what ActiveX control do I use? I'm using Access 2002, btw. Gawd I love this Access stuff..too bad I don't know what I'm doing.

When saving a .xlt file to .xls, any code contained within the .xlt is saved in the .xls file as well. There are some things that I may not want the .xls file to do that the .xlt file does. Is there a way to code the .xlt so that it disables any code in the .xls? Clear as mud. Right? Thanks...

I hope this question hasn't been answered more than 27 times before (probably has..but gotta ask anyway) How should I code this? In C:\Files\ I have: book1.xls book2.xls book3.xls How do I have it save to book4.xls automatically using code? Thanks Randy Gawd I love this Access stuff..too...

Here's the deal...seems easy but can't figure this one out. These columns are selected: Columns("F:L").Select If I use an offset, such as: Columns("F:L").Offset(0, 1) the entire range is offset to "G:M" What I want to do is (by using an offset) is change this range to: Columns("F:M").Select...

In an Excel program I'm working on, the user can "archive" certain employee's data. The archiving process creates a worksheet named, such as, "John Smith_Archive". Getting a workbook's worksheet list is not a problem, but I can't figure out how to show ONLY the "Employee_Archive" sheets in a...

Hello again! Simple question: Using code such as stDocName = "DetailedSummary" DoCmd.SendObject acReport, stDocName, acFormatHTML, Form_OutstandingBalance.Email, , , "Service Statement" This particular report creates 2 pages but I only want to send the first page. How can I limit the...

Here's something I did but it needs some tweaking. Suggestions accepted gladly. 1st the problem: On a continuous form, when opened, I needed a way to show all accounts that were past due in red. Past due meaning >30 days and a balance greater than $0. I did not want to have to select a record...

This function in StartUp.mdb will compact and repair a defined database. Actually it does a great job too, btw. Anyway..here's my question: Since Access prefers to look at 'MyDocuments' all the time, some users place databases into different drives, directories, etc., I have a form which they...

Creating an Employee Review form in which supervisors enter comments. There are certain words that are not allowed to be used within the comments boxes. (discriminatory, racial, language..blah.blah) I can create the list in a table..no problem. Question is how can that box be tested for any...