Search results

Awesome! ^:)^

GolferGuy, Hit the right mark! amazing. Thanks a lot. Now I just have to figure out how to get the "OldestDate" to start automatically a year behind the current date (not manually coded). Cheers!

Sorry for the confusion, what I intend to ask is: If I want the combo box to populate every week of the months for the last year up to the end of the year. Pls. see visual refference below: Combo box value: 01/01/2007 - 01/07/2007 01/08/2007 - 01/14/2007 ... 12/31/2008 - 01/07/2008 ...

WOW! ^:)^ Just what I needed, works 100% PERFECT! ^:)^ Just a quick note, how do I get the exact week on the combo box? meaning not based on the records. And another one, how do I design a query based on this value? Thanks again!

Hi Ron K, Tried the code but have this error. Thanks.

Hi Jon, Thanks for the sugestion, I have tried that approach, but the thing is that I want to filter the Date From & To based on the selected EmpCode thats why on the AfterUpdate event on the attached file I have to set the value for the below combo boxes. Thanks for the input.

Hi All, I have attached a file which I need a help from, I need the subform to be populated based only on the Employee Code and the Dates where the employee logged-in a Job Order. I dont have any code on the cmd button for I am lost on what will be the query statement to update the subform...

I do want the the last week on the combo box, below is the visual example I want to do with the box 12/31/07 - 01/06/08 01/07/08 - 01/13/08 01/20/08 - 01/20/08 01/21/08 - 01/27/08 Assuming that the first date field has the value of 12/31/07 and the last was 01/27/08, eventually as the data...

Hi GolferGuy, Originally, I wanted a combo box based on the starting date on one field of the table I have then increment it until the last date entry. It was done perfectly (since I just bound the "Starting Date From" & "End Date To" to the Date field I had on the table. But, upon deploying...

Hi, I am in need of help regarding the current application I am doing, I have a weekly report tab whereas a user can query his/her weekly accomplished projects, the problem is that I want a combo box to populate with weekly dates within a year, so that the user only select his/her ID and then...

Sweet! Just what I needed! Thanks a lot!

Hi all, I would like to seek some guidance regarding the customization of the control box, I do have a working close button (I just made a transparent cmd button then place it at the back of an image...a dumb approach but it works) now I want to create a minimize & maximize button but can't...

Hi Uncle Gizmo, Thanks for the links you provided, but my problem is the other way around, pls. check the .mdb for details: Problems: 1. When you add a record on the data entry, you have the capability of adding new clients when you dblclik the "Client's combo", now when I hit the exit button...

Hi Guys, I saw once this thread regarding passing parameters to an open form another form, but now can't seem to find it. Can someone post the link on this one? I have a form that when a user dblclick a control opens a form for data entry, what I want is after the user enters the new data that...

Hi guys, I've searched the cascading form but didn't get the result I wanted to happen, I tried changing the row source bu no luck, can someone give me a working example based on the info I provided. I really appreciate all your input. Thanks

Hi guys, I have a form with the following controls: Control Name: cboEmpName Source: Employee Control Name: cboCustomer Source: Customer Control Name: cboJobOrderNo Source: JobOrder Control Name: lstRecordShow Source: Employee Now the problem, I wanted to only show on the...

Thanks Banana, works perfect! Cheers!

Hi Banana, Thanks for this info. I will try it later. :)

Hi Folks, I gave up using Grid on my project :(, so I decided to use the ListBox instead, it works fine but now I'm stucked....AGAIN..... I wanted to select a record from the ListBox so I can put it on my unbound fields for the user to view or even edit, but can't figure out how :( I've tried...

Hi Banana, Thanks for your time & your help, attached is the graphics concept that I was planning to implement.