Search results

Spending hours and finding out how to overcome the problem, but another one emerges. I picked a data from Combo box, access asked me Yes/No, I choose Yes then click Save button, it asked me Yes/No again. I can't stop that second time question. This time I'm really stuck.

Yeah, problem occurs after using for quite a while.

I got some error, I just tried to replace the name of my own combo box, and create a new text box name Text432

I mean I put my problem into my attached file 😅

Hi, I encountered a problem, I placed it in the attached file, can you help me with that. Thank for your attention!

May be that won't be an easy task to you, but it will definitely be impossible job to me, I mean it's like I'm trying invent a time machine.

Yeah, I wish to create an undo command button which works the same way as Ctrl+Z of Word does.

The Esc key only works while I'm modifying the field content, but I have a save button, if I hit save button then hit Esc, it changes nothing. In the meantime, undo command button can throw thing back before I click save button, but unfortunately it can use for 1 time only, cannot send me back...

Thank for giving your opinion, I'll give it a careful thought.

Hi! I tried to make a command button which functions as Ctrl+Z (Word shortcut key), I used Private Sub Command332_Click() DoCmd.RunCommand acCmdUndo End Sub It works well but only for the first time. The next time I clicked the (undo) command button, it sent me a message Is there any...

I think about an idea of using if code, like if the number in the order < 100 then running the finding record code if the number in the order > 100 then running the transferring data code Is this idea possible? If it can, can you help me coding that? I have another question, I have 2 command...

Just did it Private Sub ComboBoxName_AfterUpdate() Me.TextBoxName.Value = DLookup("FieldName", "TableName", "FieldName2='" & Me.ComboBoxName.Column(1) & "'") ' Find the record that matches the control. Me.RecordsetClone.FindFirst "[Order] = " & Me![ComboBoxName] Me.Bookmark =...

Great work man, it went smoothly, thank a lot. When looking at the combo box, I came up with the idea of finding back the Client through the field Order, I mean when I type 1,2,3... (the Order of each Client) in the combo box, it will find back the record of the Client. I have a code: Private...

Thank you all for your quick response, here my sample db

Hi guys, I have a combo box and a text box, I pick a data item from the drop down of the combo box, I want that the data item is transferred to the text box, I tried Private Sub ComboBoxName_AfterUpdate() TextBoxName.Value = ComboBoxName.Value End Sub and also tried Private Sub...