Search results

  1. sumox

    Simply open three reports on single clik in form

    I'VE objects in ACC2003 as per following : Form name : INVOICECreate Query Name : db_InvoiceSet Reports : 1st Report : Report_Inv1 2nd Report : Report_Inv2 3rd Report : Report_Inv3 All Reports based on Single db_InvoiceSet due to some cross and different manipulation of data for different...
  2. sumox

    FORM UPDATE PROBLEM IN WEB page

    I am having ACC2003 + win7 and ie8 Problem is that i've saved a working fine, good running form as Data Access Page on Desktop. rightclick-- savesas---..... See THE SCREENSHOT NOW, WHEN DATA WEBPAGE OPENED IT SHOWS #ERROR, #NAME #...everythin #ed ! no data. no field names, no...
  3. sumox

    How to Save Report As Active Web Data Page?

    I am having ACC2003 + win7 guys. my Db Version is a calendar of dailyblog type Tasks The Tasks are viewed by everyone in office having PCs. Db Type is F.E+B.E type. MY question is how to save a Report as Webpage Local on harddisk and that flashes updated information . Example ...
  4. sumox

    Report printing instead of previewing ...

    i've following Report PURCH VB Query Query name : PURCH VB Query1 I've done the Multiple Copying code, copied from AWF forum solution for printing multiple copies with different text on footer section. Ya !haa ha i wanted three copies of my report, but the Solution is Directly Printing...
  5. sumox

    how to refer to Controls in Selected Report thru VBA Platform

    i have created a module under module section of my DB My Report Name : "PURCH VB Query" the code is as follows : (what is want tell you later..) Sub Erlick() DoCmd.SelectObject acReport, "PURCH VB Query", True '"PURCH VB Query", acViewPreview, "PURCH VB Query" For i = 1 To 3...
  6. sumox

    Unsolved post inactive>30days forcefully mark as Solved/Closed

    Dear Moderator/Admin.web My suggesstion are to the real ongoing problem and it may Exist also : users post their questions 8 out of 10 users get their answers and solved 2 out of 10 users get some help/advice, but still not solved .... the 2-out-of 10 thread starters generally behave to be...
  7. sumox

    how to Shift MDB to Local Web Version

    Hi, I am having following config : Resources : 1. PC 1- win8 + ACC2003 + Backend of MDB Database + FrontEnd to use no localserver installed 2. PC 2-winxp + ACC2003 + FE to use , noLocalServer installed 3. PC 3- win7 + ACC2003 + FE to use, XAMPP Web server installed now my question is...
  8. sumox

    what is an ACCDB file, what's difference between mdb and it

    hi there i am seeing in many posts, Questioners post Sample DB with accdb extension What type of file it is, What's the purpose served and why people use it and is ACC2003 able to open it or not? i am bit confused bout MSACCESS Formats if anyone, pls also let me know all the extensions...
  9. sumox

    embedded Excel file not AutoSize

    My simple question again Asking... Last forum thread did not resulted in any repl. Please reply to my Problem if you're being so eXpert : I've report. a embedded Excel OBJ OLEunbound55 - named It's Excel file already made in windows It's Linked But when displaying data inside excel file it...
  10. sumox

    Automation: How to Fill another form with values of first form

    a hi ! all there i just created two forms which r so inter-rel. with each other 1. FormName : Invoice_SL Form controls which need to be copied to another form : a> PO No b> PO Date c>Dispatch Details d> - is a filtered list depending upon UID of Invoice_SL Form 2. formName : Challan_DLR...
  11. sumox

    Access Exported data to Excel....Excel file Error

    I've vba in Report onformat the vba code does some data copying to External Excel file (premade by vba) Now on first run, i got success But on opening the excel file, it showed blank space + Error"File already opened" No White Spreadsheet is shown with data to seeinto file, i created...
  12. sumox

    access export to excel thru vba but excel file Dumb on Open

    Hi Experts Please help me reg. this problem I've downloaded a script for exporting to excel the access data for evaluation by our other Purchase Deptt. All things go fine. But when i close access and try to check the excel file it ends with following nature : 1> Excel software opens 2>...
  13. sumox

    VBA script executes thrice per OnFormat in Report? how to do it only once

    I have a report and in rpt-footer ,some values/txtboxes haf to be fetched to vba for calculating or External Excel file writing now I've activated OnFormat Event , which executes the script thrice per Preview !:banghead: how to stop dat dammn thing, and execute only once i am using...
  14. sumox

    HOW TO PASS PARAMETER TO EMBEDDED EXCEL OBJ and display it in without opening exce

    Dear all I am having a report, which has a subreport called TTML the main report gets [Tot] field value from subreport's GTO field The Value is in currency format Now i wish to display some Excel calculations based on [Tot] field value which should be passed during OnFormat Event...
  15. sumox

    How to make filled form from first form

    i have two tables Challan Invoice We create firstly challan by Challan Formname: ChForm ChForm has following fields data which i want to copy into INVForm based on Invoice Table 1. Challan No. 2. Date of challan 3. PO No. 4. Array of Fields like ItemSr.no , ItemName, Qty and UOM 5...
Top Bottom