Search results

Great. Thanks!

Thank you for your help. Your example works, but the problem is that I get too long a list of employees (about 200). Is it possible to get key stroke filtering by name, eg. if I type the letter J (John) and get a list of those that start with J, or some other letter. Do you know is it possible...

Hello, I would like to make a search box and update my form with the person's data from the search box. Can anybody help me with it?

Thanks for your input pr2-eugin. I've created a macro that finds workeers who have a birthdays in seven days and with help of AutoExec sends automatically a mail once a week. But because I do not know how often the application will be opened, I want to know how can I start the macro by using the...

Yes, it is point 3. I would like to list up all employers that have a birthday in 7 days and send an email to a particular person(the boss) about it. I am not an expert in vba but I think I can find it out with some helps.

Hello, how can I make that my access send an email to a user if there 7 days until en employee’s birthday. Can anyone help me with this one? Perhaps there is someone who already har an example.

I have Access 2007.

I want a button on the report, not on the form. A button that lists up all birthdays from next months. Is it possible to do on the report? Maybe with an macro! Something like this procedure: -update birthdays on the report view with next months birthdays. -change months name on the reports head.

Thank you. Now, I would like to have a "next" button on my report, which can switch to the next month (eg. August-September). How can I update data in an report with the new data by clicking on the button with your sql behind?

Hello, I have an birthday report for the current month (august) and would like to make a button on the report that can calculate next month (september) and shows birthdays for that month. Can somebody help me how to calculate next month?

How can I close database if I click on the small close cross in the upper right top corner on my logon form?

I have a form with several tabs and I don't want to give permission for some users on some tabs. How can I do it? Has anybody some ideas, maybe some codes?

Thanks for your help, the problem was that the username and password should be unbound. But when I open my database I get logon form to appears automatically, but I see that it is also possible to open other forms, regardless of the logon. Is there a way to protect other forms, when the person...

I have a logon form that always contains a value in the user name and password fields. How can I do it that these two fields are empty when the logon form is displayed? When I put this code in a program text12.value="" then it delete user name in database.

It's working. Thank you for help.

I'm sorry for the misunderstanding. I explain it again. The problem is, when I tryed to sort report list based on birthdays dato, then I get a list sorted on the basis of year. Because of that I made a couple of new fields in my query, like BDay: Day([Birthday]), BMonth: Month([Birthday])...

I have designed tre more fields in my query, BDay, BMonth and BYear. But how can I define BDay and BMonth to have to digit.

I get sorted list when I run Sql query, but when I open a report based on that query, it doesn't sort it after the day, but still sorted after the year. It seems like I miss something.

I get wrong sorting based on year of birth. I want to sort it on the day and month. Any ideas?

I made an sql that shows workers birthday and sort it after the date. But when I try it in my report, it doesn't sort it. What's the problem here?