Recent content by taterease

Issue has been resolved. Regards, Jim

Gang, I've got an Access2003 database. It has been secured using a file "secured.mdw" and everything is working fine - except that we have lost the passwords to the two accounts that have full admin rights. Users are able to get in and function, but only two accounts have full admin rights...

DISTINCT...as in "I'm distinctly an idiot?"... Geez-o-pete, I gotta stop playin' with this database for a few hours. I can't even read anymore... Thanks for pointing it out - and sorry to have bugged ya'll for something I should've caught the first time around!

Hi Guys. Yeah, I did a search for "truncate" before I posted back with the question, I don't wanna bug you guys too much. Here's the query code: SELECT DISTINCT PACKAGE_NUMBER, Concatenate("SELECT item_description FROM tbl_Auction_Items WHERE Package_Number='" & PACKAGE_NUMBER & "'") AS...

I feel like Det. Columbo...just one more thing <g>. When I run the query (which runs gangbusters, thank ya'll very much!) it truncates the package_description to 255 characters, although in the table it's defined as a memo. Some of these auction items will have descriptions longer than 255...

That's it!!!! Thanks gang - I still have to look at the module and query and figure out how it all works (I know a little about DataEase, but Access modules are beyond me <g>). I really appreciate the help on this one.

PHV - Yeah, we've left my knowledge of Access far, far behind at this point <g>. Query: SELECT PACKAGE_NUMBER, Concatenate("Select item_description FROM tbl_Auction_Items where Package_Number =" & [PACKAGE_NUMBER]) AS PACKAGE_DESCRIPTION FROM tbl_Auction_Items; I dunno that makes a whole...

I think I'm getting closer! I'm getting an error message "Type Mismatch" (see below). But if it ain't workin' in practice, I think I have a better understanding of how it's supposed to work! Function Concatenate(pstrSQL As String, _ Optional pstrDelim As String = ", ") _...

Hi Darrylle! tbl_Auction_Items Record_ID (autonum) PACKAGE_NUMBER ITEM_DESCRIPTION DONOR_HISTORY_RECORD VALUE_OF_ITEM AUCTION_TYPE (The above table is the one that shows all of the donated items in one place). tbl_History Package_number Item_Desscription History_ID Value_of_Item Category...

I've been messing with this for awhile and need to call on ya'll for help. 1. We are getting donations of items for an auction and each item description (ItemDescription) and monetary value (ItemValue) is logged into a table (tbl_history) along with other pertinent information. 2. Each item...

I've searched on this one, but don't find the answer (if there is an answer!). I have an Access 2002 application running on a Windows 2003 server. At the end of each day seven staffers log in and launch a report. I can easily regroup the report to run once and show each staffer's section...

BCaster, Thanks! Jim

I've a friend who installed XP Home on a machine that formerly ran Windows 98. XP is running O.K. and she wants to remove any Windows 98 files to reclaim hard drive space. Is there an easy way to do this task? Jim

Thanks, everybody! I was able to make the change in the Registry and it worked like a charm. Jim

Windows XP Pro, IBM T22 laptops Default user on each laptop is in local admin group (for reasons I won't go into here). What we may need to do is prevent users from installing wireless network cards into the card slots (preferably w/o having to snip wires in the hardware <g>). Is there a way...