Jumat, 18 Mei 2012

Re: [MS_AccessPros] Auto Number and duplicates

 

Liz

I saw something called Microsoft Lightswitch which looks rather appealing but nobody is using it. It is new but do not want to waste time learning something and it crashes and burns. I looked up recordsets and some videos. It looks powerful. I will need to learn more to see if it applies to us. 
 
Jim Wagner
________________________________

________________________________
From: Liz Ravenwood <liz_ravenwood@beaerospace.com>
To: "'MS_Access_Professionals@yahoogroups.com'" <MS_Access_Professionals@yahoogroups.com>
Sent: Friday, May 18, 2012 1:01 PM
Subject: RE: [MS_AccessPros] Auto Number and duplicates


 
Jim, I use recordsets all the time. Currently I'm needing to build a subform based on a subset of data, but I'm going to need to crawl through the data sequentially to determine if it belongs or not based on a level - cycling past a found record until a certain level matches a hold level etc.

I'm sure if you google recordset examples you'd find some.

I have the same issue as you in that I'm wanting to learn some new technology but I have a hard time learning something unless I have something REAL to do. Currently, I'm wanting to learn Silverlight and haven't found any examples other than video streaming. I was thinking it was a way to visualize data in some cool and creative ways, but I'm just not finding anything yet.

Liz Ravenwood
Database Developer / Programmer
Super First Class Products
B/E Aerospace
O: 1.520.239.4808
www.beaerospace.com

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Jim Wagner
Sent: Friday, May 18, 2012 11:31 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Auto Number and duplicates

Liz

That is another thing that I would love to learn. I guess because I do not understand what they are used for and how to apply them, I have not stepped into the world of recordsets. I do think that they can be applied in several of our databases, but I will need to understand them first.

Jim Wagner
________________________________

________________________________
From: Liz Ravenwood <liz_ravenwood@beaerospace.com>
To: "'MS_Access_Professionals@yahoogroups.com'" <MS_Access_Professionals@yahoogroups.com>
Sent: Friday, May 18, 2012 11:12 AM
Subject: RE: [MS_AccessPros] Auto Number and duplicates

Jim, have you played with recordsets? I use DAO and once I got a handle on the recordset idea, my programming and my ability to do things for my user's really took off. I don't know how many databases I've created because some just fallen by the wayside, but I collect log in stats and I have 33 active ones with an average of 22 open daily.

Liz Ravenwood
Database Developer / Programmer
Super First Class Products
B/E Aerospace
O: 1.520.239.4808
www.beaerospace.com

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Jim Wagner
Sent: Friday, May 18, 2012 11:04 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Auto Number and duplicates

Liz

That is probably over my head right now, but that would be really great. We support about 75 databases and would love to get into class modules. I have been trying to also learn how to connect a SQL database to Access.

Jim Wagner
________________________________

________________________________
From: Liz Ravenwood <liz_ravenwood@beaerospace.com>
To: "'MS_Access_Professionals@yahoogroups.com'" <MS_Access_Professionals@yahoogroups.com>
Sent: Friday, May 18, 2012 10:48 AM
Subject: RE: [MS_AccessPros] Auto Number and duplicates

Jim,

You and me both. I want to learn how to expand in to learning class modules and add-ins. I've got the same code in several databases and I wouldn't mind more tips and tricks in how to modularize from shared libraries.

Liz Ravenwood
Database Developer / Programmer
Super First Class Products
B/E Aerospace
O: 1.520.239.4808
www.beaerospace.com

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Jim Wagner
Sent: Friday, May 18, 2012 10:44 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Auto Number and duplicates

Bill

I do love Access. I took a class in Jr College years ago when I was learning about computers that taught about the office suite. The last 2 weeks of the class was about Access. I was hooked and decided to get a certificate in Database Management. After that I went for my Bachelors in computer information then a job building databases. All because of 2 weeks of an office class introducing Access. I wish I knew more about programming to make access more functional.

Jim Wagner
________________________________

________________________________
From: Bill Mosca <wrmosca@comcast.net>
To: MS_Access_Professionals@yahoogroups.com
Sent: Friday, May 18, 2012 8:22 AM
Subject: Re: [MS_AccessPros] Auto Number and duplicates

Jim

Don't ya just love Access?! Glad you got it fixed.

Bill

--- In MS_Access_Professionals@yahoogroups.com, Jim Wagner <luvmymelody@...> wrote:
>
> Bill
>
> I did not get any records back which is great.
> Â I think that I figured out how the whole mess happened. I have a form that shows Tasks or projects that are active. I have the TaskID setup so that when the user clicks the taskid on the active form the main data entry form opens and then is filtered to that specific taskid. Well the macro that filters that form had stopped working and I did not notice that the form was not on the correct record. I was adding records to the wrong record. Because it happened on the same day or close to it, I questioned it. Well I clicked on one of the taskid's to edit the record and noticed that the current record did not have multiple records in the subform. It was a big red flag. So I tested it again and realized it had broken. I fixed the macro and all is well.Â
>
> Thank You for your help
> Â
> Jim Wagner
> ________________________________
>
>
>
> ________________________________
> From: Bill Mosca <wrmosca@...>
> To: MS_Access_Professionals@yahoogroups.com
> Sent: Friday, May 18, 2012 7:43 AM
> Subject: Re: [MS_AccessPros] Auto Number and duplicates
>
>
> Â
> Jim
>
> That may very well be. Run a query to find your orphans like this:
> SELECT MyField
> FROM childtable LEFT JOIN parenttable
> ON childtable.parentkey = parenttable.parentkey
> WHERE parenttable.parentkey is null
>
> That will return all the orphans. Hopefully, you don't have to spend the rest of the year fixing these.
>
> Bill
>
> --- In MS_Access_Professionals@yahoogroups.com, Jim Wagner <luvmymelody@> wrote:
> >
> > Bill
> >
> > I was able to get it working like you said, but the relationship between the 2 tables shows indeterminate not one to many. I think that I need to change those records in the second table to the correct taskId
> > ÂÂ
> > Jim Wagner
> > ________________________________
> >
> >
> >
> > ________________________________
> > From: Bill Mosca <wrmosca@>
> > To: MS_Access_Professionals@yahoogroups.com
> > Sent: Wednesday, May 16, 2012 11:27 AM
> > Subject: Re: [MS_AccessPros] Auto Number and duplicates
> >
> >
> > ÂÂ
> > Good greif, Jim! this is going to take some manual editing. Set the relationship to cascading updates.
> >
> > 1. Open the table in design view and change the Autonumber to a Number(long) data type.
> > 2. Create a Find duplicates query to get a list of all your dups.
> > 3. Open the parent table in datasheet view, sort by the autonumber and change each dup's value to the highest value + 1
> > 4. run your dups query again to make sure you caught them all.
> >
> > 5. right-click the table and select Copy.
> > 6. in a blank area where the tables are, right-click and select Paste / Structure only.
> >
> > 7. Now change the long in the new table to an autonumber with a unique index.
> > 8. use an append query to append everything into the new table.
> > 9. Remove the relationship between the old table and its child table.
> > 10. rename the old to something like MyTable_original; rename the new table to MyTable.
> > 11. set up your relationship to the child.
> >
> > Hopefully, if you did everything right (and I didn't forget a step) you will be where you want to be.
> >
> > Regards,
> > Bill Mosca, Founder - MS_Access_Professionals
> > http://www.thatlldoit.com
> > Microsoft Office Access MVP
> > https://mvp.support.microsoft.com/profile/Bill.Mosca
> >
> > --- In MS_Access_Professionals@yahoogroups.com, Jim Wagner <luvmymelody@> wrote:
> > >
> > > I failed to mention that there is a related table with task details that are linked together
> > > ÂÂÂ
> > > Jim Wagner
> > > ________________________________
> > >
> > >
> > >
> > > ________________________________
> > > From: luvmymelody <luvmymelody@>
> > > To: MS_Access_Professionals@yahoogroups.com
> > > Sent: Wednesday, May 16, 2012 10:33 AM
> > > Subject: [MS_AccessPros] Auto Number and duplicates
> > >
> > >
> > > ÂÂÂ
> > > Hello everyone,
> > >
> > > I just discovered that my Auto number has duplicates. So I checked the design and it has Yes(Duplicates OK). First of all my ignorance was that I always thought Auto numbers would be indexed as no dups. So Now how do I renumber these tasks?
> > >
> > > Thank You
> > >
> > > Jim Wagner
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
> [Non-text portions of this message have been removed]
>

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

------------------------------------

Yahoo! Groups Links

This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

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

------------------------------------

Yahoo! Groups Links

This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

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

------------------------------------

Yahoo! Groups Links

This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

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

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar