Search results for query: *

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

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

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

How do I make my sql table create an autonumber ID via a a field name called TableID. What should all the components/properties be? I am trying to append using Access interface, and cannot get a record to add at the end of the table....

I cannot get 3 tables to related. I just dts'd them from access where they seem to be fine in relationship. I cannot even get a diagram of the 3 tables...I get the following msg.....Can someone explain in very simple english...what should I look for....It doesnt seem right.... 'Contacts' table...

Does anyone know of a sql server enterprise manager compatible Query Analyzer that is free, and similar to the Seagate Query Analyzer that was apparently free at one time...Any help or suggesion on this greatly appreciated. Thank you

can someone explain a design issue here...any and all input would help...which argument is better for the following... We need a db that collects chain organizations (corporate chains that own a variety of store brand names), then a table to collect all the stores in the US. One point of view...

PLEASE HELP. I am trying to have each unique street address receive one cover letter bearing the 'Last Name' Family, to then be followed by the application forms bearing those with the same physical address, with each application form with the individuals information. So if there were 2 Smith...

Please help. I am trying to figure out why in the crazy world I am getting this. Please can someone tell me in simple terms if this is related to some file or table physical size limitation, or a change in the integer/field definitions of the text file I am trying to import. It had been working...

Any help...My grouping doesnt seem to be working right...and I get quarterly results, not monthly...HELP I have a table view below of which I would like to chart activations counts month to month and compare this year vs. last...How can I use the attached table to allow a user to refresh daily...

Mike: Question. How can I make a combo box open up automatically upon entering it to show me all the records in the list. That is, suppose I am tabbing from a command button (lets say Cmd41) to combo box (say Combo 102). I would like to immediately see the 10 items that may appear in the...

Mike: Question. How can I make a combo box open up automatically upon entering it to show me the current records in the list. That is, suppose I am tabbing from a command button (lets say Cmd41) to combo box (say Combo 102). I would like to immediately see the 10 items that may appear in...

I have a table called Contacts. People search by entering an ID, and if it finds it goes to a form. How can I insert an error message or "ID does not exist" message prompt for those instances where the ID is not in the table. Can someone send sample code...thank you