usmc-ratman

Ok - I need to make a correction / better list out my tables and their structure, which I realized I failed to do originally... so here goes. Table 1: "Client List" Fields are: ID Lname Fname dob status Table 2: "Atty_Pmt" Fields are: Atty_PmtID Date PayAmt PayNotes ClientList_ID Thanks to all, JR

I'm running access 2k, WinXP Pro SP2 - both are current with latest updates. I'm having a problem getting the select query behind a report to give me the results I need. The query works with two tables (clientlist and payments). Payments is related to clientlist on a one-many relationship, using ClientList_ID primary key. The payments table structure is as follows: Atty_PmtID Date PayAmt PayNotes ClientList_ID The ClientList table has fields like 'lname', 'fname', 'dob', etc, etc. Im trying to structure a query that will list each client, and ONLY the last payment they made. I tried using a select query Top n, making 'n' value 1, and it only lists one client, one payment record, which isnt even the last payment they made. This is the query that I currently have.... SELECT TOP 1 [Client List].ID, [Client List].Lname, [Client List].Fname, Atty_Pmt.Atty_PmtID, Atty_Pmt.Date, Atty_Pmt.PayAmt, Atty_Pmt.PayNotes FROM [Client List] INNER JOIN Atty_Pmt ON [Client List].ID = Atty_Pmt.ClientList_ID; Can someone tell me how to single out the most recent payment (either by greatest date - maybe closest date to current date - or by the 'Atty_PmtID' field). It could possibly be based on the 'Atty_PmtID' field because the payments are entered in order as they come in, so the most recent payment would be the higher 'Atty_PmtID' autonumber, but I just dont know. Thanks in advance for your suggestions and help JR Semper-Fi!

Platform: WinXP / Access 2k Can someone assist me in a script that would be part of access and will do the following: 1) Press 1st button on a form that will create a folder based on a field entry on that form ---ie: field name [clientname] with entry in the field as "Smith, John Doe (8/14/06)" a) If the folder already exists either give a warn message that it already exists B) Gives the option to cancel this routine (creating the folder), and open the folder. 2) Press 2nd button on a form that will open a folder based on the [clientname] field that the current record is on. ** All the folders being created would be in a central server file that all computers have read/write access to, and is designated as the "L" drive in their networks. ** A consideration would be the folder name creation, since some of the [clientname] fields do include / may include invalid characters for folder names, so that in the example above, the "/"s would be changed to "-"s I do understand access pretty well (but am always learning), and have limited knowledge on scripting, so any help would be greatly appreciated. Thanx - JR Semper Fi

IcemanND - Thanks - just had a brain fart I guess. Looking right over the answer. Report must use "sort / grouping" options. Doesn't have anything to do with sort order of query. JR

Thanks in advance for looking at this: Using Access 2000, have table "ClientList" and table "BillingInfo" Have created a billing report that reports the clients information (contained in "clientlist" table) in the header, and the time tracking (contained in the "billingInfo" table) in the detail section of the report. All very simple. First I just created the data source for the report using a select query. Works great, except I've tried to sort the information by the BillingID field (which is the autonumber primary key field of the "BillingInfo" table), and then by date. When the report is run - the order is descending even though in the select statement it specifies ascending. So I thought, ok I'll beat this - I created a regular query, then based the data source for the report on it. The query, when run by itself, sorts the information correctly.... When the report uses it, its back to descending order ???? Then I thought, aaaalllrrighttt - I'll create a calculated field in the query, make it abs(BillingID) - which then gives me another field in the query to sort on (just in case it didn't like the idea of sorting by a primary key field), and whaala - the query runs fine by itself - It should work in the report. But no - it does not. I also created a new query, then saved the query as a report (then just rearranged the titles as I wanted). This worked great - for a day - then when new records were added to the database, it lost the sort order on the report only, for the new data. The older data was still sorting correctly. How do I get this thing to sort correctly when the report uses the data? Or can the sorting be handled by code placed behind the report? Any ideas or code to place in there to make sure the data is sorted correctly, or even a suggestion as to why the report is changing the sort order would be greatly appreciated. Thank you, John R Semper FI

I'll make the question at short and sweet as possible. I have two programs (FaxTalk and WinPage) that both use the modem. I keep FaxTalk running in the background most of the time. During the day, I need to use WinPage to send text pages to co-workers. To do this I have to close FaxTalk, start WinPage and send the pages, Close Winpage, and restart FaxTalk. The reason that I must do this is because FaxTalk "grabs" the port and if FaxTalk is open Winpage gives me the error, "Error Opening Com Port! Port Id=-3". It does not work the other way around (ie have WinPage open 1st, then open Faxtalk and get an error from Faxtalk). I assume this is because Winpage just sits there and does not lock onto the modem port until it actually goes to send the page, and FaxTalk continuously is monitoring the port for incoming calls. So I was just wondering.... Is there a way to maybe assign an "alias" port id to the modem for one of the applications, temporarity disable the lock that FaxTalk has over the port, give WinPage priority over the port, or something similar. Any Ideas or suggestions. Thank you, John R. Semper Fi OS: WinXP Pro sp1 (all updates - but still leary of sp2) CPU: Dell Diminsion 2400

By the way, who is "chimpy"?

Once again I appreciate your input. You were on the edge of early on with the context menu entries in the registry. I was a few steps behind you I think, but that was because of the learning curve and you already having the knowledge and me doing the research to learn about those particular registry entries. You did great though I really do thank you I've added you to my contact list. JR

Hey all, just wanted you to know that I have solved the problem... At about 2:30am this morning I was surfing in a daze, and I ran across a utility that lists and allows you to change any and all the shell extentions in the registry. The program is called "ShellExView v1.11" I simply disabled ALL the context menus, and then turned them back on one by one until I found the culprit, which turned out to be "Eraser Version 5.7" by www.heidi.ie/eraser. The program is actually a good program, and I have had it installed on several machines for many months. I guess it just flaked out or got corrupted. eidenk - Thanks for the suggestion. Looks like you found the solution about 1 hour before me. If you would like to check out the program ShellExView it can be found at www.nirsoft.net. Anyways.... Thank you all for your suggestions, and many thanks to the site for the education that it provides to those that are willing to learn Semper Fi John R

Yes, that is the only time that those problems arise....

One other thing in ref to the start menu and nav bar... the system tray and nav bar don't actually freeze up (ie I can still click on things in the sys tray and get a response) UNTIL I try and click on the start menu. Once the start menu is stuck in the 'pushed down' mode, then the bar locks. just thought i would clarify that..... JR

Ok - I've changed all the reg keys that you suggested, but it still locks. Also one other symptom.... After it locks I have to use Alt+Tab to switch windows, because the (oh had a brain fart and cant think of the name ) the navigation bar at the bottom with the Start button... it freezes also; the start menu wont open, system tray locks. I just noticed this morning after I accidentally right clicked, that the clock even stops updating the time. Kind of funny in a way, because it made me late for work (it was eternally 7:43am). Anyway.... here is the other key that you requested: [HKEY_CLASSES_ROOT\CLSID\{B95057E0-44DB-11CE-A5D1-00608C83BD3F}] @="Shell Extensions for WordPerfect" [HKEY_CLASSES_ROOT\CLSID\{B95057E0-44DB-11CE-A5D1-00608C83BD3F}\InProcServer32] @="shellwp.dll" "ThreadingModel"="Apartment" My next step (when I get home tonight) will be to just uninstall norton, clean the reg, and reinstall it. Unless I find a solution pretty soon, I will just work my way through all my software until it is corrected. I truely thank ya'll for your help JR

That sounds great!! Although I don't know of a situation where it would not hang, because after having to do the hokey-pokey each time right-click was used, I just stopped using that function until I could research it further. I will try this during lunch when I'm back at the house. I'll let you know... JR

Not sure how to list those modules other than a screen capture. Suggestion on how to do that? And I will get it posted. On the registry keys here they are: [HKEY_CLASSES_ROOT\*] [HKEY_CLASSES_ROOT\*\shellex] [HKEY_CLASSES_ROOT\*\shellex\PropertySheetHandlers] [HKEY_CLASSES_ROOT\*\shellex\PropertySheetHandlers\{3EA48300-8CF6-101B-84FB-666CCB9BCD32}] @="" [HKEY_CLASSES_ROOT\*\shellex\PropertySheetHandlers\CryptoSignMenu] @="{7444C719-39BF-11D1-8CD9-00C04FC29D45}" [HKEY_CLASSES_ROOT\*\shellex\PropertySheetHandlers\{B95057E0-44DB-11CE-A5D1-00608C83BD3F}] @="" [HKEY_CLASSES_ROOT\*\shellex\ContextMenuHandlers] [HKEY_CLASSES_ROOT\*\shellex\ContextMenuHandlers\Symantec.Norton.Antivirus.IEContextMenu] @="{5345A4D5-41EB-4A2F-9616-CE1D4F6C35B2}" [HKEY_CLASSES_ROOT\*\shellex\ContextMenuHandlers\Norton WipeInfo] @="{30424D42-5946-11D2-B8E5-006097C9C6FF}" [HKEY_CLASSES_ROOT\*\shellex\ContextMenuHandlers\{B95057E0-44DB-11CE-A5D1-00608C83BD3F}] @="" [HKEY_CLASSES_ROOT\*\shellex\ContextMenuHandlers\Erasext] @="{8BE13461-936F-11D1-A87D-444553540000}" [HKEY_CLASSES_ROOT\AllFilesystemObjects] [HKEY_CLASSES_ROOT\AllFilesystemObjects\shellex] [HKEY_CLASSES_ROOT\AllFilesystemObjects\shellex\ContextMenuHandlers] [HKEY_CLASSES_ROOT\AllFilesystemObjects\shellex\ContextMenuHandlers\Send To] @="{7BA4C740-9E81-11CF-99D3-00AA004AE837}" [HKEY_CLASSES_ROOT\Directory] @="File Folder" "EditFlags"=hex:d2,01,00,00 "AlwaysShowExt"="" [HKEY_CLASSES_ROOT\Directory\shell] @="" [HKEY_CLASSES_ROOT\Directory\shell\find] @="" [HKEY_CLASSES_ROOT\Directory\shell\find\ddeexec] "NoActivateHandler"="" @="[FindFolder(\"%l\", %I)]" [HKEY_CLASSES_ROOT\Directory\shell\find\ddeexec\application] @="Folders" [HKEY_CLASSES_ROOT\Directory\shell\find\ddeexec\topic] @="AppProperties" [HKEY_CLASSES_ROOT\Directory\shell\find\command] @="C:\\WINDOWS\\Explorer.exe" [HKEY_CLASSES_ROOT\Directory\DefaultIcon] @="C:\\WINDOWS\\SYSTEM\\shell32.dll,3" [HKEY_CLASSES_ROOT\Directory\shellex] [HKEY_CLASSES_ROOT\Directory\shellex\CopyHookHandlers] [HKEY_CLASSES_ROOT\Directory\shellex\CopyHookHandlers\FileSystem] @="{217FC9C0-3AEA-1069-A2DB-08002B30309D}" [HKEY_CLASSES_ROOT\Directory\shellex\CopyHookHandlers\CDF] @="{67EA19A0-CCEF-11d0-8024-00C04FD75D13}" [HKEY_CLASSES_ROOT\Directory\shellex\CopyHookHandlers\MyDocuments] @="{450D8FBA-AD25-11D0-98A8-0800361B1103}" [HKEY_CLASSES_ROOT\Directory\shellex\ExtShellFolderViews] [HKEY_CLASSES_ROOT\Directory\shellex\ExtShellFolderViews\{5984FFE0-28D4-11CF-AE66-08002B2E1262}] "PersistMoniker"=hex(2):66,69,6c,65,3a,2f,2f,43,3a,5c,57,49,4e,44,4f,57,53,5c,\ 77,65,62,5c,66,6f,6c,64,65,72,2e,68,74,74,00 [HKEY_CLASSES_ROOT\Directory\Background] [HKEY_CLASSES_ROOT\Directory\Background\shellex] [HKEY_CLASSES_ROOT\Directory\Background\shellex\ContextMenuHandlers] [HKEY_CLASSES_ROOT\Directory\Background\shellex\ContextMenuHandlers\New] @="" [HKEY_CLASSES_ROOT\Folder] @="Folder" "EditFlags"=hex:d2,01,00,00 [HKEY_CLASSES_ROOT\Folder\DefaultIcon] @="C:\\WINDOWS\\SYSTEM\\shell32.dll,3" [HKEY_CLASSES_ROOT\Folder\shell] @="" [HKEY_CLASSES_ROOT\Folder\shell\open] @="" [HKEY_CLASSES_ROOT\Folder\shell\open\ddeexec] "NoActivateHandler"="" @="[ViewFolder(\"%l\", %I, %S)]" [HKEY_CLASSES_ROOT\Folder\shell\open\ddeexec\application] @="Folders" [HKEY_CLASSES_ROOT\Folder\shell\open\ddeexec\topic] @="AppProperties" [HKEY_CLASSES_ROOT\Folder\shell\open\ddeexec\ifexec] @="[]" [HKEY_CLASSES_ROOT\Folder\shell\open\command] @="C:\\WINDOWS\\Explorer.exe /idlist,%I,%L" [HKEY_CLASSES_ROOT\Folder\shell\explore] @="" [HKEY_CLASSES_ROOT\Folder\shell\explore\ddeexec] "NoActivateHandler"="" @="[ExploreFolder(\"%l\", %I, %S)]" [HKEY_CLASSES_ROOT\Folder\shell\explore\ddeexec\application] @="Folders" [HKEY_CLASSES_ROOT\Folder\shell\explore\ddeexec\topic] @="AppProperties" [HKEY_CLASSES_ROOT\Folder\shell\explore\ddeexec\ifexec] @="[]" [HKEY_CLASSES_ROOT\Folder\shell\explore\command] @="C:\\WINDOWS\\Explorer.exe /e,/idlist,%I,%L" [HKEY_CLASSES_ROOT\Folder\shellex] [HKEY_CLASSES_ROOT\Folder\shellex\ExtShellFolderViews] [HKEY_CLASSES_ROOT\Folder\shellex\ExtShellFolderViews\{5984FFE0-28D4-11CF-AE66-08002B2E1262}] "PersistMoniker"="file://C:\\WINDOWS\\web\\default.htt" [HKEY_CLASSES_ROOT\Folder\shellex\ContextMenuHandlers] [HKEY_CLASSES_ROOT\Folder\shellex\ContextMenuHandlers\Symantec.Norton.Antivirus.IEContextMenu] @="{5345A4D5-41EB-4A2F-9616-CE1D4F6C35B2}" [HKEY_CLASSES_ROOT\Folder\shellex\ContextMenuHandlers\Norton WipeInfo] @="{30424D42-5946-11D2-B8E5-006097C9C6FF}" [HKEY_CLASSES_ROOT\Folder\shellex\ContextMenuHandlers\Erasext] @="{8BE13461-936F-11D1-A87D-444553540000}" [HKEY_CLASSES_ROOT\Folder\shellex\DragDropHandlers] [HKEY_CLASSES_ROOT\Folder\shellex\DragDropHandlers\Erasext] @="{8BE13461-936F-11D1-A87D-444553540000}" Also, Incase you are wondering about the registry entries referring to "Erasext", that is the program "Eraser". I've had it on several computers for a few years. I can give you more information if needed. Thank you for your review and help. By the way, I tried the context menu (right click) after the registry tweak you suggested, but it still froze. I will try it again after rebooting. John R.

