Sendkeys Blank Title 58878

Yahoo Archive
1
Great. I'm glad it worked out.

Randall Weber
IT Manager
TLC Electronics, Inc.
651-287-2972
rweber@...


________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Robert Brown
Sent: Tuesday, September 04, 2007 10:32 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Sendkeys



Thanks very much for the example Randy. I just used a modified version
using VBA/Excel and it worked like a charm.

Randy Weber <rweber@...
<mailto:rweber%40tlcelectronics.com> > wrote:
Below is an example of a simple SendKeys routing written in VBA. Someone
familiar with MS Access and VBA should be able to modify this for your
situation. The SendKeys feature works just like it sounds, it activates
an application then sends keystrokes to that application.

No, it is not a complied application. It is simply a module in MS Access
with a couple sub routines. See below.

Randy Weber

Sample code for Visual Basic Sendkeys

Written for Vantage 6.10.525 Part Maintenance screen using an Access
Database as the source data.

Note: This code will not work as is on your screen because we have
changed the field layout.

Using an Access database with a Part table populated with PN, Desc,
PartType (P or M), ProductGroup and PartClass, I created a form based on
the table and a button which runs the following code. The code activates
the Vantage Part Maintenance screen and types in the necessary data to
enter a part number. Then go to next record in access and so on.

Sub AddPart (PN, Desc, PartType, ProductGroup, PartClass)

