Hi, On the way home from the pizza thing last knight my check engine light came on. My dad wants me to leave my truck here so that he can get it fixed Monday. Can someone please give me a ride from Lafeyette to Baton Rouge next Friday afternoon or Saturday so that I can get my trunk.
Thanks, Steven P. -------------- next part -------------- An HTML attachment was scrubbed... URL: http://oxygen.nocdirect.com/pipermail/general_brlug.net/attachments/20030814/47cdd3a2/attachment.htm From [EMAIL PROTECTED] Thu Aug 14 22:30:26 2003 From: [EMAIL PROTECTED] (Mat Branyon) Date: Thu Aug 14 16:30:27 2003 Subject: [brlug-general] I need a ride next week In-Reply-To: <[EMAIL PROTECTED]> References: <[EMAIL PROTECTED]> Message-ID: <[EMAIL PROTECTED]> I might be going that way that weekend. Ill let you know if I am or not. --mat On Thu, 2003-08-14 at 16:09, [EMAIL PROTECTED] wrote: > Hi, > > On the way home from the pizza thing last knight my check engine light > came on. My dad wants me to leave my truck here so that he can get it > fixed Monday. Can someone please give me a ride from Lafeyette to > Baton Rouge next Friday afternoon or Saturday so that I can get my > trunk. > > Thanks, > > Steven P. > > ______________________________________________________________________ > _______________________________________________ > General mailing list > [email protected] > http://brlug.net/mailman/listinfo/general_brlug.net -------------- next part -------------- A non-text attachment was scrubbed... Name: not available Type: application/pgp-signature Size: 189 bytes Desc: This is a digitally signed message part Url : http://oxygen.nocdirect.com/pipermail/general_brlug.net/attachments/20030814/52fede7f/attachment.bin From [EMAIL PROTECTED] Thu Aug 14 17:57:13 2003 From: [EMAIL PROTECTED] (Doug Riddle) Date: Thu Aug 14 18:57:04 2003 Subject: [brlug-general] OT: MS Access Question, Combining multiple lookups from one table into a single field in another table. Message-ID: <[EMAIL PROTECTED]> Sorry about this off-topic request, but I am in a bind at work and need some help. The Question involves MS Access XP/2000. A little background: I am creating a database for Intelectual Property. 98% of their press starts with a process called Disclosure. The Inventors meet with a panel of experts and lawyers and introduce their ideas. The experts evaluate the idea and see if they know of existing work in the area, and evaluate science and soundness of the idea. The lawyers take notes and follow-up with searches for prior-art. Meaning, does someone already have a patent on a idea close enough to make the new idea not worth pursuing. A disclosure may be presented by one inventor or a team of inventors. Often during the course of a disclosure a group of inventors may be directed to other experts that would be valuable team members. Each Disclosure is assigned a unique number in the for of YYYY-NNN, where YYYY is the current year, and YY is the sequential number in order that the disclosure happened. Meaning, that the 16th disclosure in 2003, would have a disclosure number 2003-16. This number indicates the file number, and if the idea pans out, will become the license number. This system has existed in paper form for decades. IP (Intelectual Property) is picking up, and they want me to put it into a datase. The Problem: Each disclosure number is unique. The inventors are kept in a table with all of their information. One Disclosure can have one or many Inventors. I need a way to select Inventors from a Lookup form/query/table and combine them all into a single text field in a record in the disclosure table. One of the reasons we need to use a lookup to the Inventors table is that we want the data to be uniform, searchable, and consistant. There are others, but I won't bore you. Data entry errors are justification enough. As far as I can tell, MS Access never conceived of this need. While I'll be the first to admit I am not a MS Access guru, I do know it better than the average bear. I have wasted two days messing around with clunky and largely unsuccessful work arounds. I cannot believe there isn't an AppendField object. There has to be a better way to add data to a field without opening the field and typing the data in. My best effort so far has me filling a table, exporting the contents, and importing the data, and it fails without rhyme or reason half the time. Timing issues on when the table is locked no doubt. With more people using the database, it wil only fail more often. I haven't done VB since VB3 that is worth talking about. (I did write a program that even Exxon hands couldn't crash with that though! Geeze, I soaked them for it too. It was great.) Anyway, that is the long (very long) and short of it. I want a way to make to multiple selections from one table and combine them into one field in another table, comma separated, if at all possible. I KNOW this is possible. I am certain it is fairly simple. I am also certain that I will NEVER find it by myself. Please help. I would like to be able to wake up anf go to sleep without coming up with some Rube Goldberg workaround evey three minutes that I can only check when I get to work. Besides, I have a host of other stuff I am also supposed to be doing. Any help is much appreciated! Again, sorry about a Micro$loth question, on this list, but I am at wit's end. Save it. I know what you are thinking. Just answer my plea!!!! ===== Warmest Regards, Doug Riddle http://www.dougriddle.com http://fossile-project.sourceforge.net/ http://www.libranet.com -- "Firearms are second only to the Constitution in importance; they are the Peoples' Liberty Teeth." - George Washington -- __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com
