Hi there, I have created an update form using Dreamweaver and an Access database.

When you load the update form. Some of the text fields are empty.

If you do not enter something in one of these fields and hit the update button. You get the following error.

Microsoft JET Database Engine error '80004005'
Field 'tblSuppliers.Facsimile' cannot be a zero-length string.
/html/advertiser-premier-details.asp, line 153

Can anyone suggest a way around this?

Thanks.

Mally.

Hi

Change your fields to allow zero-length strings

Tom

I'm sorry, you need to do this in Access using design view for your table(s)

T

Thanks Tom, it worked perfectly.

TA.

Mally

Hi there, the change just worked fine. Now that this is working, we get the following error message.

Microsoft JET Database Engine error '80004005'
Type mismatch in expression.
/html/results-wholesale.asp, line 67

<%
Dim rsSearchResult
Dim rsSearchResult_numRows
Set rsSearchResult = Server.CreateObject("ADODB.Recordset"
rsSearchResult.ActiveConnection = MM_connSeek_STRING
rsSearchResult.Source = "SELECT SupplierName, Location, ShortDescription, TimberSpecies, CategoryTitle, Country FROM Query1 WHERE TimberSpecies LIKE '%" + Replace(rsSearchResult__MMColParam, "'", "''" + "%' AND CategoryTitle LIKE '%" + Replace(rsSearchResult__MMColParam2, "'", "''" + "%' AND Location LIKE '%" + Replace(rsSearchResult__MMColParam3, "'", "''" + "%' AND BusinessType LIKE '%" + Replace(rsSearchResult__MMColParam4, "'", "''" + "%' ORDER BY SupplierName"
rsSearchResult.CursorType = 0
rsSearchResult.CursorLocation = 2
rsSearchResult.LockType = 1
rsSearchResult.Open() <------------------- Line 67
rsSearchResult_numRows = 0
%>

Can anyone suggest why this is happening or what I should do?

Thanks

Mally.

Edited by - malhyp on 09 May 2006 02:11:05

Hey there, can anyone tell me if the following SQL will retreive the text version of the result Country (Australia) and Location (Victoria).

SELECT tblSuppliers.*, tblCountry.CountryName
FROM tblSuppliers S
INNER JOIN tblLocation L
ON (S.idLocation = L.idLocation)
INNER JOIN tblCountry C
ON (L.idCountry = c.idCountry)
WHERE UserName = 'MMColParam'

Tables.

.......tblSupplier
(A) idSupplier
(N) iLocation
(N) iCountry

.......tblLocation
(A) idLocation
(T) Location

.......tblCountry
(A) idCountry
(T) Country

(A) Auto Number
(N) Number
(T) Text

Location = Rome
Country = Italy

Edited by - malhyp on 11 May 2006 13:00:07