AppActivate ("Part File Maintenance)", True

Wait 0.25 'routine to slow down keystrokes or Vantage will error
out

SendKeys "{INSERT}", True 'Add Part

Wait 0.25

SendKeys pn, True

Wait 0.25

Sendkeys "{TAB}",True

SendKeys Desc, True

Sendkeys "{TAB}",True

If parttype="P" then sendkeys"{RIGHT}",true

Sendkeys "{TAB}",True

SendKeys ProductGroup, True

Sendkeys "{TAB}",True

SendKeys PartClass, True

Sendkeys "{TAB}",True

Sendkeys "{F2}", True 'Same as pressing OK button

End Sub

Sub Wait(ms)

'slows down the sendkeys because it is too fast for Vantage

Dim PauseTime, Start, Finish, TotalTime

PauseTime = ms ' Set duration.

Start = Timer ' Set start time.

Do While Timer < Start + PauseTime

DoEvents ' Yield to other processes.

Loop

Finish = Timer ' Set end time.

End Sub

Randall Weber
IT Manager
TLC Electronics, Inc.
651-287-2972
rweber@... <mailto:rweber%40tlcelectronics.com>

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Robert Brown
Sent: Friday, August 31, 2007 2:25 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Importing data via Access

Randy,

Do have a VB code example you'd be willing to share to illustrate use of
the SendKeys feature?

...Sounds like a handy little tool.

Thanks

Randy Weber <rweber@...
<mailto:rweber%40tlcelectronics.com>
<mailto:rweber%40tlcelectronics.com> > wrote:
We imported 10,000 Parts into the part table in v6.x in May of 2003 and
had no trouble. Care must be taken to insure that related tables are
populated first (Part Class, Product Group, etc.).

If you're concerned about possible errors another method is using the
Visual Basic SendKeys feature which literally does the typing for you.
We added thousands of price records this way. I have written numerous
SendKeys functions that we use from time to time inclduing one that adds
part pricing in five columns every day.

Randall Weber
IT Manager
TLC Electronics, Inc.
651-287-2972
rweber@... <mailto:rweber%40tlcelectronics.com>
<mailto:rweber%40tlcelectronics.com>

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Todd Caughey
Sent: Friday, August 31, 2007 7:56 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Importing data via Access

There have been many discussions over the years about writing directly
into the database. Most have come down to this being very risky in terms
of potential to corrupt the database. There are many "trigger" routines
in Vantage that properly populate all related tables and links and
without a very intimate knowledge level of how these work it is very
easy to miss one. I suspect the "tracker" screen is seeing the raw Part
table but can not pull up the complete record due to missing links to
subsidiary tables....things like memos or notes, etc... that would have
needed to have a stub entry (or something, just guessing here) created
at the time the Part was loaded. For all these reasons you can get
yourself into a very bad position, support wise, with Epicor...where
they will wash their hands of an damage you've done to the DB and leave
you on your own. Personally....I stay far away from this sort of thing.
But I am looking forward t o cut/paste grid entry in 8.x because this
runs all the Epicor/Progress routines that assure (we hope) DB
consistency.

The other, "safe" alternative for pre-8 has been to use a scripting tool
to simulate keystrokes and enter via the normal interface. GroundControl
was mentioned often.

-Todd C.

________________________________
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of wgoodlive
Sent: Friday, August 31, 2007 7:15 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Importing data via Access

Vantage 5.2. I seem to remember seeing posted before about importing
data by using Access and ODBC. I am trying to import part files into
a "clean" Vantage install using Access. I can fix the part information
in excel and then copy or import into the correct table in Access
(Part, PartWhse, PartPlant). When I go to the Part Master screen in
Vantage the information is there, but I cannot access it. When I click
on a part number nothing happens. Any help please? Is it even
possible to do this?

Bill
Maximum Spindle Utilization, Inc.

________________________________
The information contained in this E-mail message and any documents which
may be attached are privileged and confidential, and may be protected
from disclosure.

Please be aware that any use, printing, copying, disclosure or
dissemination of this communication may be subject to legal restriction
or sanction. If you think you have received this message in error,
please reply to the sender.

For more information please visit www.harveyvogel.com

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

---------------------------------
Yahoo! oneSearch: Finally, mobile search that gives answers, not web
links.

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

---------------------------------
Need a vacation? Get great deals to amazing places on Yahoo! Travel.

[Non-text portions of this message have been removed]






[Non-text portions of this message have been removed]
2
Vantage 5.2. I seem to remember seeing posted before about importing
data by using Access and ODBC. I am trying to import part files into
a "clean" Vantage install using Access. I can fix the part information
in excel and then copy or import into the correct table in Access
(Part, PartWhse, PartPlant). When I go to the Part Master screen in
Vantage the information is there, but I cannot access it. When I click
on a part number nothing happens. Any help please? Is it even
possible to do this?

Bill
Maximum Spindle Utilization, Inc.
3
There have been many discussions over the years about writing directly into the database. Most have come down to this being very risky in terms of potential to corrupt the database. There are many "trigger" routines in Vantage that properly populate all related tables and links and without a very intimate knowledge level of how these work it is very easy to miss one. I suspect the "tracker" screen is seeing the raw Part table but can not pull up the complete record due to missing links to subsidiary tables....things like memos or notes, etc... that would have needed to have a stub entry (or something, just guessing here) created at the time the Part was loaded. For all these reasons you can get yourself into a very bad position, support wise, with Epicor...where they will wash their hands of an damage you've done to the DB and leave you on your own. Personally....I stay far away from this sort of thing. But I am looking forward to cut/paste grid entry in 8.x because this runs all the Epicor/Progress routines that assure (we hope) DB consistency.

The other, "safe" alternative for pre-8 has been to use a scripting tool to simulate keystrokes and enter via the normal interface. GroundControl was mentioned often.

-Todd C.


________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of wgoodlive
Sent: Friday, August 31, 2007 7:15 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Importing data via Access


Vantage 5.2. I seem to remember seeing posted before about importing
data by using Access and ODBC. I am trying to import part files into
a "clean" Vantage install using Access. I can fix the part information
in excel and then copy or import into the correct table in Access
(Part, PartWhse, PartPlant). When I go to the Part Master screen in
Vantage the information is there, but I cannot access it. When I click
on a part number nothing happens. Any help please? Is it even
possible to do this?

Bill
Maximum Spindle Utilization, Inc.



________________________________
The information contained in this E-mail message and any documents which may be attached are privileged and confidential, and may be protected from disclosure.

Please be aware that any use, printing, copying, disclosure or dissemination of this communication may be subject to legal restriction or sanction. If you think you have received this message in error, please reply to the sender.

For more information please visit www.harveyvogel.com


[Non-text portions of this message have been removed]
4
If your imported records aren't accessible thru the various Vantage interface apps, you either must have left out a key/indexed required field (possibly in a subtable) in your import OR values imported into one or more fields are 'out of bounds' (not correct data type or not any one of a number of predetermined values the field was designed to hold).

This is likely rendering the imported records to be unusable.

wgoodlive <wgoodlive@...> wrote: Vantage 5.2. I seem to remember seeing posted before about importing
data by using Access and ODBC. I am trying to import part files into
a "clean" Vantage install using Access. I can fix the part information
in excel and then copy or import into the correct table in Access
(Part, PartWhse, PartPlant). When I go to the Part Master screen in
Vantage the information is there, but I cannot access it. When I click
on a part number nothing happens. Any help please? Is it even
possible to do this?

Bill
Maximum Spindle Utilization, Inc.






---------------------------------
Moody friends. Drama queens. Your life? Nope! - their life, your story.
Play Sims Stories at Yahoo! Games.

[Non-text portions of this message have been removed]
5
We imported 10,000 Parts into the part table in v6.x in May of 2003 and
had no trouble. Care must be taken to insure that related tables are
populated first (Part Class, Product Group, etc.).

If you're concerned about possible errors another method is using the
Visual Basic SendKeys feature which literally does the typing for you.
We added thousands of price records this way. I have written numerous
SendKeys functions that we use from time to time inclduing one that adds
part pricing in five columns every day.


Randall Weber
IT Manager
TLC Electronics, Inc.
651-287-2972
rweber@...


________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Todd Caughey
Sent: Friday, August 31, 2007 7:56 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Importing data via Access



There have been many discussions over the years about writing directly
into the database. Most have come down to this being very risky in terms
of potential to corrupt the database. There are many "trigger" routines
in Vantage that properly populate all related tables and links and
without a very intimate knowledge level of how these work it is very
easy to miss one. I suspect the "tracker" screen is seeing the raw Part
table but can not pull up the complete record due to missing links to
subsidiary tables....things like memos or notes, etc... that would have
needed to have a stub entry (or something, just guessing here) created
at the time the Part was loaded. For all these reasons you can get
yourself into a very bad position, support wise, with Epicor...where
they will wash their hands of an damage you've done to the DB and leave
you on your own. Personally....I stay far away from this sort of thing.
But I am looking forward t o cut/paste grid entry in 8.x because this
runs all the Epicor/Progress routines that assure (we hope) DB
consistency.

The other, "safe" alternative for pre-8 has been to use a scripting tool
to simulate keystrokes and enter via the normal interface. GroundControl
was mentioned often.

-Todd C.

________________________________
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of wgoodlive
Sent: Friday, August 31, 2007 7:15 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Importing data via Access

Vantage 5.2. I seem to remember seeing posted before about importing
data by using Access and ODBC. I am trying to import part files into
a "clean" Vantage install using Access. I can fix the part information
in excel and then copy or import into the correct table in Access
(Part, PartWhse, PartPlant). When I go to the Part Master screen in
Vantage the information is there, but I cannot access it. When I click
on a part number nothing happens. Any help please? Is it even
possible to do this?

Bill
Maximum Spindle Utilization, Inc.

________________________________
The information contained in this E-mail message and any documents which
may be attached are privileged and confidential, and may be protected
from disclosure.

Please be aware that any use, printing, copying, disclosure or
dissemination of this communication may be subject to legal restriction
or sanction. If you think you have received this message in error,
please reply to the sender.

For more information please visit www.harveyvogel.com

[Non-text portions of this message have been removed]






[Non-text portions of this message have been removed]
6
Randy,

Do have a VB code example you'd be willing to share to illustrate use of the SendKeys feature?

...Sounds like a handy little tool.

Thanks

Randy Weber <rweber@...> wrote:
We imported 10,000 Parts into the part table in v6.x in May of 2003 and
had no trouble. Care must be taken to insure that related tables are
populated first (Part Class, Product Group, etc.).

If you're concerned about possible errors another method is using the
Visual Basic SendKeys feature which literally does the typing for you.
We added thousands of price records this way. I have written numerous
SendKeys functions that we use from time to time inclduing one that adds
part pricing in five columns every day.


Randall Weber
IT Manager
TLC Electronics, Inc.
651-287-2972
rweber@...


________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Todd Caughey
Sent: Friday, August 31, 2007 7:56 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Importing data via Access

There have been many discussions over the years about writing directly
into the database. Most have come down to this being very risky in terms
of potential to corrupt the database. There are many "trigger" routines
in Vantage that properly populate all related tables and links and
without a very intimate knowledge level of how these work it is very
easy to miss one. I suspect the "tracker" screen is seeing the raw Part
table but can not pull up the complete record due to missing links to
subsidiary tables....things like memos or notes, etc... that would have
needed to have a stub entry (or something, just guessing here) created
at the time the Part was loaded. For all these reasons you can get
yourself into a very bad position, support wise, with Epicor...where
they will wash their hands of an damage you've done to the DB and leave
you on your own. Personally....I stay far away from this sort of thing.
But I am looking forward t o cut/paste grid entry in 8.x because this
runs all the Epicor/Progress routines that assure (we hope) DB
consistency.

The other, "safe" alternative for pre-8 has been to use a scripting tool
to simulate keystrokes and enter via the normal interface. GroundControl
was mentioned often.

-Todd C.

________________________________
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of wgoodlive
Sent: Friday, August 31, 2007 7:15 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Importing data via Access

Vantage 5.2. I seem to remember seeing posted before about importing
data by using Access and ODBC. I am trying to import part files into
a "clean" Vantage install using Access. I can fix the part information
in excel and then copy or import into the correct table in Access
(Part, PartWhse, PartPlant). When I go to the Part Master screen in
Vantage the information is there, but I cannot access it. When I click
on a part number nothing happens. Any help please? Is it even
possible to do this?

Bill
Maximum Spindle Utilization, Inc.

________________________________
The information contained in this E-mail message and any documents which
may be attached are privileged and confidential, and may be protected
from disclosure.

Please be aware that any use, printing, copying, disclosure or
dissemination of this communication may be subject to legal restriction
or sanction. If you think you have received this message in error,
please reply to the sender.

For more information please visit www.harveyvogel.com

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]






