Recent content by exaccess

OK. I think I have not really been able to explain the whole problem. Nevertheless I shall try all your useful suggestions and come back.

This is the result of an automated SQL production. It produces this code based on variables given by the user. The result is used by the system.

I am very sorry. Just trying to do to two things at the same time. The second code should be: DoCmd.OpenReport [ReportName], acViewPreview, MembersTbl.NOM Like 'b*' This is the code that does not work.

Hi Experts, My code does not work. It does not give any error message but simply ignores the WHERE parameter. MembersTbl is an access table. Nom is a field of the table. ReportName is he name of a produced report. F01 is a string variable. V01 is also a sting variable. The WHERE clause is...

Gasman it works like charm. Thank you.

What is wrong with this statement. "SELECT * FROM [TransTbl] WHERE [TransTbl].[Assoc] = & 'InAssoc' & " & _ "ORDER BY [TransTbl].[LastName]" TransTbl is the table on which the query will run. Assoc and LastName are fields of the table. InAssoc is defined text variable which can change...

Yes I have already tried that, now done it again and it works. Probably a typo. Thank you.

I will try this and come back.

Because at the beginning the system does not know anything. It is first up to the user to give the name of a file, which may change each time the program is executed. The application uses the name of that file to select the combobox entry. I hope this is clear enough.

Hi Experts, Here is the problem: Association is the name of a combobox on current form. When the user comes to the form this field may or may not be populated, IF it is not populated and he tries to do something else then he is warned. Thus to go further it must be populated. The data will...

Hi Experts. Due to internal reasons this project has been abandoned. Thanks a lot for those who tried to help with all their good will.

HI Experts, I have two quite simple questions: what is the statement for finding the number of rows with at least one field filled. Similar question for columns, but this time first I want to know to know the column label together with its number as integer. Secondly using these two numbers I...

Sub Main11() Dim ForName As String Dim strPath As String Browser ForName, strPath End Sub Sub Browser(ForName, strPath As String) On Error GoTo Err_Function Dim NSlash As String, InCommaCSV As String, InSEmiColonCSV As String Dim TNO As Integer, TACT As Integer, TFile As...

I think my message somewhat misleading. It is still NOT working.

Here is the latest version of the code where I respected all your recommendations. '---------------------------------------------------------------------------------- Public Function GetCSVFile(strPath As String) As String...