Search results

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...

can someone tell me why my "Unmatched Query" results are not showing correctly though there are unmatched records? Am trying to find the unmatched records between 2 queries, say "MTOSelect" query and "SPECSelect" query. Am using the expression Check1 and Check2 in both the queries for...

Hi, I have a Cost Revenue report which attached alongwith and is working fine right now. Am grouping the Cost Categories and summing it up. But my client wants the report to be printed out with some changes only in the Budget Amount column. Change1 ----------- "Budget Amount" for Cost...

I confused you I think i confused you. I will make it simple. I don't want to add or concatenate. I want the last 2 columns of query2 appear at the end of query1. I saved both the queries as tables in my attachment. Regards, Charley

Hi, I have 2 queries with the same fields except the last 2 columns. If i want to build a 3rd query which also shows the last 2 columns of each of the queries, how to do that. I have included an attachment showing the query fields look like. If i want to build query3 which apart from showing...

I want to show project detail records in a report whcih satisfies a certain condition. At the end of the report i want to show the records which don't satisfy the same condition. I tried creating a separate report for showing the records which don't satisfy the condition and then inserting it...