---------------------------------
Yahoo! oneSearch: Finally, mobile search that gives answers, not web links.

[Non-text portions of this message have been removed]
7
i use a combination of http://www.autohotkey.com and a self brewed
program to repeat the sequences

directly writing is not advised or wise.......




Todd Caughey schreef:
> There have been many discussions over the years about writing directly into the database. Most have come down to this being very risky in terms of potential to corrupt the database. There are many "trigger" routines in Vantage that properly populate all related tables and links and without a very intimate knowledge level of how these work it is very easy to miss one. I suspect the "tracker" screen is seeing the raw Part table but can not pull up the complete record due to missing links to subsidiary tables....things like memos or notes, etc... that would have needed to have a stub entry (or something, just guessing here) created at the time the Part was loaded. For all these reasons you can get yourself into a very bad position, support wise, with Epicor...where they will wash their hands of an damage you've done to the DB and leave you on your own. Personally....I stay far away from this sort of thing. But I am looking forward to cut/paste grid entry in 8.x because th
> is runs all the Epicor/Progress routines that assure (we hope) DB consistency.
>
> The other, "safe" alternative for pre-8 has been to use a scripting tool to simulate keystrokes and enter via the normal interface. GroundControl was mentioned often.
>
> -Todd C.
>
>
> ________________________________
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of wgoodlive
> Sent: Friday, August 31, 2007 7:15 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Importing data via Access
>
>
> Vantage 5.2. I seem to remember seeing posted before about importing
> data by using Access and ODBC. I am trying to import part files into
> a "clean" Vantage install using Access. I can fix the part information
> in excel and then copy or import into the correct table in Access
> (Part, PartWhse, PartPlant). When I go to the Part Master screen in
> Vantage the information is there, but I cannot access it. When I click
> on a part number nothing happens. Any help please? Is it even
> possible to do this?
>
> Bill
> Maximum Spindle Utilization, Inc.
>
>
>
> ________________________________
> The information contained in this E-mail message and any documents which may be attached are privileged and confidential, and may be protected from disclosure.
>
> Please be aware that any use, printing, copying, disclosure or dissemination of this communication may be subject to legal restriction or sanction. If you think you have received this message in error, please reply to the sender.
>
> For more information please visit www.harveyvogel.com
>
>
> [Non-text portions of this message have been removed]
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
> Yahoo! Groups Links
>
>
>
>
8
Below is an example of a simple SendKeys routing written in VBA. Someone
familiar with MS Access and VBA should be able to modify this for your
situation. The SendKeys feature works just like it sounds, it activates
an application then sends keystrokes to that application.

