Search results for query: *

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...

Hey guys. DNS wasn't the main problem - seems some spyware had installed it's own proxy. I ran msconfig and removed the proxy from start up, then ran regedit and removed winsock and winsock2, rebooted, reinstalled tcp/ip, restarted and everything is working. Thanks much for the suggestions. Jim

Hi Steve, Not exactly - I've a fellow who has a home network; the wireless laptop has no issues with the cable modem/router, but the desktop computer suddenly can't resolve DNS names; he can ping yahoo's number and such, but can't browse with I.E. or ping by name. I'm headed over to his home...

Steve, Have you resolved this issue? If so, how? I'm experiencinga similar problem... Thanks! Jim

I've a form which has a date field (format mm/dd/yyyy); in the form properties before update I want to run a code sequence which will modifiy two other fields on the form (month_date and year_date) to the proper month and year. Thus: date_field = 11/01/2004 would result in month_date =...

Thanks, Duane. The soluttion was that Word wasn't looking for DDE data sources...a long, involved story <g>. The user is in an office about 2.5 hours from my location and using a REALLY old Word doc that I set up several years ago. I haven't updated the related Access app in ages, and out of...