Recent content by ashu.doc

Hi Everyone I have sorted this out in a different way, as we know access 2007 SP1 does not support saving report as excel, but it does support saving table data as excel!! So I just had to change that in Macro and works perfect. Thanks all

Hi Everyone I want to save my report as excel file on the user computer with a click of a button. I have tried this code: Private Sub Cmd_ReporttoExcel_Click() DoCmd.OutputTo acOutputReport, "Gastrolog Report", acFormatXLS, "C:\Users\XX\Documents" & Format(Date, "yyyymmdd") & ".xls" End Sub...

Hello everyone I am using packaging wizard for access 2007 to distribute an application, in which I am asked to fill registry keys. What are these registry keys for? Do I need to enter it or can I ignore it? many thanks

Hi there Apart from moving it to another computer I have checked rest of the bits and everything is fine, I am gonna sell it as runtime package with both front and back end in that package attached, and MDE converted front end, otherwise obviously it wont work without backend on other computer...

Hi how can I sell access application online, I have not got any EULA or copyright of this access application, so I need the advice from scratch, if someone can suggest please... thanks

Hi Can someone provide sample EULA for access application distributaion? thanks

Hello everyone I need some suggestion regarding security of my application, its basically a simple database entry for surgeons to enter their operations, conferences, presentations etc. How can I add some securtiy measure for the user so that the user himself can only use the application. Is...

I am new to SQL. I have designed an application on access 2007. The design process is complete now, it includes around 32 tables and 20 forms with 10 reports etc, my question is, how can I put this application online for the user to use it online. Is it possible now in some simple steps or do I...

Its working ..:))

I thought about it earlier, and I also think thats the way ahead. So what do you suggest? Shall I make 5 different queries , each of Surgeon detail and one other table like conference, publication etc and reports of each query and then make subreport in one main report?

yeah I have tried a lot to play with grouping, if you see the other report operation list I have arranged well but this one is nightmare, I have been trying to sort out the grouping only since yesterday but its not working by any means. I had designed the operation list in access 2003 which was...

Hi What I am trying to show on the protfolio is something like this: Surgeon details Name DOB Medical college Name of hopital ------------------------------------------------------------------ Conferences Date started Date ended Name of conference Type 1...

Hi there I have attached the application after doing what you have said. When I am running that query there is a problem, that if I add more than one set of data in one table eg. in conferences - if I have added 3 conference details and if I have added only one set of data in other tables, the...

Ok, the query in question is Portfolio and main table is Personal details, and other tables are Conferences, courses, publications, presentations, and research. thanks

Hi everyone I am trying to make a report from a query. The query which I have made contains several tables, the main table which is personaldetails is related to 5 other tables each by one-many relationship. So if I am using one main and one other table only in query then the query is populating...