Search results

Hello, Is there any way I could lock all the items in my form detail with the click of a button? Or would each text box / combo need to be done individually?

Got it! If MsgBox("Do you want to save the changes?", vbYesNo, "Confirm Save") = vbNo Then Me.Undo ElseIf Me.Dirty Then Me.Dirty = False End If Thanks for your help.

It now looks like this: Private Sub Command55_Click() MsgBox "Do you want to save the changes?", vbYesNoCancel + vbQuestion + vbDefaultButton1, "Confirm Save" If vbNo Then Me.Undo End If If vbYes Then If Me.Dirty Then Me.Dirty = False End...

Thanks - where would I put it in my code to save the record and lock all text boxes?

I have got a form to change information on a table. There is a button to unlock all text boxes and another button to save the changes. When I click the save button I want it to show a vbYesNoCancel message box, then, if no is clicked, me.undo and lock all text boxes, if yes is clicked, save and...

I've got a form that is based on a query to look up information but there is 1 combo box that I want to update a field in the original table. I there any way to do this?

Thanks! I knew it must be something simple!

Whenever I create a new blank database it creates all the tables as per the attached document. Why does it do this??

Hello, Is it possible to create a gantt chart in Access? Any ideas would be good!

Thanks, There were some fields that werent enabled - it now doesnt show the error but doesnt delete the record. Allow deletions is set to yes, and I do have permissions - how do I check the query?

Hello, I am trying to add a delete button to a form to delete the current record but it always says the command deleterecord isnt available now. Any ideas? My code is as follows- Private Sub command11_Click() Dim Answer As Integer Answer = MsgBox("Are you sure you wish to delete this...

Hello, I've got a button on my form to write the current record to a PDF - only trouble is it writes all the records not just the current one... Can anyone help?

I have tried this on my form but it always comes up with the message "The command or action 'DeleteRecord' isn't available now" - Any ideas?

Hello, I am needing to create a search form to search a table in a database. It needs to search for either Order number, supplier, product code or all or some of these and then display the results below. A simple question but I can't get it to work. Thanks!

Thanks, How can I set the form so that users can't navigate away from the current record? Could you also give me an example of the unload code - I haven't done much code...

Thanks, How would you create that save procedure?

Hello, I have got a form for entering purchase orders, but I only want it to save the record if you click a save button. It would also be good to have a cancel button and, when closing the form if it isn't saved, a prompt to save or cancel the record. I have seen a couple of posts about...

All sorted - that text box wasn't bound yet...:o

Brilliant! Only thing is I can't edit the value that is returned to the text box - it just says it isn't valid for the field... Thanks for your help

I have got a combo box which I type a product code into and then text boxes which display the spec of that product. Is there any way I can set the default value of the text boxes to be a column in the combo box (eg [combo40].[column](1) ). I want to do this so it pulls brings up the default...