Find your solution!

spdstr · 18-Aug-2009, 12:44 PM #1

i have a database that has data from an excel worksheet. the database allows u to edit and add new data. what i want to have access do is when it closes have it run a macro or code to update any changes in the data and save it to the original excel file. can this be done?

OBP · 18-Aug-2009, 02:31 PM #2

Yes it can, but requires fairly advanced VBA code.

spdstr · 19-Aug-2009, 08:18 AM #3

do u know where i can find how to do this

OBP · 19-Aug-2009, 11:14 AM #4

I can do it for you, but I need things like a Copy of the database, the excel Worksheet Names (Preferably a copy of the sheet) and what fields need transferring to what columns. etc

Tag Cloud
access audio blue screen boot bsod connection crash dell desktop driver drivers dvd email error excel firefox hard drive hardware hijackthis internet keyboard laptop malware monitor network networking outlook problem processor ram recovery router safe mode screen slow sound spyware tdlwsp.dll trojan upgrade vba video virus vista vundo windows windows 7 windows vista windows xp wireless

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Search
Search for: