Search results for query: *

Hey Folks! Quick question: does CurrencyVar exist before version 9? Thanks for your help. Luciano R. Humberto IT Specialist - Support (:I The Ryan Companies

Hi Folks, I have an installation with two NT 4.0 (SP6) servers (Main and backup) and SQL 2000 running in both. When I try to run a CDW procedure I'm getting the followig error from a on the database step: Failed to create share OMWWIZD. I know it's related with user permissions but I tried...

Thank you Win98User & Mot98. I ended up deleting all printers (in safe mode I selected all them at once instead of clicking each one individually so the system didn't freeze). I also uninstalled a couple of late installed software (NAV among them), reinstalled everything and now the system...

Hi Folks! The search mechanism of Tek-Tips is down so I could not research before posting. As soon as I enter in printer settings (Start-Settings-Printers) I get the following error message: SPOOL32 caused a stack fault in module KERNEL32.DLL at 017f:bff7a2a1. Registers: EAX=0076fffc CS=017f...

Thanks again, dysphoric! You saved my week! FYI, I marked your post as a helpful. Luciano R. Humberto IT Specialist - Support (:I The Ryan Companies

THANK YOU, dysphoric, THANK YOU VERY MUCH!!!!! This %*$(&^##&^ query was driving me crazy! So the % works like the * in a normal query... It's the multi character wildcard. Is there a specific one for single char? BTW, you were clear enough in the first post. Thank you also for you...

Hi Junior, You are NOT a bother I'm just frustrated with this silly SQL! And your help makes me go to my code and look it from different angles witch is always good! Lets put this: the final SQL I got after the running code substituting the parameters is: SELECT * FROM tblTransmittal WHERE...

Hi Junior, Again, the SQL is OK! there are no spaces inside the parameters because I'm the one giving values to them: strIdentifierDate comes from: strIdentifierDate = CStr(DatePart("yyyy", Me.txtflddatTransmittalDate.Value)) & CStr(DatePart("m&quot...

Hi Junior, Thanks for you trying to help but: A) The cursor is right and can be used with ADO Access. Actually I have to establish a specific cursor because the default cursor type is adOpenForwardOnly and this default does not support RecordCount property. B) I picked up ADO because I'm...

Hi Folks, I have the following function on a Access 2000 based system: Function fncstrIdentifierNumber(strFuncIdentifierDate As String, strFuncIdentifierType As String) As String On Error GoTo Err_fncstrIdentifierNumber Dim rst As ADODB.Recordset Dim strSQL As...

Hi again Rookery, I use a little trick to avoid that. I got this one from "Mastering Microsoft Access 2000 Development" by Alison Balter - Sams ISBN - 0-672-31484-3 (very 'tip full' book, come in handy many times! [reading]). I call the following line in the Open_Form procedure of...

Hi Hookery, No, I've never got the answer. I'm just using /WRKGRP in the shortcut for each system. Didn't find a more elegant way yet (but didn't do much research on that either. You know, the system is performing and there is no much time for refining this kind of detail). Regards, Luciano...

Thanks again Jo! I myself didn't find a easy/secure way yet... By the way, where are you "emailling" from? 'm in Florida/USA (12:00pm now) but it seems you are getting ready to supper already! Best regards! Luciano R. Humberto IT Specialist - Support (:I The Ryan Companies

Thanks Jo & Michael for your help! I like Michael's sugestion of a commom switchboard but it would involve a little more work once not everybory uses all systems... By now I have to use the simplest solution, as you guys recomend, to unassign the application, or put the environment back to...

Hi Folks! :-D In the warehouse that I work at I’ve about five small systems built in Access (2000). Just one holds “classified information” [bigglasses]. Being this way I’ve built a *.mdw just for that system and I use /wrkgrp to assign it to the application during startup (Windows shorcut)...

cdove: BINGO! That was easy, no? :-D I completely overlooked that. I was searching for something wrong in the system configuration (driver/ subnet mask/ parameters in my account in the server/ configuration of the NIC card). I absolutely forgot to check that (once the service was shown in the...

Hi Folks! :-D Quick question: why my workstation is not being listed in the Network Neighborhood anymore? It used to be and I used to exchange files with other coworkers through the network but no more. I can still "see" the other computers and I can copy files from the others in to...

Hi JennieM: Just now I've received your post. Sorry for not answering earlier but Naith was around to help you :-D... Maybe I'll help you another time... Best regards! Luciano R. Humberto IT Specialist - Support (:I The Ryan Companies

dgillz: ?!?!?!?!? "Can be done in seconds"? "Have not told you everything"? Now you've got it! I'm feeling really stupid! [thumbsdown] There it goes again: A while ago I did a report with 50 diferent Specified Groups, some with more than one condition for the group (nice...

Chris777: Thanks for your help. Its a way, but again I was looking for something like the formula editor that could be used with Specified Group. In resume Specified Group is not more than a bunch of IFs somewhere in the report structure. I was loking for a way to get to that structure and be...