Update Table - stevie PIMPS again!
in [Tables]
|
From: John... Visio MVP on 6 May 2010 16:30 "Steve" <notmyemail(a)address.com> wrote in message news:eeVIZTV7KHA.5848(a)TK2MSFTNGP06.phx.gbl... > Rob, > > If you get this to work for you manually, I could automate it for you so > you click a button on your end and then your users click a button on their > end. I provide fee-based help with Access applications. There would be a > small fee to automate this for you. Contact me if you want it automated. > > Steve > santus(a)penn.com Stevie, if you were any good, you would have repeat customers that would keep you busy. Pimping your services in a free support venue also shows that you have no ethics and are definitely not someone to trust. Stevie is our own personal pet troll who is the only one who does not understand the concept of FREE peer to peer support! He offers questionable results at unreasonable prices. These newsgroups are provided by Microsoft for FREE peer to peer support. There are many highly qualified individuals who gladly help for free. Stevie is not one of them, but he is the only one who just does not get the idea of "FREE" support. He offers questionable results at unreasonable prices. If he was any good, the "thousands" of people he claims to have helped would be flooding him with work, but there appears to be a continuous drought and he needs to constantly grovel for work. Please do not feed the trolls. John... Visio MVP
From: KARL DEWEY on 6 May 2010 18:33 See where Steve says to rename a file from .mdb to .dbf to make it a dBase III file. Subject: Re: Export an Access Table as an dbase III file 5/6/2010 1:55 PM PST By: Steve In: microsoft.public.access Hello Bill, Try exporting your file with a .mdb extension then renaming the file to a ...dbf file. Put the following code after your DiCmd.TransferDatabase command: Dim OldName, NewName OldName = "K:\CPANALYSIS\BusinessMgt\VP\Access\DBASE\tbs1.mdb" NewName = "K:\CPANALYSIS\BusinessMgt\VP\Access\DBASE\tbs1.dbf" Name OldName As NewName Steve santus(a)penn.com http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.access&cat=en_US_973e53c3-c10e-4523-9213-cdfd537838f1&lang=en&cr=US -- Build a little, test a little. "John... Visio MVP" wrote: > "Steve" <notmyemail(a)address.com> wrote in message > news:eeVIZTV7KHA.5848(a)TK2MSFTNGP06.phx.gbl... > > Rob, > > > > If you get this to work for you manually, I could automate it for you so > > you click a button on your end and then your users click a button on their > > end. I provide fee-based help with Access applications. There would be a > > small fee to automate this for you. Contact me if you want it automated. > > > > Steve > > santus(a)penn.com > > > Stevie, if you were any good, you would have repeat customers that would > keep you busy. Pimping your services in a free support venue also shows that > you have no ethics and are definitely not someone to trust. > > > > Stevie is our own personal pet troll who is the only one who does not > understand the concept of FREE peer to peer support! > He offers questionable results at unreasonable prices. > > These newsgroups are provided by Microsoft for FREE peer to peer support. > There are many highly qualified individuals who gladly help for free. Stevie > is not one of them, but he is the only one who just does not get the idea of > "FREE" support. He offers questionable results at unreasonable prices. If he > was any good, the "thousands" of people he claims to have helped would be > flooding him with work, but there appears to be a continuous drought and he > needs to constantly grovel for work. > > Please do not feed the trolls. > > John... Visio MVP > > . >
From: Steve on 7 May 2010 20:02 You are an ignoramus, Karl. You think you know it all and that gives you the right to act as an ignoramus. Look at the microsoft.public.access OP's post again. His file is being exported as a DBase III file. My suggestion merely says to save it with a ..mdb extension and then change the extension to .dbf. You ought to be nominated for MVP Visio and then you would be as ignorant as visio john. Steve "KARL DEWEY" <KARLDEWEY(a)discussions.microsoft.com> wrote in message news:FF854209-9C1B-4E2F-8CD7-6E6B55EEAB44(a)microsoft.com... > See where Steve says to rename a file from .mdb to .dbf to make it a dBase > III file. > > Subject: Re: Export an Access Table as an dbase III file 5/6/2010 1:55 PM > PST > > By: Steve > In: microsoft.public.access > > > > Hello Bill, > > Try exporting your file with a .mdb extension then renaming the file to a > ..dbf file. Put the following code after your DiCmd.TransferDatabase > command: > > Dim OldName, NewName > OldName = "K:\CPANALYSIS\BusinessMgt\VP\Access\DBASE\tbs1.mdb" > NewName = "K:\CPANALYSIS\BusinessMgt\VP\Access\DBASE\tbs1.dbf" > Name OldName As NewName > > Steve > santus(a)penn.com > > http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.access&cat=en_US_973e53c3-c10e-4523-9213-cdfd537838f1&lang=en&cr=US > > -- > Build a little, test a little. > > > "John... Visio MVP" wrote: > >> "Steve" <notmyemail(a)address.com> wrote in message >> news:eeVIZTV7KHA.5848(a)TK2MSFTNGP06.phx.gbl... >> > Rob, >> > >> > If you get this to work for you manually, I could automate it for you >> > so >> > you click a button on your end and then your users click a button on >> > their >> > end. I provide fee-based help with Access applications. There would be >> > a >> > small fee to automate this for you. Contact me if you want it >> > automated. >> > >> > Steve >> > santus(a)penn.com >> >> >> Stevie, if you were any good, you would have repeat customers that would >> keep you busy. Pimping your services in a free support venue also shows >> that >> you have no ethics and are definitely not someone to trust. >> >> >> >> Stevie is our own personal pet troll who is the only one who does not >> understand the concept of FREE peer to peer support! >> He offers questionable results at unreasonable prices. >> >> These newsgroups are provided by Microsoft for FREE peer to peer support. >> There are many highly qualified individuals who gladly help for free. >> Stevie >> is not one of them, but he is the only one who just does not get the idea >> of >> "FREE" support. He offers questionable results at unreasonable prices. If >> he >> was any good, the "thousands" of people he claims to have helped would be >> flooding him with work, but there appears to be a continuous drought and >> he >> needs to constantly grovel for work. >> >> Please do not feed the trolls. >> >> John... Visio MVP >> >> . >>
|
Pages: 1 Prev: Proper Table(s) Layout Next: Text wrap in column headings |