Recent content by Shaftsbury

Full error: Run-time error '3146' ODBC --call failed. [Microsoft][ODBC SQL Server Driver]Restricted data type attribute violation (#0) The error occurs when trying to run the following code: DoCmd.OpenReport "rptMaster", acViewPreview, , "[Div1] = '" & strDept & "' And [NCRStatus] <> '" &...

It looks like the text was padded out to 10 characters so instead of "Open" the text was actually "Open " I changed the format of the field to nvchar and removed the extra padding, hopefully that will fix it when new data is put in. :)

[SOLVED] Len(string) and strComp() not working for me I'm trying to set up a form so that certain controls are "enabled" when the form is still being worked on = "Open" versus one that is "Closed". I am using conditional statements to test the text in the "Status" field. I can't seem to get...

Thanks for the replies :) We have a HO and a manufacturing plant seperated by about 160km, the database is part of our quality management system tracking non conformance issues. We need to capture and distribute the data to and from both locations. I will look in to Azure and see if it...

We have been using a local access 2000 application for some years now, it is split FE/BE and works well with the small number of users we have on our older network. I am putting together a proposal to our senior management to upgrade to Access 2007 so that we can take advantage of email and...

Thanks for the speedy reply and good info, it all makes sense now. :)

A question came up today that i have not found an answer for as yet. We use an access 2000 database at work, which is fairly old. The file size of the original is around 135,000 kb. We have been having some problems with the database, so today I did 2 things: 1) I copied and pasted the...