Search results for query: *

Thanks guys for the comments. The problem has been tracked down to a bad query that I was using as the basis of my form. Unsure as to why the problem manifested itself in the way it did, but my initial problem is now fixed. Thanks and regards, Neil

I've tried a couple of ways: Creating a Switchboard button, using "Open Form in Add Mode". and DoCmd.OpenForm "DataEntry_Form", acNormal, , , acFormAdd Same result both ways.

Thanks Ace....but as stated in original message, my Data Entry property is set to "yes" as it should be, yet I still see data populated when the form is opened....

Hi, I'm trying to open a blank data-entry form, but for some reason, when I open my form, there is already old data populated in all the fields. Data entry is set to "yes" in the property sheet. Any ideas? Cheers Neil

Gurus, I've got a table called "Jobs" containing an autonumber PK, called JobID which increments for every new row. I would like to create a new unique field called JobNumber, which is derived from the JobID column as follows: JobID JobNumber 1 APA00001 2 APA00002 3...

Thanks Ken. Much obliged.

Sorry if this is a dumb question, but I cant find the answer anywhere on the net! Just wanting to know what the letters "m" and "b" refer to when used in tape device names eg. /dev/rmt/0bn, 0mn etc? Thanks, Neil

Hi, I have a file with the following format: 00003#00003: 00030 00000000091 00020297330 00642393230 00004#00004: 00030 00000000092 00020297960 00642394310 00005#00005: 00030 00000000093 00020298600 00642395380...

Gurus, I am transferring a number of tables from my local SQL7.0 database to a remote SQL7.0 database using the DTS "Transfer SQL Server Objects" task. When I run the package, there is one specific table that gets created on the remote server but none of the data gets transferred...yet the...

Try: AND OrderDate < (SELECT DATEADD(day, -60, GETDATE())) GETDATE() is the system function that returns current date. Use DATEADD for the date arithmetic....second, minute, hour, day, week, month, year etc are all valid for the 1st parameter. hth, Neil

Hi, I've got an instance of SQL Server 7 where I'm using a DTS package to import some excel data into a table in my database. The Excel sheet is a simple 3-column table with the data beginning in row1. However, instead of importing row1 as data, DTS is trying to force the values in row1 to be...

This is giving me a migraine! I want to update the TDChartFileName column in the following table... select * from tDPR_WellData WellID TDChartFileName ------ ----------------------- 1 Abaji Okolo 1 268A 2 Ebughu East - 4H 9736 3 Oron West - 1ST1 9795 4 Tiguentourine-325z...

...Depth2 decimal(8,2) . . Name85 varchar(30), Day85 decimal(8,2), Depth85 decimal(8,2) If I try and run: INSERT INTO dest_table SELECT * FROM source_table I get: Server: Msg 213, Level 16, State 4, Line 1 Insert Error: Column name or number of supplied values does not match table...

I've got a quirky little problem where it would be very helpful to refer to columns based on their ordinal position. ie. to retrieve the 2nd column do something similar to: SELECT 2 from <tablename> ...??? I've seen there's an ORDINAL_POSITION column in the INFORMATION_SCHEMA.COLUMNS view. Is...

That nailed it....thanks a million.

Thanks, but afraid that doesnt work. Apparently you can't add an identity column using SELECT INTO. Any more suggestions anybody? Cheers Neil

Oops! Bold line should read: SELECT @opname = OperatorNames FROM ContList WHERE ID = (@counter + 1) Error still occurs as originally described.

...AS DECLARE @cmd varchar(100) SELECT @cmd = 'copy "' + @xlsfile + '" "J:\Data\Neil\test.xls"' EXEC master..xp_cmdshell @cmd IF EXISTS (SELECT * FROM sysobjects WHERE name = 'ContList') DROP TABLE ContList SELECT OperatorNames AS OperatorNames INTO ContList FROM...

That will do nicely... Thanks a lot.

Gurus, Could be a rather dumb question, but here goes anyway.... I've set up a simple DTS package in SQL Server 7.0 that I will be using to transfer a large number of Excel spreadsheets with an identical structure into a table in my database. I would prefer not to have to go into the DTS GUI...