acces

Hi all, I've got an authorization issue with publishing PowerBI reports to sharepoint. As soon as i publish a PowerBI report on my sharepoint page, everyone with acces to my "report" sharepoint page and with a powerbi license has acces to that report. I want the authorization based on my...

Hi I made a custom tab on the ribbon. There is a way to get the status of the checkbox ? Can i acces the checkbox by it's name ?

I would like write a program in excel with VBA which can upload an acces database from the same already uploaded excel sheet. I'm trying to use SQL statements, but I think it cause a problem because i have already checked the connection and it's connect to a database. Can you help me how to fix...

Hi ! I'm looking for a solution to block a 20.worksheets.workbook acces if the user dont activate is macro first. And after activation then he will see and have acces to the full workbook.. ? Any solutions ? Thank you very much and have a great day! Steve

Hello, I have created a database that I would like to put on a schedule to send out every day without manual intervention. I have seen a lot of posts from various websites about using Windows Task Scheduler. I cannot figure out how to use the Windows Task Scheduler. I was coming here either for...

Hi all, I hope you can help me to extract a new data table with all the fields from the attached product order data, using Access SQL or Access Design View. Please note each ID has one (ID 16) or more quotes (ID 13) and the quotes within an ID can be the same (A1) or different (A2-A4) but each...

I have a list where I have banks name. Every time I select a bank from the drop down list, I would like a prepoulate cell values automatically like for example below: Any help is really appreciat <colgroup><col style="width: 31pt; mso-width-source: userset; mso-width-alt: 1499;" width="41">...

Hi - I am looking to create 10 rages for a data set I have where each range will have an equal number of values in the range. Is there a function to do this in Access that is not too complicated? Thanks! David

I'm sending out a form to users from Access 2007 using External Data -> Collect Data -> Create Email. This process creates an ugly form with a bunch of filler text that I don't like. I don't see anywhere to change or delete this text, or change the default email form. All I can do is change the...

Hej there, I'm on this forum for about 2 weeks now. Busy with Excel Userform trying to get it done! And thanks to the people here it looks lovely and it works.. But... I have a problem! When 2 or more people simultaneously open my Useform, fill it in. And then save it, it will give...