Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-29-2011, 04:25 PM
primmer3001 primmer3001 is offline VBA code to update record in Access 2003 using Userform in Excel Windows 7 32bit VBA code to update record in Access 2003 using Userform in Excel Office 2003
Novice
VBA code to update record in Access 2003 using Userform in Excel
 
Join Date: Jul 2011
Posts: 5
primmer3001 is on a distinguished road
Default VBA code to update record in Access 2003 using Userform in Excel

I'm working on a project fro work where agents fill in a userform to save data in access. This work, but what I need is a way of retrieving a single record that populates a different userform that can be amended & the over-write the original record. I'm not sure if this is possible but some help would be great.



Attached is what I have so far & really need help getting the Update records part working
Attached Files
File Type: xls Complaint log v4.xls (137.5 KB, 14 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
MM to Access 97 lost its link - broken by Windows Update? LesD Mail Merge 0 11-23-2010 07:13 AM
Access 2007 Upgrade After Initial Install - Access 2003 Won't Remove wcb Office 1 01-25-2010 04:08 AM
[Word 2003] Macro's and a UserForm xanuex Word VBA 0 10-19-2009 05:42 AM
VBA code to update record in Access 2003 using Userform in Excel How do I call/execute an Excel macro from Access 2003 KramerJ Excel 2 05-11-2009 11:33 AM
Delete excel files by code in Access Barry Richardson Office 0 06-13-2005 06:26 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:43 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft