Recent content by shikha77

i have a report in which i am drawing vertical lines between diffrent columns. In the end a horizontal line should come (I HAVE THAT IN IN PAGE FOOTER).nOW THE PROBLEM IS THAT HOW TO DRAW VERTICAL LINE FROM PAGE HEADER TO PAGE FOOTER?? I TRIED IT BUT SOMETIME IT TOUCHES PAGE FOOTER SOMETIMES...

please can anybody give me the solution!!!! ITS V URGENT!!!

I have a form for calculating fees for members. I have attched the layout of form in word attachment.The code is given below: Option Compare Database Option Explicit Private Sub AmountDue_GotFocus() If IsNull(Me.FeePeriod) Then Me.FeePeriod.SetFocus End Sub Private Sub...

[SIZE=1]Hi I have a report based on this query : SELECT A.COMPANY_NAME AS COMPANY_NAME,B.MEMNAME AS MEMNAME,C.AMOUNTDUE AS AMOUNTDUE,C.COMPANY_AMOUNTDUE AS COMPANYAMOUNTDUE,C.FROMDATE,C.TODATE,B.GROUP_TYPE AS GROUP_TYPE FROM COMPANY_MASTER A, MEMMASTER B, [Fees Maintenance] C WHERE...

Hi! but this si not sql code ..for more clarity i will give more code : Set dbs = CurrentDb() Set rst = dbs.OpenRecordset("Fees Maintenance", DB_OPEN_DYNASET) If Me.Invoice_type = "company invoice" Then criterion = "Company_code = " & Me.Text4 & " And fromdate= #" & Me.Text0 & "#" Else...

Hi!! I am a new member here :) .... i have a vb code : Set dbs = CurrentDb() Set rst = dbs.OpenRecordset("Fees Maintenance", DB_OPEN_DYNASET) If Me.Invoice_type = "company invoice" Then criterion = "Company_code = " & Me.Text4 & " And fromdate= #" & Me.Text0 & "#" Else criterion =...