Search results

By "allow list edits" do you mean "allow value list edits"? If yes I set it to "no". "Limit to List" is yes. But still does not work.

Hi experts, I have the following problem. I have a form that contains a combo box and a run command button. The combo box has a lookup table used rowsource for the combo. The combo has 2 columns and can have many rows. What I want to do is to protect the combo against any data entry and have...

I found the solution. Her is code that does exactly the job. SELECT TelephoneAAA.ADI, TelephoneAAA.SOYADI, TelephoneAAA.TEL, TelephoneAAA.ADRES, TelephoneAAA.DateOfUpdate FROM( (TelephoneAAA INNER JOIN DupsByAdi ON TelephoneAAA.ADI = DupsByAdi.ADI) INNER JOIN DupsBySoyadi ON...

Further to this subject I found the following solution. It works: SELECT TelephoneAAA.ADI, TelephoneAAA.SOYADI, TelephoneAAA.TEL, TelephoneAAA.ADRES, TelephoneAAA.DateOfUpdate FROM (( TelephoneAAA INNER JOIN DupsByAdi ON TelephoneAAA.ADI = DupsByAdi.ADI ) INNER JOIN DupsBySoyAdi ON...

Sorry plog I can not upload the databases (Test and data) due to an error I am getting and it tells me there is a security issue and to contact the webmaster.I have no time to deal with the uploading issue. I"ll have to look for another solution. Thanks for all your efforts

Here is the latest version of code that does not work. I have deleted the comma. SELECT TelephoneAAA.ADI, TelephoneAAA.SOYADI, TelephoneAAA.TEL, TelephoneAAA.ADRES, TelephoneAAA.DateOfUpdate FROM TelephoneAAA INNER JOIN DupsByAdi ON TelephoneAAA.ADI = DupsByAdi.ADI INNER JOIN DupsBySoyAdi ON...

Neither comma deletion nor putting "AND" do not work. I may try to upload the db, but due to data privacy it will take time. In the meantime I will see if I can find another solution.

I have done exactly that. The subs work, but the final one does not. Perhaps it is something very obvious but I can't see it. The error message is "Syntax error" SELECT TelephoneAAA.ADI, TelephoneAAA.SOYADI, TelephoneAAA.TEL, TelephoneAAA.ADRES, TelephoneAAA.DateOfUpdate FROM TelephoneAAA INNER...

That is what you said. First SELECT joins the first query and the table and second SELECT joins the second query and the table. Now it is in three steps. If you think that more steps are needed I would be pleased to hear. I am using the design wizard and view. That is how I constructed the...

I have done what you said, but what do you put between two queries to intersect them. Here is the code and it rejects the operator And. (SELECT TelephoneAAA.ADI, TelephoneAAA.SOYADI, TelephoneAAA.TEL, TelephoneAAA.ADRES, TelephoneAAA.DateOfUpdate FROM ([TelephoneAAA] INNER JOIN [DupsByAdi] ON...

Well here it is referring to a query which is my subquery.

Sorry but for the first time I am going to do this. I wrote this code: SELECT TelephoneAAA.ADI, TelephoneAAA.SOYADI, TelephoneAAA.TEL, TelephoneAAA.ADRES, TelephoneAAA.DateOfUpdate FROM ([TelephoneAAA] INNER JOIN [QUERIES]![DupsByAdi] ON TelephoneAAA.ADI = [QUERIES]![DupsByAdi].[ADI] ) And...

Hello experts. I have a table called TelephoneAAA. I should run a query to find duplicate records based on a Field called ADI and a second query to do the same based on a field called SOYADI. I have used the Access query creation wizard To create both queries. Individually they work, but I want...

I am trying to import a VCF file as a text file into a database interactively.Once I have successfully done that I will store the input procedure and use it in a VBA module. The problem is when I use the External data import procedure it gives me the choice to select a text file. But then...

Worked like charmingly. Thanks a lot.

I have a table, whıch is created by using the Docmd.Transfertext procedure that takes the first row of the input csv file as column names of the table. How can I using SQL and VBA find the names of these columns so that I can use them in a query.

Thank you it worked Charmingly.

Dim db As DAO.Database Dim rs As DAO.Recordset Dim rt As DAO.Recordset Set db = CurrentDb Set rs = CurrentDb.OpenRecordset("Tele") Set rt = CurrentDb.OpenRecordset("TelephoneAAA")

Based on the two suggestions I tried Various alternatives such as rs.FindFirst "[Tele].[Telecon] = 'TT'" and rs.FindFirst "[Tele].[Telecon] LIKE '*TT*'" but I keep geting the same message with error number 3251.

Hi Everybody, I am using ACCESS 2013. My recordsets and tables are all DAO. There are no indexes. But I can not run the FindFirst statement. Each time it says this method is not supported for this kind of object. Here is the code rs.FindFirst ("(rs.Fields('TeleCon') = TT)") If Not...