Photo Gallery Member List Search Calendars FAQ Ticket List Log Out


Value Replacement in MS Access

  		Logged in as: Guest
arrSession:exec spGetSession 2,2,52573
Active Users: There are 0 members and 0 guests.
Users viewing this topic: none
 

 

  
 
  Printable Version
All Forums >> [Scripting] >> WSH & Client Side VBScript >> Value Replacement in MS Access
  Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks! 		Page: [1]
Login
Message << Older Topic   Newer Topic >>
Value Replacement in MS Access - 10/10/2007 12:55:56 AM   
  UKats

 

Posts: 2
Score: 0
Joined: 10/10/2007
Status: offline 		Fairly new to this.  ...not looking for someone to write a script, just a good place to look or a topic to search for.  I have a database in MS Access.  In a few of these tables there is a value that I need changed from the current value to a new value.  The current value and replacement value will be the same in all the tables I need to change.  Can I use some kind of OpenTable/seek and replace VB scipt to perform this function?  Any pointing in the right direction would be of great help.

-Thanks

< Message edited by UKats -- 10/10/2007 1:43:10 AM >
 
 
Post #: 1
 
RE: Value Replacement in MS Access - 10/10/2007 4:03:54 AM   
  mcds99


Posts: 441
Score: 4
Joined: 2/28/2006
Status: offline 		This is your first post so I'll drop some hints first.

Forum Rules: http://www.visualbasicscript.com/m_23724/tm.htm

Read Me First: http://www.visualbasicscript.com/m_24727/tm.htm

FAQ:  http://www.visualbasicscript.com/m_47117/tm.htm

This forum is for getting "help" not asking for someone to write a script for you.
Take a look at the 3 links above and ask again after you have made an attempt to come up with a solution.


_____________________________

Sam

Keep it Simple Make it Fun KiSMiF

(in reply to UKats)
 
 
Post #: 2
 
RE: Value Replacement in MS Access - 10/10/2007 5:31:38 AM   
  UKats

 

Posts: 2
Score: 0
Joined: 10/10/2007
Status: offline 		The first line of my post says:  "...not looking for someone to write a script..."  All I wanted was a route or keyword to search, which is what it says to do in the 3rd link you referred me to.  Trying to keep it positive, I have remedied my issue after some web and forum searching.  I had some extra actions that I did not need that were causing errors.  Thanks.  Have a good one.

(in reply to mcds99)
 
 
Post #: 3
 
RE: Value Replacement in MS Access - 10/10/2007 12:44:19 PM   
  sheepz


Posts: 247
Score: 2
Joined: 3/17/2006
From: Riverside the 909s
Status: offline 		i dont know much about ms access but i know theres so many things you can do to parse/edit data within the dbase.  there should be a way to do it through ms access with design view/sql view, no need for vbs... if your still having issues let me know i'll try parsing the data and cut and paste the sql commands...

(in reply to UKats)
 
 
Post #: 4
 
 
 
 

If you found our site useful please link to us <a href="http://www.visualbasicscript.com">VisualBasicScript.com</a>.
All Forums >> [Scripting] >> WSH & Client Side VBScript >> Value Replacement in MS Access Page: [1]
Jump to:





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts




Forum Software © ASPPlayground.NET Advanced Edition 2.5.5 ANSI