Search results

Hi, I Found the solution... Code as follows, Dim strSQL As String strSQL = "[LotNo] = '" & Me![LotNo] & "'" & " And [Description] = '" & Me![Description] & "'" & " And [Invoice] = '" & Me![Invoice] & "'" & " And [Customer] = '" & Me![Customer] & "'" dlook.Value = DLookup("LotNo"...

Yes in VBA Paul Eugin...

Hi All, I Have one main form in access 2003 i want to use Dlookup function to 1 text box with 2 criteria is it possible? My Formula: Text67. Value = DLookup("Balance", "dbo_WbookEdit", "[Lotno] = '" & Forms![Edit]![LotNo] & "'" And " & [Description] = '" & Forms![Edit]![Description] & "'")...

Hi Chris, Yes am doing the same way that you are explained above, just want to know that is possible or not? i think access have some limitation on that... Thanks for your reply... Anbu

Hi all, i have 1 combo box and 1 text box i look up 2 columns in the combo box from that combo box i want to look up 2 column to text box example: Table values: Col 1 Col 2 A 1 A 2 combo box successfully look up 2 columns but i look up to text box Formula...

Hi Shoji, Understood the code works well, but my intention is to prompt message to remind them to change the card number after 7 times i pressed add button... Thanks For your reply... Any solution Experts?

Hi, Noted, Now i copy the code in the After update event Run Time Error '7965' The object you entered is not a Valid recordset property. Private Sub Combo4_AfterUpdate() Dim conn As New ADODB.Connection Dim objMyRecordset As New ADODB.Recordset Dim strSQL As String Set conn = New...

Hello, This is my amended query and nothing come out in the combo 4 Anything need to add? Private Sub Combo4_Change() Dim conn As New ADODB.Connection Dim objMyRecordset As New ADODB.Recordset Dim strSQL As String Set conn = New ADODB.Connection conn.ConnectionString = "Provider = SQLOLEDB...

Hi Paul, I have 5 text boxes if i input the duplicate entry again on the same 5 text box values, i would like to have a message box.. Thanks for your reply!!!

Hi, Card number contains 10 characters so every time need to key in wasting of time that's why i don't want to make it null after click the submit button... just to remind them to change after every 7 times click the submit button... Thanks for your reply!!!

Hi All, i recieved error on the following connection string in the combo box change event code as follows, Private Sub LotNo_Change() Dim conn As New ADODB.Connection Dim sConnString As String 'Create connection string sConnString = conn.Provider = "SQLOLEDB; Data Source=SDSACCOUNT...

Dear all, i would like to select combo box value that link to MySQL table field May i know the connection string? Thanks in advance!!!

Dear all, I am using access 2003 i would like to prompt message box should come out for adding the duplicate entry.. Example: ID:1 User:a i add this record to my MySQL table from my access form by clicking the submit button then text box value become null, if i type again the same ID 1 and...

Dear all, I would like to display message box in access VBA if the user forget to change the text box value after clicking the submit button... Example: 1 card contains 9 rows when they input the 7th row message box should come out "please remember to Change the card Number" Thanks in...

Dear All, I have 1 combo box contains 2 columns look-up directly from the properties(Not VBA) Now i want to select record from the list Example: i want to select PM-1234-1111 so i dont want to type starting letter PM to select but i want to type 234 or 123 or somewhere in the middle or end to...