No, it is not a complied application. It is simply a module in MS Access
with a couple sub routines. See below.

Randy Weber

Sample code for Visual Basic Sendkeys



Written for Vantage 6.10.525 Part Maintenance screen using an Access
Database as the source data.



Note: This code will not work as is on your screen because we have
changed the field layout.



Using an Access database with a Part table populated with PN, Desc,
PartType (P or M), ProductGroup and PartClass, I created a form based on
the table and a button which runs the following code. The code activates
the Vantage Part Maintenance screen and types in the necessary data to
enter a part number. Then go to next record in access and so on.



Sub AddPart (PN, Desc, PartType, ProductGroup, PartClass)

AppActivate ("Part File Maintenance)", True

Wait 0.25 'routine to slow down keystrokes or Vantage will error
out

SendKeys "{INSERT}", True 'Add Part

Wait 0.25

SendKeys pn, True

Wait 0.25

Sendkeys "{TAB}",True

SendKeys Desc, True

Sendkeys "{TAB}",True

If parttype="P" then sendkeys"{RIGHT}",true

Sendkeys "{TAB}",True

SendKeys ProductGroup, True

Sendkeys "{TAB}",True

SendKeys PartClass, True

Sendkeys "{TAB}",True

Sendkeys "{F2}", True 'Same as pressing OK button

End Sub





Sub Wait(ms)

'slows down the sendkeys because it is too fast for Vantage

Dim PauseTime, Start, Finish, TotalTime

PauseTime = ms ' Set duration.

Start = Timer ' Set start time.

Do While Timer < Start + PauseTime

DoEvents ' Yield to other processes.

Loop

Finish = Timer ' Set end time.

End Sub




Randall Weber
IT Manager
TLC Electronics, Inc.
651-287-2972
rweber@...


________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Robert Brown
Sent: Friday, August 31, 2007 2:25 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Importing data via Access



Randy,

Do have a VB code example you'd be willing to share to illustrate use of
the SendKeys feature?

...Sounds like a handy little tool.

Thanks

Randy Weber <rweber@...
<mailto:rweber%40tlcelectronics.com> > wrote:
We imported 10,000 Parts into the part table in v6.x in May of 2003 and
had no trouble. Care must be taken to insure that related tables are
populated first (Part Class, Product Group, etc.).

If you're concerned about possible errors another method is using the
Visual Basic SendKeys feature which literally does the typing for you.
We added thousands of price records this way. I have written numerous
SendKeys functions that we use from time to time inclduing one that adds
part pricing in five columns every day.

Randall Weber
IT Manager
TLC Electronics, Inc.
651-287-2972
rweber@... <mailto:rweber%40tlcelectronics.com>

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Todd Caughey
Sent: Friday, August 31, 2007 7:56 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Importing data via Access

There have been many discussions over the years about writing directly
into the database. Most have come down to this being very risky in terms
of potential to corrupt the database. There are many "trigger" routines
in Vantage that properly populate all related tables and links and
without a very intimate knowledge level of how these work it is very
easy to miss one. I suspect the "tracker" screen is seeing the raw Part
table but can not pull up the complete record due to missing links to
subsidiary tables....things like memos or notes, etc... that would have
needed to have a stub entry (or something, just guessing here) created
at the time the Part was loaded. For all these reasons you can get
yourself into a very bad position, support wise, with Epicor...where
they will wash their hands of an damage you've done to the DB and leave
you on your own. Personally....I stay far away from this sort of thing.
But I am looking forward t o cut/paste grid entry in 8.x because this
runs all the Epicor/Progress routines that assure (we hope) DB
consistency.

The other, "safe" alternative for pre-8 has been to use a scripting tool
to simulate keystrokes and enter via the normal interface. GroundControl
was mentioned often.

-Todd C.

________________________________
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of wgoodlive
Sent: Friday, August 31, 2007 7:15 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Importing data via Access

Vantage 5.2. I seem to remember seeing posted before about importing
data by using Access and ODBC. I am trying to import part files into
a "clean" Vantage install using Access. I can fix the part information
in excel and then copy or import into the correct table in Access
(Part, PartWhse, PartPlant). When I go to the Part Master screen in
Vantage the information is there, but I cannot access it. When I click
on a part number nothing happens. Any help please? Is it even
possible to do this?

Bill
Maximum Spindle Utilization, Inc.

________________________________
The information contained in this E-mail message and any documents which
may be attached are privileged and confidential, and may be protected
from disclosure.

Please be aware that any use, printing, copying, disclosure or
dissemination of this communication may be subject to legal restriction
or sanction. If you think you have received this message in error,
please reply to the sender.

For more information please visit www.harveyvogel.com

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

---------------------------------
Yahoo! oneSearch: Finally, mobile search that gives answers, not web
links.

[Non-text portions of this message have been removed]






[Non-text portions of this message have been removed]
9
Thanks very much for the example Randy. I just used a modified version using VBA/Excel and it worked like a charm.

Randy Weber <rweber@...> wrote:
Below is an example of a simple SendKeys routing written in VBA. Someone
familiar with MS Access and VBA should be able to modify this for your
situation. The SendKeys feature works just like it sounds, it activates
an application then sends keystrokes to that application.

No, it is not a complied application. It is simply a module in MS Access
with a couple sub routines. See below.

Randy Weber

Sample code for Visual Basic Sendkeys

Written for Vantage 6.10.525 Part Maintenance screen using an Access
Database as the source data.

Note: This code will not work as is on your screen because we have
changed the field layout.

Using an Access database with a Part table populated with PN, Desc,
PartType (P or M), ProductGroup and PartClass, I created a form based on
the table and a button which runs the following code. The code activates
the Vantage Part Maintenance screen and types in the necessary data to
enter a part number. Then go to next record in access and so on.

Sub AddPart (PN, Desc, PartType, ProductGroup, PartClass)

AppActivate ("Part File Maintenance)", True

Wait 0.25 'routine to slow down keystrokes or Vantage will error
out

SendKeys "{INSERT}", True 'Add Part

Wait 0.25

SendKeys pn, True

Wait 0.25

Sendkeys "{TAB}",True

SendKeys Desc, True

Sendkeys "{TAB}",True

If parttype="P" then sendkeys"{RIGHT}",true

Sendkeys "{TAB}",True

SendKeys ProductGroup, True

Sendkeys "{TAB}",True

SendKeys PartClass, True

Sendkeys "{TAB}",True

Sendkeys "{F2}", True 'Same as pressing OK button

End Sub

Sub Wait(ms)

'slows down the sendkeys because it is too fast for Vantage

Dim PauseTime, Start, Finish, TotalTime

PauseTime = ms ' Set duration.

Start = Timer ' Set start time.

Do While Timer < Start + PauseTime

DoEvents ' Yield to other processes.

Loop

Finish = Timer ' Set end time.

End Sub

Randall Weber
IT Manager
TLC Electronics, Inc.
651-287-2972
rweber@...


________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Robert Brown
Sent: Friday, August 31, 2007 2:25 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Importing data via Access

Randy,

Do have a VB code example you'd be willing to share to illustrate use of
the SendKeys feature?

...Sounds like a handy little tool.

Thanks

Randy Weber <rweber@...
<mailto:rweber%40tlcelectronics.com> > wrote:
We imported 10,000 Parts into the part table in v6.x in May of 2003 and
had no trouble. Care must be taken to insure that related tables are
populated first (Part Class, Product Group, etc.).

If you're concerned about possible errors another method is using the
Visual Basic SendKeys feature which literally does the typing for you.
We added thousands of price records this way. I have written numerous
SendKeys functions that we use from time to time inclduing one that adds
part pricing in five columns every day.

Randall Weber
IT Manager
TLC Electronics, Inc.
651-287-2972
rweber@... <mailto:rweber%40tlcelectronics.com>

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Todd Caughey
Sent: Friday, August 31, 2007 7:56 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Importing data via Access

There have been many discussions over the years about writing directly
into the database. Most have come down to this being very risky in terms
of potential to corrupt the database. There are many "trigger" routines
in Vantage that properly populate all related tables and links and
without a very intimate knowledge level of how these work it is very
easy to miss one. I suspect the "tracker" screen is seeing the raw Part
table but can not pull up the complete record due to missing links to
subsidiary tables....things like memos or notes, etc... that would have
needed to have a stub entry (or something, just guessing here) created
at the time the Part was loaded. For all these reasons you can get
yourself into a very bad position, support wise, with Epicor...where
they will wash their hands of an damage you've done to the DB and leave
you on your own. Personally....I stay far away from this sort of thing.
But I am looking forward t o cut/paste grid entry in 8.x because this
runs all the Epicor/Progress routines that assure (we hope) DB
consistency.

The other, "safe" alternative for pre-8 has been to use a scripting tool
to simulate keystrokes and enter via the normal interface. GroundControl
was mentioned often.

-Todd C.

________________________________
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of wgoodlive
Sent: Friday, August 31, 2007 7:15 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Importing data via Access

Vantage 5.2. I seem to remember seeing posted before about importing
data by using Access and ODBC. I am trying to import part files into
a "clean" Vantage install using Access. I can fix the part information
in excel and then copy or import into the correct table in Access
(Part, PartWhse, PartPlant). When I go to the Part Master screen in
Vantage the information is there, but I cannot access it. When I click
on a part number nothing happens. Any help please? Is it even
possible to do this?

Bill
Maximum Spindle Utilization, Inc.

________________________________
The information contained in this E-mail message and any documents which
may be attached are privileged and confidential, and may be protected
from disclosure.

Please be aware that any use, printing, copying, disclosure or
dissemination of this communication may be subject to legal restriction
or sanction. If you think you have received this message in error,
please reply to the sender.

For more information please visit www.harveyvogel.com

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

---------------------------------
Yahoo! oneSearch: Finally, mobile search that gives answers, not web
links.

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]






---------------------------------
Need a vacation? Get great deals to amazing places on Yahoo! Travel.

[Non-text portions of this message have been removed]