Search results

Hello, Private Sub TimeSpentFI1_Click() Dim number As Integer Me.TimeSpentFI1.Text = Format(number, "0.00") End Sub I need help on this one, I need to be able to insert a number 1 or 30 and the textfield recognize it as time like 1 - 1hr spent or 30 = 30 minutes spent, any help will be...

Thank you arnelgp! I was complicating myself :)

Hello, I am trying to check on duplicates if I enter the data again, but it only works if I enter Both values but if I enter just one it take it as new entry and not recognized that single value already exist in Table, Example: if I have the Vendor and Code it will tell me that value already...

Thank you for your reply, I added to my existing code and It worked perfectly!

Hello, I had this code in different buttons to search record on each table and when does not exist to add the new records on each tables using forms How can I search two tables at the same time with one single button instead of two button for each table? Table: tbl_CDS_DRA_Key_Legend...

By the way I change the query to: Me.RecordSource = "SELECT * " & _ "From tbl_GCDS_Operations_Positions_Recruit " & _ "WHERE (((tbl_GCDS_Operations_Positions_Recruit.[Position Applied For]) Like '" & Me.cboGoToPosition.Column(1, Me.cboGoToPosition.ListIndex) & "*" &...

Thank you, will do.

Hello, I am trying to bring two values in a txtfield from one form to another form using a combo box to select the option I want, then when populate the values I want to see but it is not the option I want I have a clear button that does not work, when I choose the option on the combo box and...

Hello, My name is Ivonne, I am new on Access VBA, I am on a learning process, so from time to time I have questions and I need to resolve them. Thank you in advance for all the help you can bring. Cheers!