No I haven't - I was trying to do this the least painful way, if you know what I'm talking about . If I was to do that I would have to go through the hokey-pokey to get all the software re-installed again. Thanks for the reply though. If at all possible I'm looking for the area in the registry that address the context menus and those "metrics" as MS likes to call them. John R. Semper Fi

This is one that I have been wrestling with now for about 3 months. My system is 350mhz, pent II, w/ 256mb ram, running Win98SE. I believe that all my critial updates are installed, except for the one concerning the mouse (can't remember the KB #). Everything works fine EXCEPT, I can't right click on anything without the system semi-freezing, and it also extends to copy/cutting files from inside explorer windows. I can do all this manually through a command prompt, but trying to do anything through a context (right click) menu or top line menu in explorer windows locks that window. I can still use ALT+TAB to switch between windows if there are multiple windows open. If I have an directory window open and right click, it freezes that window to where it cannot be closed. If I do CTRL+ALT+DELETE and select end task, or use a 3rd party program such as "killbox" or "process explorer", they may close the program so that it does not show up in the task manager, but the image of the window still remains on the screen. I believe that this may be an error or something wrong in the registry, like maybe the commands that control the context menus, but I have yet to be able to track it down. Anyone with a similar problem, or suggestions would be greatly appreciated. As a side note, I know exactly when the problem started was with the update of the mouse KB I mentioned above (and that topic still remains as a sticky thread in the forums). However, I have uninstalled that update. I have run all the conventional spyware/adware/antivirus programs, and nothing is identified. Advanced thanks for any help or suggestions on where to check in the registry or indepth registry key sites that I can review. John R. Semper Fi

Hey Guys - Those were all great ! I have utilized both of them (independently), and learning from them. I really appreciate you all. I routinely search several forums, but I do like what I see here much better. I guess we can close this thread (by the way - how do I show the thread solved / closed) Thanks again, John R USMC-Ratman

gunsmokingman - Thank you for the script. First I read through the code, which I understood most of it (I'm limited in my knowledge of scripts at this time, but learning), and from reading the code I thought that after it identified my CD drive and opened it, it would then prompt me again to close the CD tray, but it doesn't. Then I went in the script and took out the ' marks at the beginning of the following lines: A1= msgbox ("Press key To Close Cd" & vbcrlf &_ " The Cd Will Close", 0 + 64, "Open Close Cd Tray") For d = 0 to colCDROMs.Count 1 colCDROMs.Item(0).Eject Next 'null Thinking that maybe that would give me the prompts for closing the cd, but it gave me an error as Line:26 Char: 35 Error: Expected end of statement Code: 800A0401 I tried tinkering around with it, but didn't work. I appreciate your help - and so far I think we are half way there. Something that may be important is that I have two cd drives (designated as E and F), I noticed that it identifies the E drive first, opens it and then pauses and opens the F drive also. This is fine that it opens both of them if that can't be corrected, but now the issue left is getting the script to command the drives to close. Any tweaking on your script would be greatly appreciated to get it to work. Thank you again, John R.

Quick question: Anyone know any code that can be run to open AND close a specified CD drive. I know that this seems like a really stupid question, but ..... It does not necesarily have to be vbscript, if someone knows a command line operation that will do the same thing, or a registry tweak/shortcut that can be created in windows to do it. Basically the same thing as the context menu (right clicking) in windows where it shows "Eject". Like I said, sounds like a weird question, but I would appreciate some help. Thank you, John R usmc-ratman OS: WinXP SP1