Replies

Thank you for the help

Thank you for the help

the list box is bound to a query and i have quoted it as row source above.The first field,which is hidden, is clientid, and i want
in the on current event to show all the offers the a client has issued. The purpose of the list box is see for each client the offers that he has

regards

the list box is bound to a query and i have quoted it as row source above.The first field,which is hidden, is clientid, and i want
in the on current event to show all the offers the a client has issued. The purpose of the list box is see for each client the offers that he has

regards

thank you for your reply.It is because i am sending the database to different computers and the users should do it themselves.

Regards

thank you for your reply.It is because i am sending the database to different computers and the users should do it themselves.

Regards

It works !!!!!!!!!!!!!!!!!!!!!!!!!
Obviously the problems has lied in the date separator of my system.
I have tried your suggestion and now the code is flying !!!!!!!!!

Thank you once again

i wish you a nice day and please accept my bets regards

Primerov

It works !!!!!!!!!!!!!!!!!!!!!!!!!
Obviously the problems has lied in the date separator of my system.
I have tried your suggestion and now the code is flying !!!!!!!!!

Thank you once again

i wish you a nice day and please accept my bets regards

Primerov

Thank you very much indeed for your kind attention.I think the help you gve to me and to everybody else in the Forum is enormous.

I get the the following error :

Syntax error in date in query expression Customers.lastUpdated > 10.01.2003

I am sending to you the table,the form and 2 modules, in order to help me find out the reason for that error.

Best regards

Thank you very much indeed for your kind attention.I think the help you gve to me and to everybody else in the Forum is enormous.

I get the the following error :

Syntax error in date in query expression Customers.lastUpdated > 10.01.2003

I am sending to you the table,the form and 2 modules, in order to help me find out the reason for that error.

Best regards

Dear Hans,

I receive a Syntax error with my constant

Public Const CnstUpdate As Date = #10/1/2003#

strCustomers = ” SELECT customers.* INTO CustomersTemp FROM customers WHERE Customers.LastUpdated > #” & Format(CnstUpdate, “mm/dd/yyyy”) & “#”

Would you help me out ?

Dear Hans,

I receive a Syntax error with my constant

Public Const CnstUpdate As Date = #10/1/2003#

strCustomers = ” SELECT customers.* INTO CustomersTemp FROM customers WHERE Customers.LastUpdated > #” & Format(CnstUpdate, “mm/dd/yyyy”) & “#”

Would you help me out ?

Thank you for your advice that i do not need the code if i close the form.I wanted now to use the code in the OnClick event.
I could not do it and now i will try to follow the advices of Hans and find out my error through debugging
best regards

Thank you for your advice that i do not need the code if i close the form.I wanted now to use the code in the OnClick event.
I could not do it and now i will try to follow the advices of Hans and find out my error through debugging
best regards

Thank you very much for your reply.I must have a funbdamental misate in my forms since i receive always the errors.

In the OnClick event i again receive the message “Type mismatch”:
Public Function ClearForms(f As Form)
‘ in the OnClick event i write ClearForms(me)
Dim ctl As Control
For Each ctl In f.Controls
Select Case ctl.ControlType
Case acTextBox
ctl.Value = Null
Case acComboBox
ctl.Value = Null
Case (acOptionGroup)
ctl.Value = Null
Case Else
‘ Do nothing
End Select
Next ctl
Set ctl = Nothing
End Function

In the OnClick event, when i do not use funcyion, i have the message
“you cant assign a value to this subject.

Private Sub Command573_Click()
Dim ctl As Control
For Each ctl In Me.Controls
Select Case ctl.ControlType
Case acTextBox
ctl.Value = 0
Case acComboBox
ctl.Value = 0
Case (acOptionGroup)
ctl.Value = 0
Case Else
‘ Do nothing
End Select
Next ctl
Set ctl = Nothing

End Sub

Best regards