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

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

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

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

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

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

When i converted an Access97 db to 2000db, a macro which i created to requery records in a subform datasheet is not working. Am getting the error message "you can't use apply filter action on this window". The subform datasheet gets its value as a result of filtering. Then i had given "requery"...

I have an Area filter (combo box) on a form. The records in the form are displayed only after applying the filter. MY problem is after applying an area filter, if the user want to adds a new record, then Area Text Box on the form should begin with the same area code in the combo box. Is it...

Hello Everybody, I have a report with several records. What i want to do is strike out the record if a certain condition is met. What i had done is, i kept a line with visible property set to NO and make this line visible if the condition is met. The problem is i have a remarks column whose...

I have a form which opens with Filters, Additions, Deletions, Edits and Data Entry Properties all set to Yes. I have an Area Filter and Sub Area Filter Combo Box on the same which applies Filters to the Form. I also have a Delete Record button on the same form which intends to delete the record...

Hello Everybody, It is very urgent. I have a report with a text box(say TXT)in the DETAIL Section. This text box gets it values as a result of a Calculation. I Want the SUM of the TextBox values in the Group Footer of the Report. I did give criteria =Sum([TXT])in the Report Group Footer, but i...

Hi, Any one knows how to change the mouse pointer to a new shape when it moves over a command button in Access. I did manage to get the API code from Dev Ashish's site, but not sure how to use it. Also found an article on Mouspointer property in help menu. I checked the properties of the...

I am fed up with the problem of how to select a printer when trying to print a report. What i want to do is click a command button which prompts me for print dialog box from print preview of a report. I created a macro which when runs prompts me for the Print dialog box. But i don't find any way...

Hi, Could any one tell or suggest how to read a text file in Access. I want Access to open the text file and read it automatically into a table. Any help will be appreciated. Regards, Charley

Hi, Could any one tell me how to check whether a table exists before running a macro? ie if the table exists don't run the macro else run the macro. Regards, Charley