Search results

That's it :) What I'd like to do exactly matches with that solution. Capability of running on network is great! I appreciate if you share it. I dont know anything about editing registry so pls give some details about your solution. @ghudson thanks a lot, this is quite simple yet effective...

@WindSailor Thanks for the links, KeyedAccess seems to be a nice add-in but it's quite expensive. @ghudson That putting a "special" file on a disk is nice idea. At least they cannot run the database without my permission. I couldnt find such an install routine in your posts. Could you pls...

Hi there, I have built a Access solution for a music school, It was installed on 3 machines. I'd like to protect my database from installing onto another machine without my permission. I did install database as a mde file so they cannot see my codes. However, if they copy the database to...

Hi, I have searched the forum and some other sites to find a solution that exactly matches what I want but since I know very little about VBA I couldnt come up with a solution. Here is my problem: I have an Access 2003 database, which contains student informations in table named tblStudent...

thanks for the link Lucas but I still couldnt fix the problem. I dont konw what the reason is. Crosstab query shows the results that I want but the report based on that query still doesnt work.

I am trying to solve this problem over 4 hours but still cant find a way. Please help me! There are 2 tables,tblStudent and tblPayment and these are the field names. tblStudent:id, namesurname, groupno tblPayment: id, amountpayed, paymentdate, monthpayed and payed Montpayed is the name of the...

Hi, While searching for a free datepicker activex control I found the following control. It also allows null value. I found it quite useful and it's free http://spazioinwind.libero.it/vbprogzone/activex/downloads/cal2.zip regards edit: copy the shortcut on a new browser otherwise it gives an...

thanks a lot

Hi, Is there any way to customize append query confirmation message? Unclicking Confirm Tools-->Options-->Edit/Find-->Confirm-Action Queries disables all warning messages. My query takes some records from one table and append them to another table. When I run the query, first warning message...

Thank you very much Jon K. I wanna hug you :)

@Jon K The report in the first sample was well organized. Sorry to bother you but how can I prepare the same thing as a form? For example when user choose the daterange from the combo box, records belong to that range appear on the form with their total. I know that this is a form question but...

Yes, It requires some extra work. Actually Jon K's first sample was enough for me (thanks again) and 2nd sample gave me another sight. Microsoft KB page includes a function which is quite useful according to my needs . Some people working with accounting databases may find it useful too. This is...

I found the following page on Microsoft site. I should do more searches before asking questions :( Although some kind guys always help . http://support.microsoft.com/kb/132101/EN-US/

this is outstanding :eek: I need to learn a lot about date related functions. thanks a lot man :)

Thanks a lot Jon, you made my day :) I appreciate your time, your help for building the sample. Thanks thanks thanks. But I wonder whether or not that can be achieved by using Day(), Month() or another command and without using another table to hold date ranges. Date range is always be one of...

Hi, This is my first message. Here is my question: I have one table named Expenses. There are 3 fields in that table, namely, Expense_ No, Amount and Date. There are many records in that table that show the expenses made throughout the year. I would like to group those expenses according to...