Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: nwm76
  • Order by date
  1. nwm76

    Unable to open blank data entry form

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

    Unable to open blank data entry form

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

    Unable to open blank data entry form

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

    Unable to open blank data entry form

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

    Unique string based on autonumber field

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

    Tape device names

    Thanks Ken. Much obliged.
  7. nwm76

    Tape device names

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

    removing leading zeros from columns

    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...
    • nwm76
    • Thread
    • Replies: 1
    • Forum: AWK
  9. nwm76

    Problem transferring table data using DTS

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

    SYSDATE system variable?

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

    Problem importing Excel data with DTS

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

    UPDATE from multiple tables

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

    INSERT using SELECT

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

    SELECT by ordinal position???

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

    Strange CREATE PROC error...

    That nailed it....thanks a million.
  16. nwm76

    Strange CREATE PROC error...

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

    Strange CREATE PROC error...

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

    Strange CREATE PROC error...

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

    Passing parameters into DTS

    That will do nicely... Thanks a lot.
  20. nwm76

    Passing parameters into DTS

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

Part and Inventory Search

Back
Top