Search results

respect. In fact I didn't realize that my question was that complicated. I guess I will have to procceed without this solution unless someone may be so kind to assist. thanks anyway. :)

Thanks for your interest. I attach a sample of my database. I'll try to explain a bit more what I want to do. As you can see when you select a project you may see the phases that had run. Each phase starts only after the previous had been finished. And then I check with "Complete" and I add the...

Hi ! I need once more your kind assistance to the following issue. I have a continuus subform with 2 comboboxes, one is: cboPhases and the other: cboStatus. The first combo takes values from a table named "Phases" and holds one column with the 9 phases of a project: phase 1_Review, phase...

About this, can someone guide me how to build a report that insted of year calendar of each employee show monthly results for all employees. Thanks in advance

Thanks !!!

Hi all! I found the attached sample which is very usefull but I want to change it a bit so to select a date range directly on a query by choosing the dates on the form, instead of a report. Can someone please assist me ?

Very much! First thing in the morning working to implement it to my current database. Thanks again, pal. Good job.

YES!!!! Your are absolutely right!! Some changes and works perfect. I feel such a stupid not to think it at first since it is an issue i had again in the past. Many thanks for the hint and also many thanks to the friend who shared this very useful sample. My respect!!

Very very strange. :confused:

I downloaded the link you provided above and that works for you. No luck :(:( There is a dll in the file that after I extract to where all other dll files are I cannon locate it :eek:. Is this has anything to do with my issue maybe ?

That is indeed very strange because I cannot make it work whatever I do. :(. It works perfect from the 13th day of the month and forward. For some reason that I don't understand it counts the first 12 days as months. Is there anything I should do and I didn't so it runs smoothly? :confused:

Hi! I tried this sample and I noticed something weird. For the days 1 to 12 for each month the input box changes by month and not day by day. It works normaly only after each 15th of month. (I attached a pic so to make clear what I say). Any help on this please? :confused:

Thanks that works:) As you said it doesn't scroll down but i can solve this by drag the listbox so to show more dates. Many thanks again :):)

Bob Thanks! This seems to solve half of the problem since it does seem to recognize the field as a date field but selects the first date of the list dates and not the today's date. I enclose the database. Maybe that help you. thanks again

Wayne, thank you very much for your time spending with this. I am that little close but still have problem. :( I changed the code a bit (red fond) so I managed not to get debug errors but for some weird reason I cannot make it regognize the current date although it does exist in my list. Here...

nope. Still can't make it work. Here is the issues Dim i As Long Dim Found As Boolean Found = False For i = 0 To Me.LstDate.ColumnCount - 1 If I use .Count I get an error debug saying method not found. So I had to change to .ColumnCount but I cant say if this is right or wrong. :(...

Wayne, thanks for your prompt reply. I tried to use the code on the open event of my form and I got various errors. First on the line For i = 0 To Me.YourListBox.Count - 1 says: method not found and If CDate(Me.ListBox.ItemData) = Date Then If I leave Me.ListBox It says : Item not...

Goodevening to all! I need again your kind assistance to my issue below: I have a listbox on a form populated with various dates. I wondering if there is a way when I open the form to setfocus on the listbox to today's date and if current date value does not exist to popup a message asking to...

I had the same issue a couple of weeks before and I didn't realise that is a bug. I thought that it was something I did by mistake. In my case the formatting sign was a "@". I never understood how this ever applied in my table. I got crazy trying to find out why my combo did not show any data...

Βe sure for this. You all are doing a great job and it is respectfull that you share your knowledge with unknown people from all over the world.