Search results

Hi Experts, I just a built a crosstab query by month and business line. I wanted to set a parameter under Business Line. I was having problems with that until I read somewhere that to use crosstab queries with parameters you need to define the parameter first on the query menu. I did that and...

Hi experts, I have an access database with multiple queries. I am trying to make a connection between the database and Excel. I am using the "Get External Data" option in the ribbon and selecting "From Access". After selecting the database, I select the query and select to export as a table. I...

Hi Experts, I have a quick question. I am building a Database for work (I work in a bank). So far, the database consist of the following tables: - tbl_Sales Rep - tbl_Client - tbl_Accounts (this could be considered “Products” table) -...

Hi experts, I just created a database and need help connecting it to the data source. The data comes from a http website (intranet from work). When I open the link using firefox, I can view the website with the data in it, but when I open it from Internet Explorer, I get a save as pop-up...

Hi Experts, I was wondering if any of you can provide some assistance to do the following: I want to create a Macro saves the report in a specific location, and uses two fields within the report to generate the name of the file. For example, "[Sales Rep Name] + [PayPeriod].pdf" and it should be...

Hi experts, I am new to this forum. My skills in excel and access are pretty decent. I am a financial analyst and would like to take it to the next level. I am looking to learn VBA. I have been reading some books and know the basics. I have even joined lynda.com to learn more about VBA but...