Replies

Thank you

Thank you very much for your kind reply.I have tried to substitute the controls in my function,but still
i receive the error 3075 missing item in query expression.

What have i done.In my working strWhere expression
strWhere = ” WHERE ((([orders].[orderdate])>#1/1/2001#));”
i have replaced the right side part of >#1/1/2001#)) with between Forms![frmDateRange![BeginDate] And

Forms![frmDateRange![EndDate

So my new strWhere looks like this, but does not work:

strWhere = ” WHERE ((([orders].[orderdate]) between >#” & txtBeginDate & “# And #” & txtEndDate & “#));”

So my mistake lies somwehere in the above code.I cannot understand.

My previous working function was the following

Public Function FncRecentTables()
Dim strOrders As String
Dim strOrderDetails As String
Dim strWhere As String
‘******************** note that the strWhere is valid for all the tables so it could be changed only once

strWhere = ” WHERE ((([orders].[orderdate])>#1/1/2001#));” ‘ the setting is dd.M.yyyy
‘ ====================================

strOrders = ” SELECT orders.orderid, orders.customerid, orders.orderdate, orders.[required date], orders.SalesTaxRate, orders.freigth,

orders.paymentid, orders.PaymentMethodID, orders.bankid, orders.FreightCharge, orders.invoicedate, orders.AuftragNr INTO orders1

FROM orders”
CurrentDb.Execute strOrders & strWhere
End Function
I simply cannot find my way out of this problem

May i wish you a merry Christmas

Hi,
i feel obliged to let you know you have guessed the reason for all these troubles!!It was the font that was guilty for all that! I have changed it and all worked,but i want to congratulate you for your guess

regards

the labels are written in design you and the text appear in preview mode but the text in these labels does not appear when printed.I knwo it doesnt makes sense, and further,it is only some of the alebls not al of them that miss on printing.Did anybody come accross these problems.?

Thank you very very much for your reply.How shall i call this function in the OnOpen event of the form?
i have tried this:
LockForm (me,blnLocked)
or
LockForm(Me.Name,BlnLocked)
but i received errors.

Best regards