Search results

Well that is not the case. I have 10 of these tables and Each one is handled differently. Of course there may be changes in the design of the system, which may render other solutions. But this is an application which evolved through the years. I am looking for a quick solution.

OK. The variable 'dest' represents a table name. The words 'LastName' and 'Language' point to the names of the fields in the corrosponding table 'dest'. The tables are i n a loop. Example: For I = 1 to 5 Select Case I Case 1 dest = "TranstableTbl"...

How can I make the field names variable in the query below. Here the fields are called Language and LastName. SQL = "SELECT * FROM [" & dest & "] WHERE [Language] Like 'X' ORDER BY [LastName];"

I had an application problem. At the extreme side my Origin and dest tables were the same. Now I have this Not enough memory 7 problem. But I'll have to start another thread. Many thanks.

Yes Association is the correct one, but that is only typo. In my code I corrected it. I'll try one of those techniques.

I am copying the statement exactly on one long line. This did not work either.

Dear Friend. Unfortunately it says syntax error in from phrase. Does not work.

strSQL = "INSERT INTO [" & dest & "] ([LastName], [FirstName], [Language]," & _ " [Email], [Associatiom]) " & "SELECT FROM [" & Origin & "] ([LastName], [FirstName]," & _ " [Language], [Email], [Federation])" This is a query that I have to use to copy Origin = TransNMTbl to...

Both work great thanks.

I have an application with many forms and modules. My tables are stored in the backend and I connect them via links. No problem until the point when I upgraded the two ends to access 2007. Now my TAble exist function does not work it gives the error message "3376 table not found" and I cannot...

Below is the error message that I am getting each time I press a command button on a form called ConFedFm. I looked at the statements in the calling form and the called form , parameters passed, spellings etc. All look alright. Help is highly appreciated "The expression On Click you entered...

Yes thanks. This solves the problem. Sorry for reporting back late.

Hello Experts. I have a sub given below. In this sub I am sorting and renumbering the rows of a matrix which is 5 columns wide and has KMAX rows in it. The column number is input by a form. Now I want to make the active form invisable and after renumbering make the data available to the calling...

Hi PBaldy. As you suggested I continued debugging with recordsets. The funny thing is now I managed to get new records into the table, but I cannot write down the last one. Same error 13. An ideas which may help resolve such issues? Thanks

Yes I have a breakpoint and many debugprints in all critical stages. It fails exactly on the rt.update statement. Message Run-time error 13 Type mismatch. By the way I tried the following test code it failed in the same way. SQL = "INSERT INTO [tblTelephone] ([tblTelephone].[SOYADI]) " & _...

The reason I am using these variables prefixed fn (Correction the first post was a typo) is that the data in one record of tblTelephone is extracted from 10 to 15 tblTele records. This is quite difficult logic necessitating calculations, scans for strings on field values of consecutive records...

I tried that also I am getting the same error. All my fields in target table are strings.

Hi Folks, I have two tables. tblTele has two columns and 300 rows. I use it as input. tbl.telephone has 5 columns, 0 rows. I must copy the 300 rows into the second table so that I have N rows. N<300. The copy process depends on specific values of input fields. Now when a row is complete I add it...

Oh I see the problem now. So whatever you type in you get an error message. If you change the locked property then you cannot enter any data using the combo. The enable property is similar. Thus result is either this behavior should be tolerated or a listbox should be used. Do I get it correct?

Precisely when the user comes to the form he should not see anything in the combo field. -If he hits enter then the application gives error message but stays on the same form. -If he tries to write something in the combo it is not allowed -If he hits the small arrow the list drops down, he...