Search results

Thanks for suggestions... I will try with bound form.

My thought, If design unbound forms then I can use in 2 ways as same requirements of Sales and Purchases. That is the reason I'm trying to go only with code. And I need to set some validations If data store into different tables. In the form, both Insert codes are working well but need to set a...

Yes, your correct I don't have to set any record source and recordset on the form. I just wrote Insert code but did not declare any variables and recordset. Please guide me on how to declare variables and set recordset as per the attached DB. In the DB, please open the form frmSE_A is a data...

Thanks for reply In the form, all fields are unbound fields. There is no data source from form to table pass the data as directly. I'm trying to Insert the data with purely VBA without bound fields. Please help on coding.

Hi Friends! Can anyone help on writing a Insert code with looping. I have designed a Invoice form with subform and using Insert code for enter the data from forms to tables as per following code. Private Sub btn_Save_Click() Dim i As Integer Dim frmSE_B As Recordset Set frmSE_B = frmSE_B...

Hello, I tried to use Recalc method in Reports but it doesn't work. i used VBA Dsum in my Report_Load but it takes so much time to update. Due to this reason i tried Recalc method but it is not supporting. Please give suggestions to speed up ??? I used this code in Report_Load...

@sneuberg Thank you so much both issues resolved. 1st issue solved by using Me.Recalc 2nd issue also resolved with "<>" :):):)

Hello Experts! Can anyone please solve these issues in my project? Issue-1 When I opened the form “Total Purchases Value” field is showing null for some time please look at the attached screenshot and It takes 5 to 10 min to update, please look at the attached screenshot. In this case I used...

Actually Users that data is entered from Manual book (Daily Cash In & Out). They are entered the data as per book manual & Order wise. We are easily find-out with ID Numbers which data is is latest record in the normal query. Then some of query's merged in the UNION Query that time how to find...

sorry for the confused for every one :( Now i can explain very clearly I have attached Db file. Can you please once open it and go to Query: BT_Qry1 this is normal query source from Query: BT_UnionQry1 In the BT_Qry1 Data are stored 9 records and it source from below following user forms (Data...

am not understing... what you lost for me? :(

thanks for respond. i have attached the screenshot as per my merged query details. and mentioned in last column which record is 1st, 2nd, 3rd stored in union query that basis i need to create a serial numbers.

Hello, Can anyone solve this problem. I was Merged 4 queries in a Union query. So in this case i need a serial numbers that which query data is first stored in union query that basis i need to create serial numbers from 4 queries data stored as 1st priority basis. how to make this Issue...

Thanks for suggestion, i will try this

yes, Amount filed is show the value as positive. when the Qty1 value is "0" that time Amount value shown a negative value becuase currently using the formula problem i think need to change the formula that is based on Qty1 with value or without value... i have used the below formula also but...

Hi friends, can anyone help on my issue i have attached the screenshot with explanation. how to change the formula as per screenshot issue. Amount: CCur([Qty1]+[Qty3]-[Qty2])*[SPrice]*(1-[Disc])) Thanks, Sandhya.

its working good, but how to give a fixed formula because sometimes VAT Rate is different Like: (5% or 6% or 14.5%).

how to use following calculation in the Query/forms Ex: Filed1: IncludeTax amount : 100 Filed2: VAT Tax Rate is : 14.5% After VAT deduction W/O Tax Amount is = 87.34 ( this amount how to come directly in single formula? can anyone please replay how to use the formula in this case...

its ok no problem and i don't know about that... Yes, I've checked both subform Property Cycle and tried (All Records, Current Record & Current Page) But there is no change. :( Thanks.

Hi friends, can anyone solve my issue Issue with Cursor moving on multi Subforms in a form I have 2 sub-forms in a main form as per screenshot. So Cursor moving from main form to 1st subform working well. After can’t move the cursor from 1st subform to 2nd subform with tabbing or entering...