Search results

Rejected use of text as an expression.

Hello Experts, I have to count the number of occurrences of Line feed (vbLf) in a long string. The code I am using is: MAX = TLine.Split(vbLf).Length - 1 It does not work. Help please.

Re: Initial folder of open file dialog -SOLVED OK folks here is the solution. When I installed the Operating System I had changed the pointer of the My Documents folder to MyWork. However the system kept the My Documents folder and assigned an alias to MyWork as MyDocuments without space. Now...

G_title is a global variable. It is defined and has a string value. ContactFiles is the folder where the data resides. Contacts is a typo. I saw it and edited the post. It also works when I write "D:\MyWork" but defaults to My Documents folder when I write it as it is in my previous post. The...

Neither InitialDirectory no InitialFileName work. The second one is already in the code.

It is D:\MyWork\ACEXWO\ACCESS\TelephoneDB\ContactFiles\ Contacts is a directory. Deleting the last slash does not change anything.

Hello Experts, I am trying to display an open file dialog window so that the user can pick up a file. I wish the window to show a specific folder. How can I do this? The code I am using is below. The parameter InitialFileName has no effect on the outcome. Any help is welcome. Function...

Hello Experts, I have an application where I have to read a big VCF file in VBA, extract the information and place it into records of a table. I looked here and here but could not find any proper help. Of course I can read as a text file, but the structure is quite cumbersome to implement with...

Thanks. After submitting the responses I found out about the string connnect=;database and also discovered that two imported text files looked like as if they were connected tables. So the problem is solved.

I have placed almost all the code there. There are only a few statements left which are irrelevant. But if I copy the whole module there are lots of comments between the lines which are both somewhat company related and not necessarily for public eyes. I would appreciate if at least somebody...

Starting by the last question: If I do not use that table instead the tableDefs how can I get the name of the last used backend database? J1 and J2 are used to give feedback to the user about the number of tables linked or links refreshed. I am trying to avoid all tables. When you say drop...

Hi Experts, I have a club member registration application consisting of a program database and a data database. They reside in the same directory. There is an autoexec macro which runs at the beginning. This macro has to find the DATAdb and make sure that the required tables are linked (Not all...

OK. I have solved the problem. I have created a replicate of Table1 say TableFin. Then I copied Table1 into it with INSERT INTO. I formed Query1 as a temporary table say TEMPO. Finally I appended TEMPO to TableFin by copying the first four fields of TEMPO to the first four of TableFin. The rest...

OK. Sorry if I am not clear enough. Table 1 Fields: F1, F2, F3 , F4, F5, F6, F7, F8, F9, F10 Query 1 Fields: G1, G2, G3, G4 F1 corresponds to G1 , F2 corresponds to G2 , F3 corresponds to G3 , F4 corresponds to G4. The data in these corresponding fields can be compared. Only their names are...

OK Perfect. But what if I need those fields. That is the result is lets say will be a table where the first 1200 records have all 30 fields populated and the rest 500 records have 4 fields populated and have nulls in the remaining 26 fields. Which way should I follow in that case.

Hello Experts, I have a table and a query. The first 4 fields of the table correspond to that of the query. The query does not have any other fields, but the table has 26 more fields. Is it possible to use SQL OUTER JOIN or UNION or whatever to append the data of the query to the table or do I...

Thanks the problem is solved.

You are right I have seen this later after posting. The problem is solved. Thanks.

Hello Experts, I am trying to delete records from table1 that are also in table2. Table 1 = TransSHTbl, table2 = TransUPDSHTbl. The query I use is DELSQL = "DELETE FROM TransSHTbl " & _ " INNER JOIN TransUPDSHTbl ON " & _ "((TransSHTbl.FirstName = TransUPDSHTbl.FirstName) AND "...

Hello Experts, SQL does not copy the field (autonumber) of table1 to another field (number longue) of table2. Is this normal and is there a way around it? Here is the code: "INSERT INTO TransUPDSHTbl SELECT TranSHTbl.MemID, TransSHTbl.FirstName, " & _ " TransSHTbl.LastName, " & _...