Minggu, 31 Agustus 2014

[belajar-access] database access

 

kenapa pada sytem aplikasi saya tidak bisa dibuka.
pada access type menjadi microsoft office access Record-Locking Information. Gimana cara menghilangkannya?
Mohon Bantuannya....

Terima Kasih

__._,_.___

Posted by: teguh_utomo@ymail.com
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)
SPAM IS PROHIBITED

.

__,_._,___

[MS_AccessPros] On click vba code to close multiple quarries

 

Access 07; is there code for closing several open quarries at same time? If yes, I would appreciate to receive it. I am using micro with several lines to achieve this task then I thought there must be better technique to do this using vba.


__._,_.___

Posted by: kenaf42@yahoo.com
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)

.

__,_._,___

Sabtu, 30 Agustus 2014

Re: [MS_AccessPros] Old database

 

Jessica-


VMS is an old DEC operating system.  It runs either rDB, Ingres or System 1032 as a database.  As I understand it, the operating system itself comes with a graphical user interface that allows a developer to build an application on top of one of those three databases.  If you knew what the underlying database is, you might be able to extract the existing data (looks pretty important from your screen shots) to ultimately import it into a new Access database.

To rebuild the application, you first need to figure out what tables and fields you need.  The first screen shot you posted seems pretty straightforward - a Victims table related one to many (or perhaps many to many) to an Incidents table.  It's difficult to figure out whether Offense # in the Incidents table is a lookup to a particular type of crime or simply a Primary Key of the table.  From the later screen shots, I would guess that it's simply a Primary Key.  Your screen shot implies that there are more fields that we can't see.

The second screen shot gives you a clue about the details in the Incidents table, but the fields don't seem to match exactly what you can see in the subform on the first screen shot.  It's unclear whether you can select multiple check boxes under Type of Crime.  If that results in a single field per Incident, I would use a List Box in Access, but you have to figure out little details like this to be able to design the Access tables to support this.  It appears that there may be up to five other tables related to each incident - one for each tab shown.  It's unclear why there is a separate category for Co-Victim.  It would seem to me that either you're a victim of an incident or not, there can be multiple victims per incident, and a victim might appear in multiple incidents.  Ditto Offender information.  And you would need to figure out whether Restitution applies to a specific victim or is related only to the incident.  

The third screen seems to give you a clue about Services.  The screen clearly says multiple services can be provided, but there's no clue about the underlying structure.  Are there really individual fields for each check box (bad design), or does the data entry form somehow generate one record per check box?  In Access, you could use a multi-value field, but I doubt that any of the three database systems support something like that, so the underlying table design is a mystery.

The final screen shot gives you a clue about the information about Co-Victims.  The data appears to be the same as for Victims in the first screen.  Are Victims and Co-Victims really separate tables?  That doesn't sound like a good design.


ALL database application design starts with a good table design.  You need to understand what the application does, what pieces of information it gathers, what subjects or actions it covers, and how those subjects or actions are related to one another.  Once you have all that information (the screen shots help, but you'll have to dig deeper), you can then design tables in Access.  If you can get that done, building the forms and reports to manipulate and display the data will be very easy.  You might not end up with something that looks exactly like the old application.  In fact, you may discover anomalies in the old design that you can fix with this new replacement.

I suggest you sit down with the person who uses this application and pick his or her brain about what the application is expected to do.  Work on four simultaneous lists:

1) A list of tasks performed by the application - what the user expects the application to do

2) A list of all the individual bits of data that must be saved in the database

3) A list of the subjects and actions - associating each bit of data with one and only one subject or action
   (The subjects and actions will ultimately be your tables!)

4) A list of how each subject or action is related to other subjects or actions.

We have already begun to identify some of the subjects and actions:
Incidents
Victims  (and maybe co-victims)
Offenders
Services
Restitutions

The incident is the primary action.
Victims, Offenders, and Services are clearly subjects.
Restitution may be either a subject or an action or both  (A generic restitution type table as a subject, and each restitution paid or performed as an action related to an incident)

Hope that helps...

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
SQL Queries for Mere Mortals 
(Paris, France)




On Aug 30, 2014, at 8:33 PM, hobackjessica@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:


Stuart,   I have no idea about the data.  I've never even heard of VMS before!

 

I did upload a PDF file of screen shots from the old database. I would like to recreate it as closely as possible.  I would like each form to link together by the primary victim.   I have built the forms - for the most part - but I'm not sure how to link them all together.  Also, on the primary victim form in the screen shots there is a datasheet view of a query based on the victim listed above.  This shows all of the incidents that victim is related to and has received services for.  I'm assuming this is a subform (?) but I'm not sure how to make query results show in a subform.

 

I'm sure you can all tell from this email how far behind the curve I am and how desperately I need the help of the Access Professionals! 

 

Thanks again for any and all help you can give me!

 

Jessica


__._,_.___

Posted by: John Viescas <johnv@msn.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (13)

.

__,_._,___

