Search results

  1. sumox

    Simply open three reports on single clik in form

    another question also. do query fetch data simultaneously to all reports ? is there any solution. do i need to copy queries ?
  2. 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...
  3. sumox

    Is there a minimum post rate here?

    ya there's fine . if you post less than 5 posts per month. then You will be billed with following : A Party in Singapore for all AWF Members ! Ha ha ha . No Minimum postings buddy. No Rules for maintaing memberships ! Just increase your knowledge here by viewing maximum posts/threads...
  4. sumox

    Tasklist max tasks and max hours

    what you want to do? I simply can't Understand. First tell which field should do what?
  5. sumox

    Best way of extracting data.

    i think kacey8 you're totally confusing. request one thing and get it solved. then request another then get it solved. MIXING all the things will confuse viewers. First of all you wish to Get Sum of all Portal Values within date Range. So, Create a Query by wizard with date field, Portal...
  6. sumox

    Query that returns the first record of each client depending on a filter

    ok. seen. so, now what's the problem. which egg u required not fetched by ACCQuery
  7. sumox

    yes / no field query

    note: The Table field of Yes/No is a Boolean type field True or False is meant in internal coding of Access Queries. So, Whenever you deal with Yes/No Fields, like IIF([MyBurgerIsHot]... then type IIF([MyBurgerIsHot]= True, "Open your mouth", "Shut your mouth") so, this is the thing ...
  8. sumox

    FORM UPDATE PROBLEM IN WEB page

    oh sorry to forget to upload screenshot pls. find here
  9. 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...
  10. 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 ...
  11. sumox

    how to refer to Controls in Selected Report thru VBA Platform

    ok . it's showing like attached screenshot. It's not populating the Report's textbox wud cmpt-n-repair will do the job? many thanks in advance Ya'its opening same report three times with different dialogboxes text -- which i donnna want . ?? Another solution whether query design can...
  12. sumox

    Subform

    access runtime 2007 is not running well on my system so sorry, forthat
  13. sumox

    Subform

    http://office.microsoft.com/en-in/access-help/convert-an-access-2007-database-to-an-earlier-file-format-HA010230822.aspx above link is on Howto's for saving to Earlier Ver. of acc2003 from access 2007or abuve
  14. sumox

    Subform

    sorry nat having acc2007. , acc2003 installed Pls. upload ACC2003 version file (mdb extension) (instead of accdb extn.) for the meanwhile pls. send screenshot of table design, subform properties---data tab dialog box. thanks
  15. 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...
  16. sumox

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

    oh! its easy find the way in excelapp click Window--->Unhide-->Click finish
  17. sumox

    how to refer to Controls in Selected Report thru VBA Platform

    Dear JHB Error : Not working ! just do nothingg ! at all created form ---> Onload dumped the Dim... script Created PvtSub_RptLoad vba func as per advice, but no result. Nothinggg
  18. sumox

    how to refer to Controls in Selected Report thru VBA Platform

    OK . so where does the Dim... Code goes in Textbox Event(CpyWord) where in wordtext shall be shown ?? i am not expert in Vba . Pls. keep me in your guidance . but meanwhile before you reply, i am trying. thanks to you if got success ElseIf Pls. see the errors in my next post Pls. do...
  19. sumox

    Printing Report between two dates

    ya create a query then feed in date field : between Forms!SearchFrm!fromdate and Forms!SearchFrm!todate then Create a Form Insert two textboxes one by one Right-click those and goto Properties---> Other tab : change name to "fromdate" (without quotes) now do this for next textbox rename it as...
  20. sumox

    how to refer to Controls in Selected Report thru VBA Platform

    ok , so i shud create a new blank report. under detail section. just create three subreports pointing to -->"Purch Vb Query" and then Create a static Label above each of these is this what i copy ? or your solution ?
Top Bottom