Search results

Sorry for coming back after days but I had to rush to another project. May be I mislead you Orig is a variable which can take the name of a table. This construction does not work.

What is the best way to attack the problem. Here is sample code, which was working yesterday and after the addition of a column to the underlying table to day does not work. I = DCount("Language", "[" & Orig & "]", "[Language] <> 'X'") Here I is integer counter, Language is the name of field ...

Yes that is what I wanted. This table is not normalized. It is an old aplication.

Works like charm, thank you

DoCmd.RunSQL "UPDATE [" & dest & "] SET [Association] '=' [" & Associate & "];" This SQL statement causes trouble. I tried many variations but none worked. Here the dest is a variable containing the tablename, Association is the name of a column of dest and Associate is a variable containing...

It works like charme. Thanks I sorted out the other problem by debug,compile. By the way I is not an alias of J. It is a programming habit. where some times is is necessary to have intermediate variables to reach a clear result. Here I = J.

I am so sorry am using I as alias to J. In any case unfortunately it does not work.

I tried yours. It does not work. But I have modified your proposal as below. It does not complain and runs. The problem is it gives I=0 whereas I know that there are at least 400 records in the table. J = DCount("EMAIL", "[" & dest & "]", "[Language] = 'X'")

OK I will try that but at the moment I am having another problem where "The button you clicked has not produced any event" or"...event refers to an external object". Where as I did not touch any other part of the application.

Yes but if I omit the where clause then how can I impose the Language <> 'X' filter?

I have done exactly as you wrote, but does not work. It stops at that sentence and says type mismatch.

I tried it says type 13 mismatch. Here is the code: I = "SELECT Int(Count([Email])) as [ResultFm].[nnum] FROM [" & dest & "]" & _ " WHERE [Language] <> 'X' ORDER BY [LastName];" Here ResultFm is the continuous form to be displayed, nnum is the variable in the header, dest is a variable...

How can I convert the result of a SELECT COUNT statement to integer so that I can use in vba?

Works like charme . Thanks.

Hi, I want to access and modify a control of type label on a form under a certain condition. I tried various ways but still getting errror. Here is what I have done: If J > 0 Then Forms!Resultfm.Controls("Header") = "ERRORS" ResultFm it name of form. I am trying to adjust the label called Header...

Well lets say contradiction between what you can really do and what you say you can do. In any case I have below a working example : UPDSQL = "UPDATE [" & dest & "] SET Association = 'ANAR';" Here 'dest' is a variable holding the table name and 'Association' is a variablel holding the field...

Dear Galaxikom it goes a little bit out of discussion. but I must remind you that table names and field names which I implemented are object names. Isn't there a contradiction in your statement.

This is an update query Run by docmd. I used the tablename and fieldname as SQL parameters. Here the the data of various groups has to stay in separate tables. This is sin qua non. Additionally the number and names of the tables fields in them are different. The vba procedures to do this are...

I cannot get the query working with variable fields and operators I am not trying to discuss the design of the tables.