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

Thanks a lot June. One last question, I am using an access form to search for a record in the table. My form has multiple combo boxes and a search button. How do I go about adding an event to the button of the form, such that on click it only shows the record that matches the selection in the...

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

Thanks. I looked at it. I think the Transfer Spreadsheet is a macro in Access. I need a macro in Excel so that the user after updating the info in the excel sheet can click a button which would automatically transfer the data to an access table via a macro. The user is not given access to access...

Thanks but I need a button in an excel, which is linked to a macro, that does the same thing.. Could you please help me with the macro..

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.

Sure, thanks a lot. I will look at it and will let you know if I have any questions. Thanks again.

I am using Access 2013. Thanks.

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