Search results

Thanks for hint. By sentence, do you mean that I compare the stored string with the band in the form?

The db is under development and I want to implement something for unlicensed usage before handing them over.

I'll give them either by a downloadable link, CD or email. But the db will most probably be offline when it is used.

Thanks for reply. I'm not a pro in coding. It'll be greatly helpful if some sort of sample db or code is available. I tried to search in Google before posting here but couldn't find any useful.

Hello, I have a question. How do you prevent users of your databases to from unauthorized distribution to other users? For example, you have developed database for a school, how do you prevent its distribution to other schools? Best Regards, Abdullah

Hello again, With the same data, for inserting into report, I want to make a subreport in the format shown below in picture: where columns heading 1,2,3,4... are month no upto 12. I can use cross tab query to generate this data for present, absent and leave (attStatus = 1,2,3 respectively)...

I myself am not good at programming and started using Microsoft Access few month ago. I wanted to generate whole class result with subject names as column header but report generated from a cross tab query have good number of columns and if number of subject for a given class are changed, report...

Hello, I have a report based on a dynamic crosstab query and a button to save the report in PDF format using DoCmd.OutputTo acOutputReport, "rptResult", acFormatPDF, sFileName. If I display or print the report, everything works fine. However, if I create a PDF using aforesaid code, it also...

I didn't know about this. Let me check. Thanks a lot @theDBguy

OK. Thanks for image. But by this method I've to change images on all reports of the i need to replace logo.

Thanks a lot @Pat Hartman. I have used a table to store the grades but method suggested by you and @arnelgp (i.e. table having from and to bounds for a grade and find the grade using query) gave me another method by which I could handle grading of students. I'll check this too. Stay safe and...

Thanks for the db @arnelgp. I have seen the report and module1. It works as I needed. Thanks a lot.

Thanks for reply @theDBguy, subreport could be used... never thought that way. Thanks a lot. By image gallery, you mean my PC image gallery or something else? My purpose is if in future I change the logo, I don't have to change on individual reports. Solution provided by @arnelgp works...

I'm away from PC right now. I'll check it and then let you know. Thanks for the db. Best Regards

There are only two images and I want them to be part of the database.

Never heard of partition query before. I'll check it. Thanks for suggestion.

Hello, I need Insert Logo on all reports. Logo is saved as Attachment in a table. How can I Insert this Logo in my reports. I tried using dlookup in control source of an image field but it didn't work. Best Regards Abdullah

Thanks it worked. I used incorrectly before. Thanks for the assistance.

Same results again. 39.6 is calculated as 40.

Thanks @arnelgp for reply. I tried second code but it stored lngPercentage as 0.4 (instead of 0.396) for input marks 39.6 out of 100. I prefer to use vba instead of query or dlookup as I have written the whole procedure and have to rewrite again to change for min max values. Is it not possible...