delete & insert for access 2007

[drstein]

I am new to working with access 2007 but I have experience working with sql server 2008 r2. I was just assigned to work with several access 2007 databases that have very little documentation. Due to that fact, I have the following questions:
1. In the report I am suppose to run, I know that records are added to a 'current' database table and a report is run. The records are deleted from the 'current' table and moved to a history table. However I do not see any queries that accomplish this goal. Is there some other feature in access 2007 like stored procedures, functions, and/or some other feature in access 2007 that would acoomplish this goal? If so, can you tell me what I am looking for and how to access that feature?
2. If I do not see the insert into a 'current' table and move the rows to a 'history' table, is there some features like a script, macro, a view, or some other feature that would accomplish this goal? If so, can you tell me what the options would be?

 

[spikepl]

DL some template from here http://office.microsoft.com/en-us/templates/CT010152732.aspx?av=ZAC and split it apart to see how things work. Unless you only use Access as a dumb db for backend of some web app, then it will be difficult to escape putting some effort into understanding of how Access ticks.

 

[Mr. B]

Chances are that the report is actually opened using a command button on a form or some other event. User of the database should be able to show how they open the report. Look for an event procedure associated with how they open or call the report. That is the place where you might find the queries or sql statements that would be managing the records.

It is sometime quite difficult to tell someone how something like this has been but together.

 

[drstein]

If the access 2007 database I am working with has templates, can you tell me how to find and use the templates?

 

[spikepl]

Do you need instructions for how to click on a link?

 

[drstein]

Chances are that the report is actually opened using a command button on a form or some other event.

It is sometime quite difficult to tell someone how something like this has been but together.

Can you tell me what you mean by 'some other event'? What are the other events and how do you access the other events?

 

[Mr. B]

Can you tell me what you mean by 'some other event'? What are the other events and how do you access the other events?

Forms and every control that can be used on a form in Access has events. Most have multiple events. Code and/or macros can be run from these events. I was attempting to indicate to you that you would most likely find a command button or some other control that would have a event that would be being used to open the report and that there was a good possiblibity that within this same code, there could be code that was managing the data.

I was also just trying to indicate to you that you might not find the code or macro execution behind a command button but that the code or macro execution could be in an event of some other control other than a commnad button.