Click here to Skip to main content
15,867,330 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Adding two numbers together? Pin
MallardsReach26-Jan-18 10:07
MallardsReach26-Jan-18 10:07 
GeneralRe: Adding two numbers together? Pin
Eddy Vluggen26-Jan-18 11:27
professionalEddy Vluggen26-Jan-18 11:27 
QuestionMaking software, that counts your fold count in a row (PokerStars). Pin
Krišjānis Strods22-Jan-18 15:05
Krišjānis Strods22-Jan-18 15:05 
QuestionInstalling mysql silently and configure mysql using Pin
Osioghole Clifford19-Jan-18 16:23
Osioghole Clifford19-Jan-18 16:23 
GeneralRe: Installing mysql silently and configure mysql using Pin
PIEBALDconsult19-Jan-18 16:49
mvePIEBALDconsult19-Jan-18 16:49 
Questionhow can i create a vb project to glow the light of logic gate output? Pin
Member 1362988617-Jan-18 23:14
Member 1362988617-Jan-18 23:14 
AnswerRe: how can i create a vb project to glow the light of logic gate output? Pin
Richard MacCutchan17-Jan-18 23:34
mveRichard MacCutchan17-Jan-18 23:34 
QuestionHow to reference MS Access 2016 for use with DoCmd, etc. Pin
Johan Hakkesteegt12-Jan-18 3:20
Johan Hakkesteegt12-Jan-18 3:20 
Hi,

I have a couple of windows applications that use MS Access to print reports. They were built on MS Access 2007, and worked fine until I was forced to upgrade to Office365 and thus MS Access 2016. Unfortunately (apparently) Office365's version of Office 2016 does not allow you to have other Office versions installed, so I had to remove my Access 2007 version.

The simplified version of my code that worked fine until now:
VB
Dim oAccess As Access.Application
Dim x As Long
AccessExecutablePath = New FileInfo("C:\Program Files\Microsoft Office\root\Office16\MSACCESS.EXE").FullName
x = Shell(AccessExecutablePath & " " & Chr(34) & DatabasePath & Chr(34) & "  /runtime", AppWinStyle.MinimizedNoFocus)
oAccess = New Access.Application
oAccess = GetObject(DatabasePath)
oAccess.PrintReport("Some_Report_Saved_In_MSACCESS")

Apparently when you install Office 2016, it no longer has the necessary interop driver for Access, and the code no longer works.
However, all microsoft's (I suppose outdated) documentation still says to use the code above.

Here is my question:
Has anyone else faced this issue, and more importantly can anyone suggest a solution, or another method to interact with the Access client?

Regards,
Johan
My advice is free, and you may get what you paid for.

AnswerRe: How to reference MS Access 2016 for use with DoCmd, etc. Pin
Richard Deeming12-Jan-18 3:38
mveRichard Deeming12-Jan-18 3:38 
GeneralRe: How to reference MS Access 2016 for use with DoCmd, etc. Pin
Johan Hakkesteegt14-Jan-18 20:20
Johan Hakkesteegt14-Jan-18 20:20 
GeneralRe: How to reference MS Access 2016 for use with DoCmd, etc. Pin
Richard Deeming15-Jan-18 7:50
mveRichard Deeming15-Jan-18 7:50 
GeneralRe: How to reference MS Access 2016 for use with DoCmd, etc. Pin
Johan Hakkesteegt15-Jan-18 20:08
Johan Hakkesteegt15-Jan-18 20:08 
GeneralRe: How to reference MS Access 2016 for use with DoCmd, etc. Pin
Johan Hakkesteegt16-Jan-18 3:52
Johan Hakkesteegt16-Jan-18 3:52 
GeneralRe: How to reference MS Access 2016 for use with DoCmd, etc. Pin
Mycroft Holmes16-Jan-18 20:23
professionalMycroft Holmes16-Jan-18 20:23 
GeneralRe: How to reference MS Access 2016 for use with DoCmd, etc. Pin
Johan Hakkesteegt16-Jan-18 21:02
Johan Hakkesteegt16-Jan-18 21:02 
AnswerRe: How to reference MS Access 2016 for use with DoCmd, etc. Pin
Ash_savvy2-Feb-18 18:30
Ash_savvy2-Feb-18 18:30 
QuestionCan you include properties from a common class (Solved) Pin
mo14929-Jan-18 3:25
mo14929-Jan-18 3:25 
QuestionNeed help with date to date calculation of a total of different rows Pin
mokhtar_one5-Jan-18 23:39
mokhtar_one5-Jan-18 23:39 
QuestionRe: Need help with date to date calculation of a total of different rows Pin
Maciej Los8-Jan-18 7:11
mveMaciej Los8-Jan-18 7:11 
AnswerRe: Need help with date to date calculation of a total of different rows Pin
mokhtar_one8-Jan-18 22:30
mokhtar_one8-Jan-18 22:30 
AnswerRe: Need help with date to date calculation of a total of different rows Pin
Maciej Los8-Jan-18 22:43
mveMaciej Los8-Jan-18 22:43 
GeneralRe: Need help with date to date calculation of a total of different rows Pin
A_Griffin8-Jan-18 23:05
A_Griffin8-Jan-18 23:05 
GeneralRe: Need help with date to date calculation of a total of different rows Pin
Dave Kreskowiak9-Jan-18 2:47
mveDave Kreskowiak9-Jan-18 2:47 
PraiseRe: Need help with date to date calculation of a total of different rows Pin
Maciej Los9-Jan-18 4:47
mveMaciej Los9-Jan-18 4:47 
GeneralRe: Need help with date to date calculation of a total of different rows Pin
Maciej Los9-Jan-18 5:07
mveMaciej Los9-Jan-18 5:07 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.