Could anyone provide me with the proper code to connect and supply data to my access database form?
I would like to be able to enter information into a text box on the form and run a command button to fill in the rest of the fields.
Currently we are using Vantage 6.10 by Epicor running on Progress 9.1
D. We currently have ODBC configured and working. The text boxes would equal the fields from vantage.
My connetion:
Driver = MERANT 3.60 32-BIT Progress SQL92 v9.1D
System DSN
DSN = vantage
Host Name = vtg2003
Port Number = 6150
Database Name = mfgsys
User ID = My user ID
Password = My Password
Example of vantage table:
Table name: Pub.Customer
Field Names: Customer.CustNum, Customer.Name, Customer.Address1, Customer.Address2, Customer.Address3, Customer.City, Customer.State, Customer.Zip, Customer.Country, Customer.PhoneNum, Customer.FaxNum, Customer.EmailAddress
I have been struggling with information from other sites trying to figure out the connection string and record source and what method I should use ADO or DOA.
Any help would be greatly appreciated
Thank you
Dave
I would like to be able to enter information into a text box on the form and run a command button to fill in the rest of the fields.
Currently we are using Vantage 6.10 by Epicor running on Progress 9.1
D. We currently have ODBC configured and working. The text boxes would equal the fields from vantage.
My connetion:
Driver = MERANT 3.60 32-BIT Progress SQL92 v9.1D
System DSN
DSN = vantage
Host Name = vtg2003
Port Number = 6150
Database Name = mfgsys
User ID = My user ID
Password = My Password
Example of vantage table:
Table name: Pub.Customer
Field Names: Customer.CustNum, Customer.Name, Customer.Address1, Customer.Address2, Customer.Address3, Customer.City, Customer.State, Customer.Zip, Customer.Country, Customer.PhoneNum, Customer.FaxNum, Customer.EmailAddress
I have been struggling with information from other sites trying to figure out the connection string and record source and what method I should use ADO or DOA.
Any help would be greatly appreciated
Thank you
Dave