Search results

Hello experts, I have kind of an unusual problem. There is a table with many columns. I want to add many rows to this table. The easiest way is to write a query to do that. But most of the columns have validation criteria, lookup tables, default values, nulls not accepted condition and what...

Re: SQL SELECT not accepted [SOLVED] That was the key point. I made a query from the sql statement and made it the RecordSource of a form containing the required fields. That was the solution. Thanks to all contributions.

The query below is rejected saying it is not an SQL statement. I can not find the error. Help please. Dim strSQL As String ' Diplays MembersTBL strSQL = "SELECT MembersTbl.NOM, MembersTbl.PRENOM, MembersTbl.EMAIL, MembersTbl.LANG, " & _ " MembersTbl.Federation " & _ " FROM...

Re: SQL creates linked table in front end.SOLVED I have done what you said. The problem is solved. Here is the result. Many thanks. "INSERT INTO TransUPDSHTbl SELECT MembersTbl.MemID, TransSHTbl.FirstName, TransSHTbl.LastName, " & _ " TransSHTbl.Language, TransSHTbl.Email...

No I am not using the reserved word Table. Let me give more info on the problem: In backend I have TransSHTbl and TransUPDSHTbl that are linked to frontend. In frontend in a module I use the code: DoCmd.RunSQL "DELETE * FROM TransSHTbl;" DoCmd.RunSQL "INSERT INTO TransSHTbl SELECT * FROM...

Yes but assuming that Table is the table_name isn't that exactly what I am using?

Hello Experts, I have a frontend and a backend database. As usual i keep the tables in the backend. Now I have some tables which need to be emptied and then refilled. I empty the table using the code DoCmd.RunSQL "DELETE * FROM TransNMTbl;" then I fill in the table using DoCmd.RunSQL "INSERT...

Gentlemen, I have taken all your advice into account, copied structure and data to an empty table with a slightly different name and field names. Here is the result a working query: RowSQL = "SELECT [TelephoneAAA].[TelefID], TelephoneAAA.ADI, TelephoneAAA.SOYADI, TelephoneAAA.ADRES, * " & _...

I can not get the following SQL query to work. Help please. RowSQL = "SELECT [Telephone].[TelefID], [Telephone].[FIRST], [Telephone].[LAST], [Telephone].[ADDRES], * " & _ "FROM [Tables].[Telephone] " & _ "WHERE [Telephone].[FIRST] Like ""&%Sozcuk=%&"";"

Hello Experts, I have a problem. Consider two tables. Table1: name=TargetTbl, fields=operation (number),Libelle1 (Text) Table2: name =TextArrayTbl, fields=Sequence (number), Sorter (number), Phrase(Text). Table1 has around 1000 records, Table2 has around 36000. They are linked via the fields...

Yes of course I remember those days. What a revolution it was to have such a capability on a PC. dBase I never existed on the market the beginning point was dBaseII. Then came dBaseIII and dBAseIV. We have an application which was written in dBaseIV around at that time. The user can not let go...

It looks as though noone is converting dBaseIV files any more. The old software must be totally dead now.

I replaced the first two subs (Sorry one function is copied twice) with the following: Sub ImportConfederationTransactions(inputcsv, ORG, dest) Dim LogFile As String, LogPath As String, Lim As String, I As Integer, J As Integer, K As Integer, InFeder As String LogPath = Left(inputcsv...

I replaced the transaction input concept by DoCmd.TransferText statement as a stored procedure. The problem disappeared. Instead of wasting time on this application logic problem I preferred this solution. Thanks to all those who rushed in to help.

OK. I managed to solve the problem by replacing the queries as follows: RecordSource = "TargetTbl" RowSource = "SELECT TextArrayTbl.Sorter, TextArrayTbl.Phrase FROM TextArrayTbl LEFT JOIN TargetTbl ON TextArrayTbl.Sorter = TargetTbl.Operation WHERE...

The theater is as follows: A continuous form with fields Operation bounded integer, LibelBx unbounded combobox string with two columns as Sorter (Int), Phrase(str). A table TargetTbl with field Operation(Int). A table TextArrayTbl with fields Phrase(str), Sorter(Int). Relationship between...

You are right. On double checking I found one of the fields namely Language was LANG in the table. Now it works. Thanks a lot.:http://images.access-programmers.co.uk/forums/images/smilies/smile.gif

Yes ORG contains a string of two chracters suc as SH, AR etc.. It comes as a parameter in a function call from another sub. I display it to be sure it contains the right values. No it does not contain quote or apostrophe. Nevertheless I tried your code it did not work. Same place same message...

I have tried the code it says Error 3061 too few parameters Expected 1 It fails at the last statement.

The code below fails. Dim ResultQy As String, qdf As QueryDef Dim ResultFm As String ResultQy = "ByFederationQy" Dim strSQL As String 'sql statement to execute strSQL = "SELECT [MembersTbl].[Federation], [MembersTbl].[NOM], [MembersTbl].[PRENOM], " & _...