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

Hi, I'm trying to copy data from one table to another. The source table has columns: Name varchar(30), Day decimal(8,2), Depth decimal(8,2), Name1 varchar(30), Day1 decimal(8,2), Depth1 decimal(8,2), Name2 varchar(30), Day2 decimal(8,2), Depth2 decimal(8,2) Destination table is similar...

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.

Gurus, I've got a rather garbled script that is giving me a major headache. Basically, I have an Excel sheet with multiple worksheets where the 1st worksheet - called "Contents" -contains a single column containing a list of all the remaining worksheet names that contain the data. I want to...

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