Search results

Yes you are right but, i am not passing string i am passing value of a field which can be anything (not fixed). That procedure i did not apply in previous post which you are sharing here. I did try with following Private Sub Form_Load() If Not Trim(Me.OpenArgs & " ") = "" Then...

Ok, i have some issues with my following code, its working fine but not following the steps of event, may be i used wrong operators. Dim VBAnsw As String If IsNull(Me.ExchangeRate) Then VBAnsw = MsgBox("Currency exchange rate is not found for selected transaction date !!!" & vbCrLf _ & "" &...

Dear Ranman256 Does it cover all the points i mentioned in above post, i dont think so. no backup for accidental input or change, if you know the procedure whether its hard or soft please mention.

Currency is a field name and its string and not field type (number). Got it..... =DLookUp("[Rate]","tblExchangeRates","[Currency] = '" & [cboForeignCurrency] & "' And [ExhDate] = #" & [txtDate] & "#")

Hi I have following dlookup for multiple criteria but it is not producing the desired result, i am pulling the exchange rate for particular currency on particular date from tblExchangeRates. =DLookUp("[Rate]","tblExchangeRates","[Currency] = '" & ![cboForeignCurrency] & " And [ExhDate] = #" &...

Hi I am trying to figure out the way how i can control main form with sub form save and fields change event. What i am trying to do is, 1. I want one button on main form (frmGeneralDataEntry) to save any changes made on sub form (frmTransactionsSub) which is part of main form as well as sub...

I big thanks to the developer and a great circulation by my friend isladogs and your guidance for search SQL2VBA. i have got the very handy tool which i attached here that works with 2007 and above versions also. it was originally posted by isladogs...

A Similar query with sql on load event with calculated fields. Private Sub Form_Load() me.ListBox.RowSource = " SELECT tblTransactions.AccountNo, tblAccounts.AccountName, tblAccountsHeader.HeadingName, tblGroups.GroupName, tblAccounts.Currency, Sum(tblTransactions.CurDebit) AS SumOfCurDebit...

Thank you gasman (plain English and programmatically) both:)

When i am entering it manually in list box row source its working fine, what is the issue with after check event. If Me.chkBank_Cash = True Then Me.EntryList.RowSource = "SELECT tblEntries.EntryNo,tblEntries.EntryDate, tblEntryTypes.EntryType, tblEntryTypes.Cash, tblEntryTypes.Bank" _ & "FROM...

Thanks for your help However i want list box to appear only three columns EntryNo,EntryDate,EntryType nothing else. Me.EntryList.RowSource = "SELECT tblEntries.EntryNo, tblEntries.EntryDate, tblEntryTypes.EntryType, tblEntryTypes.Bank, tblEntryTypes.Cash, tblEntryTypes.Customer...

Hi everyone, I am facing some problem with delimiters in my below sql Private Sub chkBank_Cash_Click() If Me.chkBank_Cash = True Then Me.EntryList.RowSource = "SELECT tblEntries.EntryNo, tblEntryTypes.EntryType, tblEntryTypes.Bank, tblEntryTypes.Cash, tblEntryTypes.Customer...

Yes you are right, but before going to sea directly i wish to prepare my self in river and get basics swimming right, i have grip now on database tables, relationships and its structure which is only one of the many things required for a professional application development. I am making a very...

I have add the function with NZ and its working ok, i have no problem with what main have accounts already being created. The problem with main that still dont have an account, as you can see in my previous post here the account format should be a six digit if main account is 105 then new...

This function works for the main accounts which have accounts under it This was placed on control source of txtNewAccountNo text box =DMax("AccountNo","tblAccounts","AccHeaderID = txtMainAccount")+1 Above works ok, when main account have accounts for example main account have 104 and their is...

it is giving syntax error now i have 3 queries including the result query. 1. QryEmpEvaluation 2. QryEmpEvaluationSub 3. QryEmpEvaluationResult (Below code is mentioned in this query) SELECT tblEvaluation.EvaluationID, QryEmpEvaluation.EmployeeNo, QryEmpEvaluationSub.LatestEvaluationYear...

Hi everyone, I have following sql to get Max value of column and i want to add 1 for new account number on after update event of cboType to assign the new account number, in order to do that i have following sql, which find the last account number under the Main account...

Hi everyone, I am looking for (modules, forms, query, tables, functions) converter from Access VBA to (Python or Java (netbeans sqlite)). If not possible for all stuff than whatever is possible. Please share a link or advice on procedure to convert it. Many thanks in advance for your help.

Gasman Do you ever understand anything that is posted to help you? I do understand and near to accomplish my two databases and will post here shortly for examples and a great tools for HR and Accounting departments. On every post you make, you keep moving the goalposts. You state code that...

Thanks but its giving error subscript out of range and when i click end in debugging its showing correct records. but each time i run its give this error, only for the single args arguments and not for double Why this error any clue how to fix it.