Re: [MS_AccessPros] Old database

 


Stuart,   I have no idea about the data.  I've never even heard of VMS before!

 

I did upload a PDF file of screen shots from the old database. I would like to recreate it as closely as possible.  I would like each form to link together by the primary victim.   I have built the forms - for the most part - but I'm not sure how to link them all together.  Also, on the primary victim form in the screen shots there is a datasheet view of a query based on the victim listed above.  This shows all of the incidents that victim is related to and has received services for.  I'm assuming this is a subform (?) but I'm not sure how to make query results show in a subform.

 

I'm sure you can all tell from this email how far behind the curve I am and how desperately I need the help of the Access Professionals! 

 

Thanks again for any and all help you can give me!

 

Jessica

__._,_.___

Posted by: hobackjessica@yahoo.com
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (12)

.

__,_._,___

[MS_AccessPros] New file uploaded to MS_Access_Professionals

 


Hello,

This email message is a notification to let you know that
a file has been uploaded to the Files area of the MS_Access_Professionals
group.

File : /VCMS screen shots.pdf
Uploaded by : hobackjessica <hobackjessica@yahoo.com>
Description :

You can access this file at the URL:
https://groups.yahoo.com/neo/groups/MS_Access_Professionals/files/VCMS%20screen%20shots.pdf

To learn more about file sharing for your group, please visit:
https://help.yahoo.com/kb/index?page=content&y=PROD_GRPS&locale=en_US&id=SLN15398

Regards,

hobackjessica <hobackjessica@yahoo.com>

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1045)

.

__,_._,___

Re: [MS_AccessPros] Old database

 

Can you be specific about the data?   Is it Rdb?  Ingres?  System 1032?

Stuart


On Saturday, August 30, 2014 11:24 AM, "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:


 
Jessica-

Sure, upload away!

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
SQL Queries for Mere Mortals 
(Paris, France)




On Aug 30, 2014, at 4:32 PM, Jessica hobackjessica@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

John,
I'm not having any luck getting direct access to the old database.   There's really only one user for it and she had to access it by logging in remotely to the old computer it's currently on.   

Saving the existing records is no longer a big concern. Right now it still works for her but if she's going to change it needs to happen Oct 1.  It is a database of victim assistance records for a police department and she's required to report to the state annually.  Annual for her purposes is Oct 1 to Sept 30.  

Since it took this long to get any info on converting the old I'm quickly running out of time to learn new MS Access skills.  I have a pretty good start I think I just need to figure out how to connect everything - that's my frustration at this point. 

I have screen shots of the old database forms saved as a pdf document.  Can I upload that to the group for some suggestions? 

Thanks! 
Jessica


Sent from my Verizon Wireless 4G LTE smartphone


-------- Original message --------
From: "John Viescas JohnV@msn.com [MS_Access_Professionals]"
Date:08/30/2014 6:17 AM (GMT-06:00)
Subject: Re: [MS_AccessPros] Old database

 
Jessica-

Do you still have a way to get to the data in VMS?  If there's a way to export the data - even as something like a CSV file - then you can load it into your new Access database.

You don't give many details, but it sounds like you have multiple users for this app.  Tell IT you're going to move the data to an SQL Server system they set up for you.  They should feel comfortable with that.  Then design the front ends in Access using linked tables to SQL Server.

As for upgrading computers - if you use the latest version of Access (2013), your application files should be compatible for at least the next two releases.  At some point in the future, you may need to import all your application objects into the a database built using the "current" version of Access, but that's probably 3-5 years down the road.

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
SQL Queries for Mere Mortals 
(Paris, France)




On Aug 29, 2014, at 5:14 PM, Jessica Hoback hobackjessica@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Hello group.  Sorry for drawing this problem out.  I'm being told that this old database is actually a VMS database, not Access, and VMS is no longer a thing so it can't be converted.?.
 
In regards to me building a new database in Access to replace the old, IT is concerned that every time we upgrade computers we will have to convert the database to a newer version of Access to make it compatible.  Has this ever been an issue for anyone? 
 
I'm not convinced IT's solution is going to work so I will continue to try to build a database (we would like to implement something by Oct 1 for reporting purposes).  Heads up, I might be asking for a lot of help as I am an extremely rookie Access user - particulary when it comes to the VBA stuff.
 
Thanks for your feedback!
 
Jessica


On Wednesday, August 6, 2014 3:18 PM, "wrmosca@comcast.net [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:


 
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]









__._,_.___

Posted by: Stuart Schulman <stoughy@yahoo.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (11)

.

__,_._,___

Re: [MS_AccessPros] Old database

 

Jessica-


Sure, upload away!

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
SQL Queries for Mere Mortals 
(Paris, France)




On Aug 30, 2014, at 4:32 PM, Jessica hobackjessica@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

John,
I'm not having any luck getting direct access to the old database.   There's really only one user for it and she had to access it by logging in remotely to the old computer it's currently on.   

