Search results

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] <> '" &...

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

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

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