Search results

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

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

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

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.

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

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

Hi friends, can anyone solve my issue How to set a Default value "0" in Query Extended Price Calculated filed ? i have attached the screenshot with explanation can you please replay how to changes the formula. i have used below following functions but there is no workout. Extended Price...

Hello friends, can anyone solve my issue How to use Dsum Function? Am using below following Dsum functions but they are not working and shown an error result. I have attached the screenshot can you please replay how to use dsum in this case...

Hello all, need for help on calculated filed in table As per shown on screenshot Printout filed is calculated filed from ([Item] & "-" & [Code]) fields. So this calculation is working well. But in Code filed is letters with number is there so i need only letter format without number in...

Hello friends, how to do hide for shortcut target information on desktop Access database shortcut files? as per screenshot. :confused: Thanks, Sandhya.

Hello Friends, Can anyone help for VBA code correction I got an error msg on form with closing. I have a main form (SalesReturnOrDamaged) and subform (SalesReturnOrDamagedSubform). i have used a VBA code on main form Close Command button as per shown in Code Tag. But that is not working and...

Hello friends, Can anyone help on my issue I need some calculation formula about Cust. Disc% and CustDisc Amt fields. Both of direct punching fields so in this case i need a formula that is if enter the percentage value in Cust.Disc% field then update automatically CustDisc Amt field. Or...

Hello, How to give a VBA code for duplicate records is without entry in Subform datasheet. I just used in the screenshot code but that is not working properly. I have attached the screenshot with explanation so can anyone help how to change a vba code for without entry duplicate names...

Hello Friends, Can any one solve my issue After conditional formatting with every new entry in Datasheet Item Code or Item Description then after row Disc % and Amount default value’s is shown as #Type! And datasheet is very slow with flickering. If it conditional formatting is remove...

Hello Friends, Can anyone solve my issue Sum Function in Unbound text on Datasheet subform How to make a sum formula without count orange color rows Amount. Because that orange color rows is product return items so no need to count in SubtotalRs. Actually I have used below normal...

Hi Friends, Can anyone help on my Issue I have created a database for goods purchased purpose that is main form and subform. So I need to give a VBA code on ItemReturn & ReturnDate. I have attached the Screen shot with explanation and database file. So can you please help how to set VBA code...

Hi Friends, Can anyone solve my problem How to design a form for a table based all records to design in a single form without top to bottom list wise and without scroll bars. Need to form design for all record details are will show on a form as side by side only as horizontal list wise. For...

Hello can anyone help on my issue, I have created Command buttons on forms with VBA code. Records GoTo previous and GoTo Next Record so both of working is good. But Next Record command is force to a new record. If suppose when we clicking on last record. It is go to new record...

Items form: ID - Brand --- Model --- Color --- Items Description 1 -- Samsung -1234 --- white ----Samsung 1234 white 2 -- Nokia -----225 ----black ----Nokia 225 black Above Brand, Model, Color field's data is merged in...