 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
VB Forum / Database Access / May 2007Copy records, change date, save new...
I am working with VB.Net 2005 going to an Access 2003 database. I want to give my user the ability to copy a list of Orders (based on MR # and PreviousVisitDate) to a new VisitDate when they are creating one. I have everything ready but I am stuck on how to construct an SQL statement to do what I need to do. So this is what I have to do.. 1. Select all Orders with the specified MR and PreviousVisitDate 2. Copy all of the returned records (to a new temp table??) 3. Change the Date in the returned records to the New Date they entered. So now I will have the original list and the new list that looks just like it but with a different Date. I am sure this is simple for most of you but I am struggling with it. Can anyone show me an example of how this would be done or point me to one that I can read through? Thanks for any help you can give me with this. cc_crash <cccrash@discussions.microsoft.com>'s wild thoughts were released on Wed, 23 May 2007 13:02:02 -0700 bearing the following fruit: >I am working with VB.Net 2005 going to an Access 2003 database. This is a VB6 group, you really need a dotnet group. J >I want to give my user the ability to copy a list of Orders (based on MR # >and PreviousVisitDate) to a new VisitDate when they are creating one. I have [quoted text clipped - 13 lines] >anyone show me an example of how this would be done or point me to one that I >can read through? Thanks for any help you can give me with this. Sorry but the location is vb.database.ado...nothing about VB6 only. > cc_crash <cccrash@discussions.microsoft.com>'s wild thoughts > were released on Wed, 23 May 2007 13:02:02 -0700 bearing the [quoted text clipped - 23 lines] > >anyone show me an example of how this would be done or point me to one that I > >can read through? Thanks for any help you can give me with this. cc_crash <cccrash@discussions.microsoft.com>'s wild thoughts were released on Thu, 24 May 2007 05:26:02 -0700 bearing the following fruit: >Sorry but the location is vb.database.ado...nothing about VB6 only. This group was around long before dotnet. All the groups for VB6 and below have 'vb' in the name. The groups for dotnet have 'dotnet' in the name. The choice is yours, you can post here where most people will ignore your post, on the off chance that someone here can answer your question, or go to the correct group where many people will read your post and are more likely able to answer your question. I know which I'd rather do. J >> cc_crash <cccrash@discussions.microsoft.com>'s wild thoughts >> were released on Wed, 23 May 2007 13:02:02 -0700 bearing the [quoted text clipped - 23 lines] >> >anyone show me an example of how this would be done or point me to one that I >> >can read through? Thanks for any help you can give me with this. Which of course someone new to this group would know. "Jan Hyde (VB MVP)" <StellaDrinker@REMOVE.ME.uboot.com> wrote in message Sorry but the location is vb.database.ado...nothing about VB6 only. > This group was around long before dotnet. "Nobody" <trinity@nobody.com>'s wild thoughts were released on Thu, 24 May 2007 12:01:09 -0400 bearing the following fruit: >Which of course someone new to this group would know. Hence the reason for directing the OP to the correct place. J >"Jan Hyde (VB MVP)" <StellaDrinker@REMOVE.ME.uboot.com> wrote in message >Sorry but the location is vb.database.ado...nothing about VB6 only. >> >> This group was around long before dotnet. On May 23, 3:02 pm, cc_crash <cccr...@discussions.microsoft.com> wrote: > I am working with VB.Net 2005 going to an Access 2003 database. > [quoted text clipped - 15 lines] > anyone show me an example of how this would be done or point me to one that I > can read through? Thanks for any help you can give me with this. Regardless of dotnet or VB6 your problem is the same - How do you create a new table in access that is a copy of some existing data. Hopefully your existing records are in the same Access database then the SQL would look similar to the following: Insert INTO NewTable Select * from OldTable where whatever Then you can update the newly created table with the new date. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.