Goto Page: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15 ... 73
Actual Results
- Carnix
- Forum: Microsoft Windows Forum
- Topic: MS Access as Front, SQL Server as backend
- Subject: MS Access as Front, SQL Server as backend
- Replies: 4
- Views: 1666
Posted: July 5th, 2007, 7:24 am
Ok, so other than building out the proper Stored Procedures and Views (which is actually pretty easy in the Access Project -- easier than writing them in raw SQL in Enterprise Manager anyway), this project is pretty much done. There was a little bug (or so it seems to me). Access doesn't allow perio...
- Carnix
- Forum: Microsoft Windows Forum
- Topic: MS Access as Front, SQL Server as backend
- Subject: MS Access as Front, SQL Server as backend
- Replies: 4
- Views: 1666
Posted: June 25th, 2007, 1:47 pm
Turns out there is a native solution in Access 2003 (the version we have here standard). I dropped in the hundred or so thousand records I needed to store into the Access database I've been working on, then I used the built-in Upsize Wizard to create a SQL Server Database and re-create the Access th...
- Carnix
- Forum: Microsoft Windows Forum
- Topic: MS Access as Front, SQL Server as backend
- Subject: MS Access as Front, SQL Server as backend
- Replies: 4
- Views: 1666
Posted: June 22nd, 2007, 7:04 am
ATNO, thanks for the info, that was really helpful. I'm literate in databases, but I'm no DBA to be sure. Actually, I'd already done the import, and created the ODBC DSN already (I have a Perl DBI script that does some work between the Access DB and our online processing system -- our operations cre...
- Carnix
- Forum: Microsoft Windows Forum
- Topic: MS Access as Front, SQL Server as backend
- Subject: MS Access as Front, SQL Server as backend
- Replies: 4
- Views: 1666
Posted: June 22nd, 2007, 6:01 am
I'm working on a a back office application for my organization to handle transactions processed online so they can get the data to our offline donor system. the two system cannot talk directly (the offline system, basically, sucks that way -- the online system as very robust web services though...)....
- Carnix
- Forum: Programming / Scripting / Coding Forum
- Topic: JS Menu script needs right-click tweeking.
- Subject: JS Menu script needs right-click tweeking.
- Replies: 15
- Views: 1530
Posted: April 18th, 2007, 4:06 am
I know the feeling. You know what they say though, desperation drive innovation. Or something like that.
- Carnix
- Forum: Programming / Scripting / Coding Forum
- Topic: Page Sorting
- Subject: Page Sorting
- Replies: 8
- Views: 540
- Subject: Page Sorting
Posted: April 9th, 2007, 12:37 pm
ORDER BY is the bit of SQL that causes the rows returned to be ordered in some way, sort of like when you sort by a column in Excel... it works like this: SELECT * FROM MemberTable WHERE lastname = "Smith" ORDER BY firstname DESC So, in English, this means, pull the all data columns for ev...
- Carnix
- Forum: Programming / Scripting / Coding Forum
- Topic: PHP or ASP
- Subject: PHP or ASP
- Replies: 13
- Views: 836
- Subject: PHP or ASP
Posted: April 5th, 2007, 4:00 am
Or, you can use PHP.NET 8) The above observation about ASP is an important one. If you don't already do ASP programming, don't bother starting now. If you're going with an MS platform, definitely use ASP.NET instead. There are plenty of very well developed AJAX.NET tools you can use that are built r...
- Carnix
- Forum: Programming / Scripting / Coding Forum
- Topic: JS Menu script needs right-click tweeking.
- Subject: JS Menu script needs right-click tweeking.
- Replies: 15
- Views: 1530
Posted: April 3rd, 2007, 5:57 am
- Carnix
- Forum: General Discussion
- Topic: MY FIRST POST PLEASE VIEW IM NOT WASTING YOUR TIME
- Subject: MY FIRST POST PLEASE VIEW IM NOT WASTING YOUR TIME
- Replies: 3
- Views: 433
Posted: April 3rd, 2007, 4:11 am
Why are you trying to watch live TV at work anyway? Do you *need* live TV at work, if so... why not just get a television? We have several around here with cable... At any rate, streaming live video to your office machine constantly will likely be noticed by your IT department because of the bandwid...
- Carnix
- Forum: Programming / Scripting / Coding Forum
- Topic: Downloading files
- Subject: Downloading files
- Replies: 13
- Views: 731
- Subject: Downloading files
Posted: March 28th, 2007, 5:21 am
The problem is that browsers already know how to handle image and text files on their own, and the default action is to display them in the browser window rather than prompt users to download them. There really isn't a good way around that other than to make it clear people should right click and sa...
- Carnix
- Forum: Programming / Scripting / Coding Forum
- Topic: MS Access Database ImageFrames
- Subject: MS Access Database ImageFrames
- Replies: 2
- Views: 412
- Subject: MS Access Database ImageFrames
Posted: March 28th, 2007, 5:13 am
Look here:
http://www.ammara.com/articles/access-jpg.html
And perhaps more specifically:
http://www.ammara.com/articles/accesspictureole.html
.c
http://www.ammara.com/articles/access-jpg.html
And perhaps more specifically:
http://www.ammara.com/articles/accesspictureole.html
.c
- Carnix
- Forum: Programming / Scripting / Coding Forum
- Topic: Website with different languages and MySQL?
- Subject: Website with different languages and MySQL?
- Replies: 3
- Views: 337
Posted: March 28th, 2007, 5:08 am
As of 4.1, MySQL supports UNICODE character encoding. English characters are 1-byte, Japanese (and other Asian languages) are 2-byte characters (3 in UTF-8), so there are datatype and collations implications. Instead of walking you though this, I'll just give you the article I've referenced in the p...
- Carnix
- Forum: Programming / Scripting / Coding Forum
- Topic: BATCH FILES
- Subject: BATCH FILES
- Replies: 1
- Views: 340
- Subject: BATCH FILES
Posted: March 28th, 2007, 4:58 am
Take a look here:
http://www.ericphelps.com/batch/
Here's another reference that might help:
http://www.allenware.com/icsw/icsw030.htm
.c
http://www.ericphelps.com/batch/
Here's another reference that might help:
http://www.allenware.com/icsw/icsw030.htm
.c
- Carnix
- Forum: Programming / Scripting / Coding Forum
- Topic: AJAX populate drop down menu
- Subject: AJAX populate drop down menu
- Replies: 3
- Views: 2458
- Subject: AJAX populate drop down menu
Posted: March 28th, 2007, 4:53 am
By the way, in case you haven't see it, this is a really useful JavaScript that makes AJAX, and a number of other things, very easy, or at least, much faster: http://www.prototypejs.org/ And here is a good site that documents it: http://www.sergiopereira.com/articles/prototyp...
- Carnix
- Forum: Programming / Scripting / Coding Forum
- Topic: JS Menu script needs right-click tweeking.
- Subject: JS Menu script needs right-click tweeking.
- Replies: 15
- Views: 1530
Posted: March 28th, 2007, 4:41 am
Well, there you go. That's the function that's causing your issue. Your script doesn't differentiate between mouse buttons (that is, the mousedown event isn't isolated to the left button). When any mouse button is pressed, it runs that function, and while there might be different forks for different...

