Search results for query: *

I'm new in participatin in a forum. Thank you for remark

Thank you. It worked

I've tried one more thing. I've moved code to subform's on load event. If IsNull(form_invoice.invoice)=False then me.form.AllowAdditions = False End If it works fine if it's (IsNull(form_invoice.invoice)=False) TRUE, otherwise I receive the same 2455 error.

Hi, I have a form(“Invoice”) with a subform(“InvoiceLines”). I cannot get what’s wrong. When I open a form from design view everything is ok but when I try to open the same form from another form clicking on command button I receive error: Error: 2455 - You entered an expression that has an...

Thank you. It worked great.

Hello, I have FE/BE databases. I want to delete tmp table (BE) after import data to another table from fron-end database. I've tried to use following code: CurrentDb.TableDefs.Delete "[;DATABASE=" & DBFile & ";]." & TableName & "" where : DBFile = "C:\a.mdb" TableName ="table1" but I get...

Thank you. I've solved problem. It was problem in VBA options -> error trapping. I've changed from "break on all errors" to "unhandled errors" and my error disappeared.

I've checked. The last posted problem is with an expression in the report's query. But if I try to open another report and cancel dialog form without entering data I receive error "OpenReport action was canceled." marked line DoCmd.OpenReport "Profit", acViewPreview

In fact I get error while opening report with date enter on the dialog form. "the expression is typed in incorrectly, or it's too complex to be evaluated....." Maybe somebody knows where the problem is?

I use TreeView as a menu to open forms, reports. I'm stuck in the opening reports which use a dialog form to enter date before. Problem : On click to open report a dialog form opens to enter date for report, but when I close dialog form without entering data to open report I get error...