Recent content by Jack Hammmer

Thank you very much! I am very grateful... Though I would be more grateful if you could help me with the remove button; this could either remove the last entry on the form or remove the selected row from the List Box. Again I do not know how to do this... Although I have stolen a lot of your...

Yes; something very similar to what you have done there. Although ashamed to admit it I do not know VBA or even VB at all and can barely understand what you have managed to do: By barely I mean I don't understand. Though if you could explain it to me I would be extremely grateful. I have had...

I need a button that will be able to create a new row and add certain fields to the table from the form. I just need the 'Puchase' button to add; Service ID Customer ID Services ID Order Date From the form to the table and the 'Remove' button to take the selected Purchased product from the...

I have checked the file size (690kb) under the limit of 750. I will try zipping and uploading again though. Reducing the file size has worked; thankyou. I have now uploaded the file so you can view the database.

I should of said earlier I have also tried Me.Requery and that appears to do nothing also. I have tried uploading the database so it can be viewed but everytime I have tried, the website would not allow me. When I tried Forms!frm_Facilities!Purchased.Requery it did update the list box although...

I have figured out that when the information has been changed and the 'Refresh' / 'Refresh All' button is clicked in Access that the form and list box information are updated and correct; is there a way to emulate the refresh with VBA? I have tried: Private Sub Purchase_Click() On Error GoTo...

I have a form in which I require a button to save information such as: Customer ID (General Number) (Text Box) Services ID (Autonumber) (List Box - qry_Services) Service (Text) (List Box - qry_Services) Description (Text) (List Box - qry_Services) Price (Currency) (List Box - qry_Services) Date...