Solved

How to view the code in an Access 2007 developed application

Posted on 2014-11-13
6
316 Views
Last Modified: 2014-11-13
Hello All,

I am trying to migrate an office Access developed application to a different folder in another server.

The application its comprised by 2 files, one is called Interface and the other is called DATA.

When I first migrated it, I copied the 2 files over to the new server, but when I open the Interface file its seems that its still pointing to the DATA file in the old server location, I can see this in the time stamp reflected on the file. I am trying to see if I can find this link in order to edit it and point it to the new location but my knowledge in Access is very limited.

This application was developed by the previous manager but he did not make or leave any documentation.

Any hints on how to find and edit this link will be greatly appreciated!
0
Comment
Question by:LuiLui77
  • 3
  • 3
6 Comments
 
LVL 119

Accepted Solution

by:
Rey Obrero earned 500 total points
ID: 40440628
in the interface version,
right click in any of the tables and select Linked Table Manager
in the Linked Table Manager window
* check the box for Always prompt for new location
* click on Select All button
* click OK

in the dialog that will open, navigate to the folder where the DATA db is and select the the DATA db.
0
 

Author Comment

by:LuiLui77
ID: 40440744
Thanks Rey!
I was able to Link the interface to the new DATA file location!

Also Rey, there are certain buttons on the interface that I want to discover what is it that they do. For instance I know that there is a button that generates a report and I want to see what happens behind the scene when the user clicks on that button (i.e. what table they query and what calculations it does).

How can I see this?
0
 
LVL 119

Assisted Solution

by:Rey Obrero
Rey Obrero earned 500 total points
ID: 40440768
open the form in design view
select the button, then hit F4
in the property window of the button, select the Event tab
look for the On Click  event ,
if you see [Event Procedure],
     * click the (...) on the right end of the click event, this will open the VBE window and you will see the codes behind the click event of the button

if you see [Embedded Macro]
    * click the (...) on the right end of the click event, this will open the Macro assigned to the button
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 

Author Comment

by:LuiLui77
ID: 40440977
Cool!

What I see is HandleButtonclick(1) on the field, this might be a customize event or something. If I click on the dropdown button I can see some other events with some key names. how can I check on the events design?
0
 
LVL 119

Expert Comment

by:Rey Obrero
ID: 40441078
ok, what you are seeing is a switchboard type of form, this is a complex situation for a beginner.
you need somebody who has advanced knowledge of access and vba to handle this.
0
 

Author Closing Comment

by:LuiLui77
ID: 40441326
I guess you are right. I got  what I wanted though. Thanks for everything!
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now