Search results

  1. J

    Report appearance changes for multiple users

    Dear saviors, Have successfully created a module & Report for my project with all your support. but surprising the report seems to be disorientedly generated for some of my colleagues in their machine.. the design view shows in a different scale and size than my original report design what...
  2. J

    Solved row count for multiple groups

    HI friends i have prepared my report for display wherein i have made 3groups (groups within group) now when i use row count , the row counts for the last subgroup. i would need the row count to display of each of my group.. is there a way to do it. My report has these groups Main group: group...
  3. J

    Generate error report / table

    dear saviours out there.. I have created a form to import excel data into my database table - its perfectly working I have set a condition for my database table column - Eg. Tagnumber should not be null value when I upload the excel file - the records where Tagnumber is empty -doesnot get...
  4. J

    secure the database & query design

    Hello savior over there I have done a project and with our forums lots of support I was able to complete it But now I have a challenge before me- how to protect the project so that its source programming/query designs could not be revealed to others. As simple I would like to LOCK my backend...
  5. J

    Solved Generate error mesage for import errors

    Hello saviors.. I'm importing tables into my access database by a user form however I understand there are some errors -Type Conversion Failure these errors are stored in a new table without my knowledge - I mean without any error prompt Can you please suggest a code to pop an error message If...
  6. J

    Solved Add pdf file as attachment in Form

    dear all I am in need to attach a Note file(pdf) or say a guideline document for my project in the MAIN FORM . the attachment is not a part of any table or query..i want it a kind of embedded file which opens upon clicking
  7. J

    Group wise page number & overall page number

    dear lifesavers. I have generated a 1000 page report with page numbers (say page x of y) I have multiple groups within this report(each grouped & sorted) - say group A, group B and so on I would like to have a section wise page number (say for section A, page nos be like A1 of A100) in...
  8. J

    Solved Insert Blank pages (seperator sheet) in report

    Hello lifesavers.. I have generated a report for the list of enrolled students in a college successfully.. I have grouped the results based on category of enrollment Eg, Mechanical, Civil, Electrical, computer science, electronics and so on.. results are coming properly.. what I would require...
  9. J

    Conditional basis "LINE"

    dear all is there a way we can insert the LINE object in the report based on condition?? any suggestion will be of great help
  10. J

    Text Box size -Reg

    dear friends... Im using the PIPELINE symbol (|)in my report one below other - so that in a report it will look like a continued line..(silly idea but it works to a level) the problem is I see som extra spaces above the text which I could not remove by minimizing the text box size. see the below...
  11. J

    Solved finding the last record of each group

    dear friends im in a situation here. I am furnishing the query result in a report and its grouped (say one group per page) under every group of the report I need to highlight/indicate the last record...say with a remark / special note can any one throw your thoughts to achieve the same...
  12. J

    Validate input table uploaded

    Hi friends I have a form to upload my excel file in to a table. (selecting the file by "msoFileDialogFilePicker" & then doing "DoCmd.TransferSpreadsheet") normally the file gets uploaded. But I need to check if any of the cells in the uploaded file is empty (while uploading). and if possible...
  13. J

    Textbox control giving #error in a report

    I have two reports for my project im trying to place a username in the report surprisingly the second report accepets the username and displays properly in the report, whereas the first one is giving #error. pretty confused. appreiciate your help whereas the second form its working properly...
Top Bottom