ACCESS FEED: Re: [MS_AccessPros] Old database

Rabu, 06 Agustus 2014

Re: [MS_AccessPros] Old database

We don't allow attachments bu tI think you can paste an image into the post.

In the mean time, I bet the box is actually a sub form. You can use conditional formatting to change the font color that way. If you make a copy of your database, remove all records from the tables and upload the zipped file to our Files>_AssistanceNeeded folder one of us can convert the DB for you.

Regards,

Bill Mosca

From: "Jessica Hoback hobackjessica@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>
To: "MS Access Professionals" <MS_Access_Professionals@yahoogroups.com>
Sent: Wednesday, August 6, 2014 12:56:01 PM
Subject: Re: [MS_AccessPros] Old database

Since I haven't received an answer from IT on moving this old database to a place where I could potentially import it into a newer version, I am going to try to recreate it from scratch. Hopefully I'm not getting in over my head but in any case it will be a learning experience.

Can anyone tell me how the "Type of Crime" box in the attached image might have been created? When I try an option box I can enter only 20 options and it will allow for only one selection. I have a table of Type of Crime options that I tried to use in a combo box, however, as you can see some are displayed in red font and others are not. The combo box won't let me change the font colors for specific items.

Thanks!
Jessica

On Tuesday, July 29, 2014 7:40 PM, "mac ba macba2000id@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:

you could export the db ..to ms excel format ,save it, from new computer,import the excel file into new DB

On Wednesday, July 30, 2014 1:19 AM, "Jim Wagner luvmymelody@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:

Jessica,

Is the old database on a network drive where a computer with the newer version of Access is installed? If so you can bring in the objects using get external data.

Jim Wagner

________________________________

On Tuesday, July 29, 2014 11:09 AM, "hobackjessica@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:

My business has an old MS database stored on an old computer that is remotely accessed by the only user in the department - we just discovered today that it is a MS - database probably 2000(?). The reason it is housed on an old computer in a store room someplace is because IT says the new computers won't support this old database. How would any of you recommend the data in the old database be transferred into a new version that can be used more easily?

Thanks!

Jessica

[Non-text portions of this message have been removed]