Saving the existing records is no longer a big concern. Right now it still works for her but if she's going to change it needs to happen Oct 1.  It is a database of victim assistance records for a police department and she's required to report to the state annually.  Annual for her purposes is Oct 1 to Sept 30.  

Since it took this long to get any info on converting the old I'm quickly running out of time to learn new MS Access skills.  I have a pretty good start I think I just need to figure out how to connect everything - that's my frustration at this point. 

I have screen shots of the old database forms saved as a pdf document.  Can I upload that to the group for some suggestions? 

Thanks! 
Jessica


Sent from my Verizon Wireless 4G LTE smartphone


-------- Original message --------
From: "John Viescas JohnV@msn.com [MS_Access_Professionals]"
Date:08/30/2014 6:17 AM (GMT-06:00)
Subject: Re: [MS_AccessPros] Old database

 

Jessica-


Do you still have a way to get to the data in VMS?  If there's a way to export the data - even as something like a CSV file - then you can load it into your new Access database.

You don't give many details, but it sounds like you have multiple users for this app.  Tell IT you're going to move the data to an SQL Server system they set up for you.  They should feel comfortable with that.  Then design the front ends in Access using linked tables to SQL Server.

As for upgrading computers - if you use the latest version of Access (2013), your application files should be compatible for at least the next two releases.  At some point in the future, you may need to import all your application objects into the a database built using the "current" version of Access, but that's probably 3-5 years down the road.

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
SQL Queries for Mere Mortals 
(Paris, France)




On Aug 29, 2014, at 5:14 PM, Jessica Hoback hobackjessica@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Hello group.  Sorry for drawing this problem out.  I'm being told that this old database is actually a VMS database, not Access, and VMS is no longer a thing so it can't be converted.?.
 
In regards to me building a new database in Access to replace the old, IT is concerned that every time we upgrade computers we will have to convert the database to a newer version of Access to make it compatible.  Has this ever been an issue for anyone? 
 
I'm not convinced IT's solution is going to work so I will continue to try to build a database (we would like to implement something by Oct 1 for reporting purposes).  Heads up, I might be asking for a lot of help as I am an extremely rookie Access user - particulary when it comes to the VBA stuff.
 
Thanks for your feedback!
 
Jessica


On Wednesday, August 6, 2014 3:18 PM, "wrmosca@comcast.net [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:


 
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]







__._,_.___

Posted by: John Viescas <johnv@msn.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (10)

.

__,_._,___

Re: [MS_AccessPros] Old database

 

John,
I'm not having any luck getting direct access to the old database.   There's really only one user for it and she had to access it by logging in remotely to the old computer it's currently on.   

Saving the existing records is no longer a big concern. Right now it still works for her but if she's going to change it needs to happen Oct 1.  It is a database of victim assistance records for a police department and she's required to report to the state annually.  Annual for her purposes is Oct 1 to Sept 30.  

Since it took this long to get any info on converting the old I'm quickly running out of time to learn new MS Access skills.  I have a pretty good start I think I just need to figure out how to connect everything - that's my frustration at this point. 

I have screen shots of the old database forms saved as a pdf document.  Can I upload that to the group for some suggestions? 

Thanks! 
Jessica


Sent from my Verizon Wireless 4G LTE smartphone


-------- Original message --------
From: "John Viescas JohnV@msn.com [MS_Access_Professionals]"
Date:08/30/2014 6:17 AM (GMT-06:00)
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Old database

 

Jessica-


Do you still have a way to get to the data in VMS?  If there's a way to export the data - even as something like a CSV file - then you can load it into your new Access database.

You don't give many details, but it sounds like you have multiple users for this app.  Tell IT you're going to move the data to an SQL Server system they set up for you.  They should feel comfortable with that.  Then design the front ends in Access using linked tables to SQL Server.

As for upgrading computers - if you use the latest version of Access (2013), your application files should be compatible for at least the next two releases.  At some point in the future, you may need to import all your application objects into the a database built using the "current" version of Access, but that's probably 3-5 years down the road.

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
SQL Queries for Mere Mortals 
(Paris, France)




On Aug 29, 2014, at 5:14 PM, Jessica Hoback hobackjessica@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Hello group.  Sorry for drawing this problem out.  I'm being told that this old database is actually a VMS database, not Access, and VMS is no longer a thing so it can't be converted.?.
 
In regards to me building a new database in Access to replace the old, IT is concerned that every time we upgrade computers we will have to convert the database to a newer version of Access to make it compatible.  Has this ever been an issue for anyone? 
 
I'm not convinced IT's solution is going to work so I will continue to try to build a database (we would like to implement something by Oct 1 for reporting purposes).  Heads up, I might be asking for a lot of help as I am an extremely rookie Access user - particulary when it comes to the VBA stuff.
 
Thanks for your feedback!
 
Jessica


On Wednesday, August 6, 2014 3:18 PM, "wrmosca@comcast.net [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:


 
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]





__._,_.___

Posted by: Jessica <hobackjessica@yahoo.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (9)

.

__,_._,___