We help IT Professionals succeed at work.
Troubleshooting Question

If I create a Microsoft Access Form connecting it to a SQL Database how easy or hard is it to ....

46 Views
Last Modified: 2020-11-03
...... Convert the Access form to a Sharepoint form (tool) so that users can access the form and I can run reports off of it with my SSRS Server. Here is the form Report Request Form.xlsx 

If it can be done. Are there any key things like a checklist of things links of how to anything I must have in order to do this?

I want to convert the idea into an form easily accessible so that users can launch, enter their requirements and most importantly WE force the requestors to put all critical values needed for the report. If we don't do this we get constant back and forths wasting precious time. Users take us for granted. "Thinking we can read minds." We can actually, but we don't want them to know that. LOL!

On another note, if anyone has any experience on how to manage a modification "REPORT CHANGE  REQUESTS" to an existing report form I am open to suggestions. 
Comment
Watch Question

Anders Ebro (Microsoft MVP)Microsoft Developer
CERTIFIED EXPERT
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
CERTIFIED EXPERT
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
RUA Volunteer2?Crystal Reports Tableau Developer Trainer Consultant Sales Exec.

Author

Commented:
Hankwembo Christopher, Still learning what a FE & BE are? Is that FE = Form Edits or Form Editor and BE Database Engine ?
One problem is I do not know if all users have access to MS ACCESS FORMS on the desktop I do think they can see sharepoint stuff.
Another problem is I do not have access to the sharepoint server another team does. (we have hundreds of report requestors.) I was looking for the easiest way to give the users access to a form. Is there a way can build this form in a local copy of sharepoint and hand it to the team ready to go? Maybe if I download and install a trial or free copy of some tool maybe I can get this started and hand it off to let the other guys connect it all up....?
I guess on another note since I myself have development tools from SSIS and Visual Studio could the forms be made there or is the GUI more of code based interface where I would need more development experience vs the simple MS Access drag and drop interface style of form building...?
John TsioumprisIT Supervisor
CERTIFIED EXPERT
Distinguished Expert 2019
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
Infotrakker Software
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions