Search results for query: *

Thanks PHV That did the job. It worked fine Thanks again Aris

Thanks for you time but I already tried that and also the & chr(34) & TmpVar & chr(34) but still getting the type mismatch error regards

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

I just tried it out with no luck. It returns characters in a format readable only from Html pages. But either way thanks for your time. I will keep looking. Regards

Although my Spanish are fake I will try this and let you know for the results. Thanks Aris

the tristateTrue is = -1 and the Option Explicit is there but Greek Letters are not showing at all Only if I Open with Notepad the text file And save it as Unicode from UTF-8. Then I can read it through Access without any problem. Do you know a way to do it through VBA instad doing it manualy...

If you take a look at my initial post is the first that I have tried. But thanks

thanks for your reply. This is correct but i want to do it from VB code to manipulate what is in the data. Is it possible to do it through VBA?

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

Yes I found that the Hard way :) KALHMERA

Thanks for your Time I will have a look at the link Regards Aris

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

I found in forum that only if the allowbypasskey is enabled then you can debug the code is that right? Thanks

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

Thanks for your time I will try this and let you know what happend Regrads Aris

den vgazo tipota 2109409569 aris

Den diavazontai ta ellinika poios eisai ?

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

You could use this Code to Check and relink tables Public Function CheckLinks() As Boolean ' Check links to the database; returns True if links are OK. Dim rst As New ADODB.Recordset Dim StrSQL As String On Error GoTo HandleErr ' Open linked table to see if connection...

Have you tried the On Error GoTo ErrSomething .... ..... ..... ...... ErrSomething: if err.number = Somenumber then DoSomthing