Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. kashew

    Excel password protection

    This is an internal company spreadsheet. I finally found the author and got the password.
  2. kashew

    Excel password protection

    I need some help on unprotecting a spreadsheet. I've got an app that runs in an Excel spreadsheet written in VB. The main menu options FORMAT, TOOLS, DATA are disabled. I can get to the VB editor but I don't know enough about VB to figure out how to enable the menu options. I need to view all...
  3. kashew

    Serial Port

    I'm using TurboPower's Asynch Pro to read serial input with function ApdComPortTriggerAvail(). My data packet size if 14 chars sent one second apart.Everything works fine on my 1.4GHz laptop. However, the data gets separated on my 1.7GHz desktop. Does anyone have any idea what is causing this...
  4. kashew

    ALTER COLUMN

    I'm using Access 2000. I need to change a field to type DOUBLE FIXED with 2 decimal places. ALTER COLUMN DOUBLE works fine, but ALTER COLUMN DOUBLE(Fixed,2) doesn't work. Can someone help me please?
  5. kashew

    MBF to ASCii

    I have several .BAS files saved in the old MBF binary format with Quick Basic 4.5. Does anyone know of a utility that will read this and convert it to ASCii? I don't have a copy of Quick Basic 4.5.
  6. kashew

    FrontPage Counter

    I'm using FrontPage 2000. When I insert a FrontPage component counter on a page, the counter shows up on all pages. I only need the counter on my home page. How would I go about inserting the FrontPage counter on just the home page?
  7. kashew

    SEARCH FOR FILES does not work

    I have recently discovered three problem with my W2K: 1. "Search for files and folders" does not work anymore. 2. I get a "Internet Explorer Script Error" when opening OutLook 2000. 3. When I open c:\Program Files or C:|WinNT folders I get A "Internet Explorer script...
  8. kashew

    ThresholdDate as a condition

    I need to create a condition that selects a date field that is less than 90 days old. I tried using ThresholdDate(TODAY, -90) as a condition and it doesn't work. Does anyone know how to do this?
  9. kashew

    Linking data to Excel

    I'm having a problem with data shifting between columns when I update an Excel 2002 spreadsheet with an Access 2002 link. This is only occurring on some PCs. I've compared MDAC and Jet versions on all PCs and they match. Are there other files that may not be current version? Or does anyone know...
  10. kashew

    Access 2002 upgrade questions

    I'm thinking about upgrading from Access97. Can someone tell me what type of registration MS is requiring with the 2002 product? Is the software going to stop working after a certain period of time if it is not properly registered?
  11. kashew

    Excel data shifts with MS Access Link

    I have an intermittent problem that I haven't been able to trace. I have an Access2002 database linked to an xls file. I update some of the fields in the xls file with data from an Access table. Periodically, some of the XLS column data of the non-linked fields (manually entered) shifts over to...
  12. kashew

    Excel Link shifts spreadsheet data

    I have an intermittent problem that I haven't been able to trace. I have an Access2002 database linked to an xls file. I update some of the fields in the xls file with data from a table. Periodically, some of the column data in the non-linked fields (manually entered) shifts over to the left...
  13. kashew

    Lucent/Ascend DSL Pipe Need Software Help!

    I have question regarding the db9 cable. Is the cable a null modem cable or straight through?
  14. kashew

    "ODBC - call failed" Error Msg

    I've already tried that. It doesn't work. I'm now being told that MS Access does not work very well with Oracle. I'd like to find a way to make it work. I'm sure someone out there has run across this problem before.
  15. kashew

    corrupt l_intl.nls

    I just upgraded my system from an Athlon to a pentium IV. I imaged the disk to the new system successfully. However, on boot I keep getting an error "missing or corrupt \WINNT\SYSTEM32\l_intl.nls" I run CHKDSK /R from the recovery console and it fixes an error. Then I boot...
  16. kashew

    Parameters in criteria

    Yes, you understand correctly. What you suggest is what I've done and it does not work for some reason on my Oracle database. I've done this with Sybase database with no problem. There is obviously something different about Oracle. When I replace [Region?] with a value "North" in...
  17. kashew

    Access Query problem

    I've run into the same problem when using parameters in Access to query an Oracle database. Have you solved the problem yet?
  18. kashew

    "ODBC - call failed" Error Msg

    I'm connected to an Oracle database and trying to set a parameter in an MSAccess query when I receive the above error msg. The WHERE portion of the SQL in Access looks like this: WHERE (TABLENAME.FIELDNAME)=[Forms]![FormName]![value]; The error goes away when I replace the parameter with a hard...
  19. kashew

    Automating Oracle Login

    Does anyone know how to code an automatic login to Oracle i.e. username and password from Access?
  20. kashew

    Parameters in criteria

    I've got a parameter value called [REGION] as a field criteria. When I execute the query and input the parameter value in the dialog box, I get no data. If I replace the [REGION] parameter in the criteria field with the actual value that I types into the dialog box, I get data. Does anyone know...

Part and Inventory Search

Back
Top