Recent content by AMH

Thanks DLookup worked fine

Does anyone know if it is possibel to reference a field in a query from VBA code if so some sample code would be much appreciated Thanks in advance Aidan

Does anyone know how you can get at the day part of a date field and then move a value to it eg dd/mm/yyyy move 01 to dd

Does anyone know how to turn off the confirmation message which you get when you run a create table query

thanks for the help chris this seems to work well

Help Please !!! I am trying to delete a record based on the invoice number selected from a combo box. The code below finds the correct record but only deletes the invoice number field rather then the whole record hope someone can help thanks in advance.... strinvnum = Me.cboinvnumber...

this code seemed to do the trick uses find intstead of find first Thanks for the help !! Dim cnn As ADODB.Connection Dim rst As New ADODB.Recordset Dim strPurContract As String Dim strSalContract As String Dim intDelQty As Long On Error GoTo Err_cmdsavealloc_Click ' ' set...

I have a form based on query based on a table called allocations. On the form there is a combo box for contract number. What i am trying to do is find the contract in the contracts table based on the contract number selected from the combo box and then update a field in the contract table with...

I have a form containing a combo box which is a contract number. What i am trying to do is find a record in the contracts table based on the contract number selected from the combo box and then update the record in the contract table with a value from the current form. The current form is not...