Search results

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

Thanks June7 it is working like a bullet.

in immediate window of command button it is showing the value of combo box, what is error message i already mentioned to you.

Un post and VOID these are two completely different things in accounting. here i am concentrating on VOID only, when i do post button that time i will look for un-post.

I don't know what is wrong here, all sql is correct but it still giving the error for Run time error 3061 too few parameters expected 1. Private Sub cmdVoidEntry_Click() Dim VBAnsw As String If Me.cboEntryNo > 0 Then VBAnsw = MsgBox("Do you really want to VOID the Entry?"...

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

My combo box is getting records from query and query have tables fields selected. I am filtering some data in combo box from the query hence, its deleting the information.

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

Ok, now i have attached the form with tables and queries i did try all but not succeed. I also dont know why its not working as other forms are working correctly with same procedure. Because may i have some extra fields on forms header, but it ok to have on header?

Many many Thanks for your help so far in any question/post is asked by me and you have contributed by any means, i am very well aware of your contributions for anything you have done for me to help. However, i have make some modifications in your code and procedures and get it done easily...

I have checked and result are not showing correct, may be i am not placing your code write or in event procedure the way you want, for your information i have put this =GetNewAccount([txtMainAccount]) in txtNewAccountNo control source, if its wrong then tell me the correct placement. Nothing is...

Thanks for you help and guidance. However, their is some conditions are not correct. As i said before IF i select subaccount than subaccount number will be added with account number that means if i select account number 105001 in sub account combo box then new account number will be 105001001...

i need to add some parameters to creating account in my attached db I will be adding sub Account value to account in tblAccounts. before you guided for creating new account function. Option Compare Database Function GetNewAccount(txtMainAccount As Long) GetNewAccount =...

FilterON and Off is complete disaster, its deleting my fields information. If IsNull(me.cboEntryNo) Then Me.FilterOn = False Else Me.Filter = "[EntryNo] = " & me.cboEntryno & "" Me.FilterOn = True End If Please provide the correct piece of code, i did try with recordset.findfirst but...

Yes but i tried all option available their nothing work out. is it possible to sort out by any other way?

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

I have no problem with table settings, but what ever i have settings on table field form field is not showing that it is rounding the figure which i dont want. Show me settings of form. My tblExchangeRates [Rate] field have following. Field size = Decimal Field Format = General number Scale =...

My tblExchangeRates [Rate] field have following. Field size = Double Field Format = (Blank) Decimal Places = 4 My frmTransactionsSub [ExchangeRate] field have following. Format = General Number Decimal Places = 4 I cannot put decimal because field in table make it to round figure...

Thanks Minty for your guidance. I have one question about exchange rate usually the exchange rate is placed in decimal values up to 4 digits after full stop like 4.5271 and table is also accepting it. But my question about form field which is making this value round figure lets say 4.5271 is...