Search results

Thaaaaaaaaaaaaaaaaaaaaaaanks

Good day! I need a vba code to get the number of columns or cells in current (selected) row in MS word. NB: the number of cells are not the same in each table row. Thanks in advance

IT works more than great!! Thaaaaaaaaaaaaaaaaaaaaaaaaaank

I already attached a simple sample of the tables. thanks for your kind interest

Hi, it doesn't work Attached a simple DB for illustration.

Good day! Is it possible to make a query based on a table (employee_details) and under the criteria of the field (city) put the following criteria: like * reference_table * Reference_table always has one record only. Can the query fetch the data from another table? Thanks in advance

Thanks again. I'll adopt a better path.

I appreciate your advises and your time you have spared. Indeed, the information provided is indicative only. I have many users filling in two fields only. That filed became too lengthy. That's why I need to transpose them into other multiple fields. Thanks again

Dear arnelgp, I appreciate your excellent endeavors, Pls, Pls, Pls, What if I need to transpose the records of two fields on 8 fields as in the attached image Thanks for your excellent cooperation.

Thanks alot, arnelgp solution is wonderful

Thanks a mile

Here's a sample of desired output with thanks

Good day! I have a field "Description" and other four fields "field1", "field2", "field3" and "field4" The field "Description" has numerous data. Now, I want a code to go to first entry in "Description" and insert it into "field1" then goes to the send entry in "Description" and insert it into...

Dear Great arnelgp, It's working perfect. How about editing the database. How to edit the current record in the MDB file. Thaaaaaaaaaaaaaaaanks in advance

Thanks a mile my dear. I'll work on.

thanks for your fruitful reply; How about the index and search Previously I was using the code: rst.index = "index name" rst.seek "=", "anything" if not rst.nomatch then How such code will be. Sorry for any inconvenience

Kindly note that I'm using Word 2016 not 2013. I've already tried this solution, but still the same issue. Thanks

Good day! I'm writing the following code in Word 2013 VB to connect to MDB database dim db as database dim rst as recordset set db="db path" set rst= db.openrecordset("Table Name") In this stage I'm getting the error message :run-time error '4029' activex component can't create object" I...

Thanks for your kind support

Thanks. I'll try it and update your goodselves.