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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.