VBA code to update record in Access 2003 using Userform in Excel

		Microsoft Office Forums > Microsoft Excel > Excel Programming
VBA code to update record in Access 2003 using Userform in Excel

FAQ

Thread Tools

Display Modes

08-29-2011, 04:25 PM

primmer3001 primmer3001 is offline

Windows 7 32bit VBA code to update record in Access 2003 using Userform in Excel

Office 2003

Novice

Join Date: Jul 2011

Posts: 5

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

Complaint log v4.xls (137.5 KB, 14 views)

« Previous Thread | Next Thread »

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
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 08:02 AM.