Search results

Hi everyone, I am posting the db and function here for new account and sub account functions which need to be rectified as it was created for single stage account and now i need multi sub accounts which can led the new account number up to 10 digits maximum more than that is not allowed as i...

Hi Everyone, I am writing cmd button event for delete in my data entry form before deleting the records i am storing the information in delete table and updating it with delete date in order to do that i have divided the sql in three portions (INSERT INTO, DELETE, UPDATE). Please review the...

Hi I have form with subform in main form i have Entries and subform is transactions each entry have many transactions associated to it, subform is continues form. I want to restrict user from leaving the transaction line blank unless they fully provide all required information on it. I have...

Hi everyone, Hope you doing fine. below is working code for message box, i want to amend the else portion of message box when VB Yes than it has to check whether the exchange rate is exist or not if exist then it should open the frmRecordExhRates with its values and dont create new entry, in...

Hi everyone there, I am coding the cmd button to void the entry with its related transactions in tbltransactions, below is the code. Private Sub cmdVoidEntry_Click() Dim VBAnsw As String If Me.cboEntryNo > 0 Then 'If combo box is not empty then VBAnsw = MsgBox("Do you...

Hi Everyone there. I want to prevent users from deleting the selected value in combo box or from editing it. I am using find first function for records with combo box and when i delete the selected value in combo box it also deleting the record from table, which i dont want to be happen. So...

Hi Below combo box after update event is not working Private Sub cboEntryNo_AfterUpdate() Me.Recordset.FindFirst "EntryNo = " & Nz(cboEntryNo, 0) End Sub form record source is tblEntries No records are showing in text boxes for that EntryNo (PK) of tblEntries. Combo box row source SELECT...

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...

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...

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.

Hi everyone, I have button on click event to open frmCreateAccount with the value assigned by me to be updated in frmcreateAccount cboGroup in order to do that i have make following code, but its opening with no value filled in cboGroup on frmCreateAccount. Private Sub BtnContinue_Click() If...

Hi everyone I have a table tblAccountsHearder which store the headings of account (not accounts) under each account Heading there are several accounts listed in tblAccounts. I have combo box on frmAddNewAccount name is cboType in this combo box my row source is SELECT...

Hi I am trying to load an image on form with form load event directly in event procedure, i have image frame on form and it will load the image once form is loaded or open. Also i have more buttons and option on form that will change image upon selection individually, but in first on form load...

Hi everybody I have main form and a sub form on it and sub form data source is query, I am trying to figure out if i can save my main form with subform in one save command button, also it should not irritate me by asking to save each time i move my cursor to subform. I have following code...

I am struct with following iif condition. Here in i am applying the conditions, first if option7 = True (selected) then it has to check txtEntryNo,txtEntryType,txtEntryDate are not null if its null then it has to give following out put message mentioned in msgbox. if all goes well then proceed...

Hi As title labeled i am trying to update the query results which is sum of another query to a form fields, i did try in putting the reference to QrySumGenralEntry from control source of unbound text boxes something like =[QrySumGeneralEntry]![SumOfCurDebit] for all four fields but it doesn't...

Hi Guys I have two issues with my accounting form Main Form = frmJounralEntry sub Form = frmJounralEntrySub [TransactionNo] = Number Form Control Source = QryJournalEntry [TransactionID] = autonumber PK tblTransactions 1. Show All records: on main form i have check box and the fields on...

Hi Everyone, Hope you are doing fine. I have decided to make accounting system in access, i will start with attached tables and information then later on can be increase and modified as per requirement. Herewith i have attached my table structure which is very very important you guys can...