By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,098 Members | 1,918 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,098 IT Pros & Developers. It's quick & easy.

Archiving files

P: n/a
I need help - I am not a programmer. I am a user. I have an access95
database created by an individual who is no longer available. Another
worker in my office inadvertenly archived the jobs from our database.
Can anyone tell me how to unarchive these jobs?
Thank you.

Feb 27 '07 #1
Share this Question
Share on Google+
5 Replies


P: n/a
Archived them how? Archived them where? We can't really help you much from
what you've given us so far, I'm afraid! We need more detail!

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200702/1

Feb 27 '07 #2

P: n/a
On Feb 27, 3:14 pm, "missinglinq via AccessMonster.com" <u28780@uwe>
wrote:
Archived them how? Archived them where? We can't really help you much from
what you've given us so far, I'm afraid! We need more detail!

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/2007...
I hope I can give you more detail - I appreciate your willingness to
help. I am only the database user and am not very familiar w/
programming. There is a 'button' on the main menu screen. It was
pressed. In doing close it takes all files(we call them jobs) that
have been closed and sends them who knows where. The only information
I can retrieve is the job no., name and contact info. I cannot
retrieve the data input into these jobs. (The data is labor,
materials, subcontractors, invoices and payment). I have tried to peek
around into the tables and queries and since I really dont know what I
am doing - it doesnt do me much good. I hope that gives you more
details. Thanks again.

Feb 27 '07 #3

P: n/a
You need to find out what code is behind the command button that archives the
records.

1) From the form's Design View:

2) Right Click on the button

3) Make a note of the command button's name

4) Select Properties

5) Click on the Event Tab in the Properties box

6) You'll see "On Click"

7) In the box to the right you should see "Event Proceedure"

8) Left Click to the right of this entry

9) This should bring up an ellipsis (...) Double click on this

This should take you to the code window and you should see a sub listed for
the command button control something like "Private Sub
CommandButtonName_Click()" where CommandButtonName is the actual name of the
button you noted in step # 3 above

You need to copy this sub and post it here so that I or someone else to try
to figure out where the records went to. They may have been placed in a
separate table, or could even be in the same table where your active records
are; sometimes we don't actually move the records but merely use a checkbox
to denote an "active" versus an "inactive" record. If it's marked "active" it
appears in the form's underlying query and thus shows in the form. If it's
marked "inactive" it's not retrieved by the query and ths doesn't show up.

BTW, since you're new to all this, please understand that we're all
volunteers here. We're happy to help, that's why we troll these waters, but
we tend to come and go as other duties call. I'll check back when I get a
chance, and others will probably have a look and help if they can.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200702/1

Feb 27 '07 #4

P: n/a
I believe my earlier advice was appropriate. You are going to need to engage
someone who is experienced with and competent in Access database
development. This does not begin to give enough information for anyone to
have a remote chance of solving your problem. I'm afraid it is more than can
be handled in a newsgroup exchange.

Larry Linson
Microsoft Access MVP

<kl******@gmail.comwrote in message
news:11*********************@k78g2000cwa.googlegro ups.com...
On Feb 27, 3:14 pm, "missinglinq via AccessMonster.com" <u28780@uwe>
wrote:
>Archived them how? Archived them where? We can't really help you much
from
what you've given us so far, I'm afraid! We need more detail!

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via
AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/2007...

I hope I can give you more detail - I appreciate your willingness to
help. I am only the database user and am not very familiar w/
programming. There is a 'button' on the main menu screen. It was
pressed. In doing close it takes all files(we call them jobs) that
have been closed and sends them who knows where. The only information
I can retrieve is the job no., name and contact info. I cannot
retrieve the data input into these jobs. (The data is labor,
materials, subcontractors, invoices and payment). I have tried to peek
around into the tables and queries and since I really dont know what I
am doing - it doesnt do me much good. I hope that gives you more
details. Thanks again.

Feb 27 '07 #5

P: n/a
Thanks for the directions, here is the code behind the button:
Private Sub btnArchiveJobs_Click()
On Error GoTo Err_btnArchiveJobs_Click

Dim stDocName As String

stDocName = "mcrArchive"
DoCmd.RunMacro stDocName

Exit_btnArchiveJobs_Click:
Exit Sub

Err_btnArchiveJobs_Click:
MsgBox Err.Description
Resume Exit_btnArchiveJobs_Click

End Sub
-----------------------------------------------------------
I appreciate your help. I understand other duties take precedent.
Thanks for trying.
Also - I like your saying: "There's ALWAYS more than one way
to skin a cat!"

Feb 28 '07 #6

This discussion thread is closed

Replies have been disabled for this discussion.