Hi there, Below is the scenario… I have existing tables and forms in Microsoft Access. Whenever the user modifies a field in a particular table, I want to transfer that data over to Navision to create a new journal line. This is relatively new to me and base on my research findings, it is possible to this by using ODBC but it’s not really reccomended. Please correct me if I’m wrong. I’ve also heard that you can use VBA as a solution. However it has been rather difficult for me to find any references on this. If anyone knows of a better solution or where I can get more information on ODBC and VBA to integrate Msft Access to Navision that would be great… Thanks!! Regards, Ally
VBA can be done through C/FRONT, and is a good solid way of accessing Navision. You will need to create a VB wrapper around the C/Front interface, written in C++. If you search this site using keywords “VB wrapper and C/FRONT” you should find what you are looking for. On that, is there anyone out there that has a Wrapper that they are selling as an AddOn?
If I remember, C/FRONT (or C/ODBC) doesn’t allow for field validations. If this is the case, I wouldn’t want to go anywhere near populating a Journal without them. I would probably try to update some temporary table and then allow the Journal lines to be created from the Temporary table from within Navision. On a different note, is C/OCX not available anymore? I looked in 3.70 (quickly) and didn’t see it.
Chris, I am pretty sure Ally realized that, since he says:
quote:
I want to transfer that data over to Navision to create a new journal line.
So I think he is aware that he needs to transfer the data over to Navision and then create the Journal in Navision using validates. (If he didn’t then he does now).
quote:
Chris, I am pretty sure Ally realized that, since he says:quote:
I want to transfer that data over to Navision to create a new journal line.So I think he is aware that he needs to transfer the data over to Navision and then create the Journal in Navision using validates. (If he didn’t then he does now).
Originally posted by David Singleton - 2005 Jun 27 : 09:06:59
It makes sense after a few cups of coffee. [8)] I read it the same way as you do now…Oh well.[Oops!]
better be sure though, he could do some serious damage if he was not sure.
Hi David, I just noticed you referring to Ally as ‘HE’ and on checking the profile it turned out to be a ‘SHE’. No offences meant. Just for your general info…[:)] Regards,
[:I] sorry Ally [:I]
Hi vijay… thanks for noticing… hehehehehe… but it’s ok… never been refered to a guy with this nick before tho… Thanks for the advice guys… am doin some research at the moment on C/FRONT and VB because this is all new to me… But could someone please explain to me what is a VB Wrapper Class, it’s purpose and how should I use it? Also does this mean that I will have to create some codes in Access using VBA or VB to pull out the data from access and then use C/FRONT to get this information and pump in the data into a table in Navision first. After that use a dataport to pump in the data into journal? Please correct me if I’m wrong… thanks once again… [:D]
Oops sorry I meant Vinay…[:I]
A wrapper is just a library of function calls. You write them in C++ to call C/FRONT librarys, but format the output so that VB can then call these functions. All it really does is makes the C/FRONT library look like VB so that you can call the functions.
Why don’t you try it the other way? Why dont you access MS Access from navision? Regards Omair
Hi Omair, Is it possible? Please give a few tips as how. Thanks in advance.