Search results

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

'API: Displaying a custom Mouse icon 'Access allows us to display specific mouse 'pointers by controlling the MousePointer 'property of the Application object. 'However, it does not have the hand pointer '(for example) pre-defined. 'Given a local ICO (icon) file, we can 'assign it to the...

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

Did you manage to find the solution? If so could you please let me also know. Regards Charley

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

Could any one suggest me how to run an Excel Macro from Access 97?