Search results

thank you so much! it does work now. Do you have any idea why it wasn't working? Just want to know in case I want to do something similar in the future. thanks again!

I had tried that before. But I saved the file when I had made changes. I have made your suggested changes to the database and it is still not working. I get a promt error message. I have attached a couple of images. Thanks again

here it is. Thanks

Yes. I am not sure how to send you the Db though. How do I post it? Sorry I'm new at this form. it says invalid post when i try to attach it...

Hi Pbaldy, Yes. I have double checked. I actually copy it from the builder. I went to builder - forms, selected the object and the whole name was Forms![Test]![cmb_Business_Line_1] Is it possible to set a parameter on a form for crosstab queries?

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

Guys, This is just a database that I am building for data analysis on a small project. It has nothing to do with data management of the company/or even data analytics, nor managing accounts. Can you please help me by replying to my question? Thanks.

I am almost sure it has to do with a Many to Many relationship. But I don't know how to structure it.

Ok I think I should’ve put more details. I have 3 tables and all of them are related. tbl_SalesRep tbl_Client (linked to tbl_SalesRep) tbl_Account (linked to tbl_Client) Let’s say that at the beginning of the year I have the following data: tbl_SalesRep has the...

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 to all. Thank you very much for your replies. I really appreciate the responds. I will definitely use them to start learning. Uncle Gizmo, thanks. I will give you feedback as soon as I get a chance to review them. Question, if I have a specific question, asking for VBA coding for a...

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