Search results

Hi, I am trying to use multiple ApplyFilter actions on a table but if one of them takes affect the rest do not take affect. I am unable to combine all criteria in the where condition due to the 255 character limit. How can I combine the ApplyFilter macros to include all my filter criteria...

Hi, I am new at MS Access and with hit and try I was able to create a report in access. The report has around 15 columns and around 1000 rows. The data in some of the columns is the same. What I mean is that, for example, column 1 is "Division" and has around 200 rows each of the 5 divisions...

Hi, So I have a macro in excel which imports data from the excel sheet to a table in access db. Now the excel file has 4 columns which have dates. - I imported the excel file from access via access so that I can get the heading of the table and the table is created. Then I deleted all the...

Hi, I am still in the learning phase of MS Access. Would really appreciate your help with the below three things. 1. I have a report with around 20 columns. The report breaks in a number of pages when viewed in such a way that the half the columns of rows are on one page and half the columns...

Hi, I am new to Microsoft Access and would really appreciate your help on report. I have somehow managed to make a database in Access. Now I want to create a report form for the user. Basically whenever the user clicks on the report, he should be able to view the updated report from the access...

Hi, I have a excel file and want a button in the sheet which would transfer a certain range of data in a defined excel sheet to an existing access db table. How to do about doing that. Please help. I am new to this.

Hi, I am working on a project where I need to upload selected data from multiple sheets of an excel file. Here is an example of what I want. 1. I want to create a table in Access with around 10 columns 2. Column 1 should be populated with the date field found in A2 cell of sheet 1 of the excel...