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!

Register Log in
  • 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. lazaridisaris

    when I try to change the Rowsource in a combo box I get type mishmatch

    Hi all, I have a combo box that has as recordsource "SELECT End_pro.[a-a_End_pro], [End_APO_name] & "-" & [End_STO_Pro_name] AS [Apo pros], End_pro.End_STO_Pro_name FROM End_pro;" in VBA code I search for a specific string which I pass to a variable named TmpVar. and then I MyCMB.rowsource...
  2. lazaridisaris

    how can I tell to access to read from utf-8 text file

    I have some text files that are written in utf-8 encoding. My problem is that when I read the file the special (greek) characters are unreadable. I have used the Set fs = CreateObject("Scripting.FileSystemObject") Set f = fs.getfile(TmpFile) Set ts = f.OpenAsTextStream(ForReading...
  3. lazaridisaris

    Is there a way to rename Table Field names ?

    I have a DB that someone else created at first and he had used Field names that are not proper for canonical use. e.g fields with spaces ("Customer name"). What I want to do is to rename the field and find out where else is been used to rename it there also. Thanks in advance. PS few years...
  4. lazaridisaris

    When a startup Form is enabled then the breakpoints don't work

    I have an Access DB that when I startup th Project without pressing the shift key then the Break into code does not work. My quest is to disable the bypasskey property so users will not be able to see what I dont want them to see. I have created a logon form from which I give access rights to...
  5. lazaridisaris

    Connection through Access with ORACLE and MS SQL SERVER 2000

    Hi to All, My problem is 1. I have an Oracle database which has some tables. 2.I have an SQL 2000 database that has some other tables 3.I have an Access 2000 database The goal is to read a table from Oracle (which I do with ODBC connection) to SELECT some records from there with specific...
  6. lazaridisaris

    Remove non-printable characters in a string

    I am importing data from a text file (unicode) with "|" delimiter. The problem is that this file has some non-printable characters in some fields and when I try to parse the text it hangs with unspesified errors. I wonder if there is a way to clean-up all those characters before inserting the...

Part and Inventory Search

Back
Top