Recent content by ski2sun

can anyone help on a simple design/dreamweaver mx search page that looks for a store by store name....using any part of word, beginning of word, end of word...minimum of 3 characters....lastname or storename would field to query...link in this thread does not show sample....thank you

thanks so much all for your notes..will check all your suggestions....

they are all date/time, year 2000 forward...can you make a suggestion...thank you

I have a SQL datetime format(8) column that I am trying to import data to, from access, with date/time property, medium time. Why wont it go into the new Sql table. i tried text also....msg given was... error at destination for row number 1. Errors encountered so far in this task: 1. Insert...

how would this work if I just do insert/update...can you provide me with proper syntax...in its simplest form.... thanks. I can work the delete later...thanks...

I am trying to do a simple trigger to show the update, insert, delete history in the table 'wplog'. Why am i getting syntax error on such small stateement, its literally from msdn site...please help...please provide simple answer...newbie with this Ent Mgr thanks CREATE TRIGGER [histlog] ON...

my ODBC links are now saying myname_tablename1, myname_tablename2, when linking with access. How do I make them dbo_tablename...If I didnt create the actual sql server db, how do I look in Enterprise manager, and change so I can be dbo, so links say dbo_tablename1, dbo_tablename2. Is this...

i do not have sql bol this weekend, but can someone provide idea on how to do a trigger to show that a field/column changes within a record....lets say in example. Obviously my getdate() only works for new entries, but would like to know when any of my column changes in table..see below the...

I am using getdate() default to get timedatestamp of when record is created....does this also change when record is changed?....what would be a better default to use to produce a new timedatestamp anytime a component of the record is changed...the record has only 4 columns/fields...lets say...

I have the getdate() for the 'userdatetime' field default to be filled in when record is created, however, how do I get the userID's field to appear with the name of the person entering the record.....how is default set for userID, or how does it automatically record the user...I set up the user...

if this is now working as an htm, and I have the .asp in the folder I uploaded to, where does the guestbook.mdb now need to reside for this to collect the info submitted on the guest.htm page. Do i upload guestbook.mdb (it didnt work)....please help..what is missing component..an...

thanks to everyone on my thread....however, we are still jumping head too much...I still dont know what IIS is...?i checked to see if I had the MDAC...this was ok...I have PWS but when loaded it messed up my outlook, needing msoe.dll missing....I use attbi....can someone please list if I can do...

by the way this is the address of the tutorial I was trying... http://hotwired.lycos.com/webmonkey/99/13/index2a.html

First...when I create a form where I expect combo boxes, they seem to disapper when I create data access pages via the wizard.... 2nd...I followed the car db tuturial at about.com..I followed slowly, oh so slowly, this tutorial...I uploaded all the files provided in tutorial...and between Lesson...

does someone have a simple access db and pages that show how access can make web pages for a database scenario...like combo boxes - select state, go to next page/form, then city, go to facility listed...et al....I have tried using a tutorial about .asp, codes with ODBC connect, and try to make...