Solved

How to view the code in an Access 2007 developed application

Posted on 2014-11-13
6
320 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 120

Accepted Solution

by:
Rey Obrero (Capricorn1) 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 120

Assisted Solution

by:Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1) 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 120

Expert Comment

by:Rey Obrero (Capricorn1)
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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

828 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