MSACCESS Visual Basic program help needed in recordset

[jadigeeta]

Hi Experts,
Good day....
kindly need your help to support in below program to use KMLHeader color: ff0000ff for 1st 5 columns, and the rest columns KMLHeader color: ffffff00 for the available recordset.

Program given in the attachment due to larger file size.

in this program, one header using for entire recordset columns, i want to use 2 headers,
for 1st 5 columns: 1 header(that contains color: ff0000ff)
remaining columns: 2nd header (that contains color: ffffff00)

Kindly help experts....

Many thanks in advance.....

 

[isladogs]

Welcome to AWF.
For info, I've moved your post to the VBA forum as it's a technical question about code.

Please feel free to tell us a little about yourself in the introduce yourself forum

 

[June7]

Posting code in a word doc is not helpful. Preferable to post directly in thread post between CODE tags. Regardless, I still need more explanation of what you are trying to accomplish. I do not understand what color code has to do with a recordset object.

Looks like you are constructing a KML file.

 

[jadigeeta]

Hi,
Its a KML generator program based on given input:
Source_Cell = InputBox("Enter the Source Cell for 3G Neighbours:")

So, As a KML, the most required: 1. Header 2. Body 3. Footer
where Body=recordset(Source cell and Neighbor Cell) Table;
One source cell contains unfixed neighbors, based on near by sites, some sites having more neighbors, some sites may have nothing,
Based on Neighbor list table (Recordset) we are preparing the KML file,

my request is:
there is color option in kmlheader(i highlighted word attachment).
presently using only one header(means single color)
I want to use 2 headers, so that it will help to use 1st five columns one color and the for remaining columns another color,
Kindly help me experts...

After 10posts only i can send codes with links...., so i unable send code here, kindly consider the attachment code...

 

[June7]

Should be able to post code between CODE Tags. I am, however, considering the code.

Need to use Option Explicit in module header. You use variables that have not been declared. What is the KML variable supposed to be declared as - Variant?

Sample dataset would be helpful. If you can attach Word doc, you can attach a Zip file with Access db.

 

[June7]

My search shows the tag is:

<textcolor>ffffff00</textcolor>

 

[jadigeeta]

I Unable to send .mdb file because after zip, it is 8Mb file, the limit is 2Mb, Can you please send your mail id, i'll send via gmail.
sorry for inconvenience.

 

[jadigeeta]

My search shows the tag is:

<textcolor>ffffff00</textcolor>

Yes, This code i want to use for 1st 5 columns in one color and the remaining columns for another color, sample output attached.
Thanks

 

[jadigeeta]

Yes, This code i want to use for 1st 5 columns in one color and the remaining columns for another color, sample output attached.
Thanks

sorry, its a text color, i need line color need to change:

"<color>ffffff00</color>" & vbLf & _

Thanks

 

[June7]

Not providing my email. Reduce size of file. Make copy of file, delete data, run Compact & Repair.

Additional research indicates you have correct syntax.

 

[jadigeeta]

Not providing my email. Reduce size of file. Make copy of file, delete data, run Compact & Repair.

Additional research indicates you have correct syntax.

1. links declared file attaching

 

[jadigeeta]

1. links declared file attaching

2. Remaining supported files attached

Usage:
1. Please unzip and copy in to C folder --> Data --> GE
2. Open Google_Earth_Neighbours_V3_2014.mdb and click on Find 3G Neighbours --> enter 3G Cell name is: YAL4002_21

it redirects the google earth and shows line for defined neighbors, based on Links declared.mdb

my request is: from the links declared table: 1st 5 columns color in red color, and remaining in any other color.

Kindly help experts...
Thanks in advance...

 

[jadigeeta]

2. Remaining supported files attached

Usage:
1. Please unzip and copy in to C folder --> Data --> GE
2. Open Google_Earth_Neighbours_V3_2014.mdb and click on Find 3G Neighbours --> enter 3G Cell name is: YAL4002_21

it redirects the google earth and shows line for defined neighbors, based on Links declared.mdb

my request is: from the links declared table: 1st 5 columns color in red color, and remaining in any other color.

Kindly help experts...
Thanks in advance...

Please copy the attachments in C Folder --> Data folder (need to create) --> GE folder (Need to create) --> paste and unzip

it looks like in attached snap,
Thanks

 

[June7]

Apparently I would have to download some app to unzip those 7z files and don't really want to. Suggest you use Windows compression which I definitely can extract.

 

[jadigeeta]

Apparently I would have to download some app to unzip those 7z files and don't really want to. Suggest you use Windows compression which I definitely can extract.

Can you please try below link,
sendspace.com/file/sod18d

im unable to copy directly link here because, it is showing message, after 10 posts only can eligible to add website links, so i cut the https and www
thanks for understanding

 

[June7]

I cannot open rar compressed files. Only Windows compressed zip files. Do you not have Windows compression available?

Many here will download files only from forum.

I have your code and the KML files. Just really need a little sample data. Maybe post an Excel.

I have noticed that the code building kml_Body will cause the two placemark values to run together. Is that intentional?

Should the color code be #ffff00 ?

 

[jadigeeta]

I cannot open rar compressed files. Only Windows compressed zip files. Do you not have Windows compression available?

Many here will download files only from forum.

I have your code and the KML files. Just really need a little sample data. Maybe post an Excel.

I have noticed that the code building kml_Body will cause the two placemark values to run together. Is that intentional?

Should the color code be #ffff00 ?

I Used winzip and attached, kindly help me...
line color: ffffff00: cyon color
if you run the macro, easily can understand....

Thanks in advance....

 

[June7]

1. Cannot extract file from Links Declared.zipx

2. Every code module should have the following two lines in header:
Option Compare Database
Option Explicit

3. Recommend not using Switchboard wizard. Just use a normal form with buttons and VBA.

 

[jadigeeta]

1. Cannot extract file from Links Declared.zipx

2. Every code module should have the following two lines in header:
Option Compare Database
Option Explicit

3. Recommend not using Switchboard wizard. Just use a normal form with buttons and VBA.

Kindly check the updated attachment, i cleared the all the cache memory, now file size is smaller, please check now...

1. Copy all the attachments in C folder --> Data folder(need to create) --> GE folder(need to create)
2. Open the Google_Earth_Neighbours_V3_2014.mdb and enter 3G Cell Name: YAL4019_21 or 4002_21 or 4002_22 or 4003_23 the source cell details can view in links declared sheet
it redirects to GE and shows links
Switch board can useful for all the queries can use in one place.

 

[June7]

I have run the code and it certainly seems to work but I don't understand how it can. Query references a linked table SITES_INFO_GOOGLE.mdb which has a link path C:\Data\GE. I do not have such folder nor mdb file. I try to open the query object and it triggers 'invalid path error', yet the code opening recordset based on the same query works. Can you explain this?