Recent content by chthomas

Hi, How can I get a Sheet1, combo box1 value in a cell in Sheet2? Regards, Charley

Hi, I have to plot a graph for project forecast data. Am reaching to a crosstab query and getting lost. The result of the crosstab query is attached as a Table here. Columns titled 11,21,31,41 and 43 are the disciplines. The value in them are the Manhours against each discipline. "Month End"...

Thanks for your help again. Regards, Charley

RuralGuy, I have an extra requirement now. At any time the calendar has to be limited to next 4 months. ie when the user double clicks it should show only May,Jun,Jul and Aug months. When in May month when the user double clicks it should show only Jun,Jul,Aug and Sep months. Is it...

RuralGuy, Excellent. You saved my day. Works perfectly. Thanks a lot Regards, Charley

I have a form where there is a date field. When the user double clicks on the date field, a calendar pops up. This is working fine. Now my problem. I should restrict the user to select only the last day of any month (Am using dsum expression for calculating running totals between 2 dates). How...

JonK, Thanks a million. I was getting lost there. It works. Thanks for sparing your time. Neilg, I need to export this to excel, the reason for using in query. Regards, Charley

Hi, Am attaching a db related to my question I have 2 tables "Summary Table" and "Select1Summary" "Summary Table" shows projects, departments and the available hours for each department eg. In "Summary Table" for 71043-40 Project, there are 1808 hours available at the beginning...

Kerala Try Kerala, India. You people will love the place. http://www.keralatourism.org/

O.K there are 2 solutions. Solution1(easy one) Go to your subform, in design view drag the field list. The only difficulty is that both your fields will appear as combo boxes. Solution2 Subform design view, to the existing query establish relationship to tables tblvendors and...

I hope this helps. Regards, Charley

I downloaded the "audit Trial of record changes" sample by Ghudson. I tried the code in my form. When i do any edit/update am getting an error "2427- You entered an expression that has no value".when i remove an option group in the form the error disappears. Spent hours trying to figure out the...

Is there any code/Module that 1) shoud prompt the user to locate a database say db1 2)once located then automatically import a table say Table1 from db1? This may be simple. But i can't find it even after many searches. Am finding separate codes that accompolish the above separately...

Thanks Doc Man, Thanks. Its a perfect solution in detail. Also it helped me to analyse my own problem. Thak you very much for sparing your valuable time. Regards, charley

Can someone tell me my relationships are correct. Am trying to develop a leave calculation program. The formula is Leave Balance = Previous Year Carry over+ accrued Eligiblilty days + National Holidays Previous Year Carry over is the leave carried over from last year Accured Eligibility days...