473,326 Members | 2,076 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Continous list

On my current site, I can click on a category and the view the content of that category. This is fine, but now I want to be able to view the contents of *ALL* the categories in one continous scroll seperated by category title. But I'm not quite sure how to go about it.

My current code:

Expand|Select|Wrap|Line Numbers
  1. <?xml version='1.0' encoding='utf-8' ?>
  2. <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">
  3. <xsl:output method="html" encoding="ISO-8859-1" omit-xml-declaration="yes"/>
  4.  
  5. <xsl:param name="pagename">default.asp?pagename=media</xsl:param>
  6. <xsl:param name="lang">en</xsl:param>
  7. <xsl:param name="type">print</xsl:param>
  8. <xsl:param name="vol">200304</xsl:param>
  9. <xsl:param name="cat">2</xsl:param>
  10. <xsl:param name="articleid">12345</xsl:param>
  11. <xsl:param name="mode">preview</xsl:param>
  12. <xsl:param name="target">email</xsl:param>
  13. <xsl:param name="selectedcat"></xsl:param>
  14.  
  15. <xsl:variable name="strBaseURL"><xsl:value-of select="concat('type=',$type,'&amp;lang=',$lang,'&amp;vol=',$vol,'&amp;cat=',$cat,'&amp;articleid=',$articleid)"></xsl:value-of></xsl:variable>
  16.  
  17. <xsl:variable name="default" select="document('../xml/default.xml')/main/site[@language=$lang]"/>
  18.  
  19. <xsl:variable name="website_IP"><xsl:value-of select="$default/website_IP"/></xsl:variable>
  20.  
  21. <xsl:variable name="twidth">
  22. <xsl:choose>
  23. <xsl:when test="$target='web'"><xsl:text>100%</xsl:text></xsl:when>
  24. <xsl:otherwise><xsl:text>750</xsl:text></xsl:otherwise>
  25. </xsl:choose> 
  26. </xsl:variable>
  27.  
  28. <xsl:variable name="image_dir">
  29. <xsl:choose>
  30. <xsl:when test="$target='web'"><xsl:value-of select="$default/web_article_images_url"/></xsl:when>
  31. <xsl:when test="$target='email' or $target='index'"><xsl:value-of select="$website_IP"/><xsl:value-of select="$default/web_article_images_url"/></xsl:when>
  32. <xsl:when test="$target='cd'"><xsl:value-of select="$default/cd_article_images_url"/></xsl:when>
  33. </xsl:choose>
  34. </xsl:variable>
  35.  
  36.  
  37.  
  38. <xsl:variable name="viewpagename"><xsl:text>default.asp?pagename=media</xsl:text></xsl:variable>
  39. <xsl:variable name="downloadpagename"><xsl:text>default.asp?pagename=media</xsl:text></xsl:variable>
  40.  
  41. <xsl:template match="vol_issue">
  42. <xsl:variable name="view_text">
  43. <xsl:choose>
  44. <xsl:when test="type = 'print' or type = 'web'">
  45. <xsl:choose>
  46. <xsl:when test="language='en'">View this article</xsl:when>
  47. <xsl:otherwise>Visualiser cet article</xsl:otherwise>
  48. </xsl:choose>
  49. </xsl:when>
  50. <xsl:when test="type = 'digital'">
  51. <xsl:choose>
  52. <xsl:when test="language='en'">Watch this video</xsl:when>
  53. <xsl:otherwise>Regarder ce vidéo</xsl:otherwise>
  54. </xsl:choose>
  55. </xsl:when>
  56. <xsl:when test="type = 'pr'">
  57. <xsl:choose>
  58. <xsl:when test="language='en'">View this release</xsl:when>
  59. <xsl:otherwise>Visualiser ce communiqué</xsl:otherwise>
  60. </xsl:choose>
  61. </xsl:when>
  62. <xsl:otherwise>
  63. <xsl:choose>
  64. <xsl:when test="language='en'">View this script</xsl:when>
  65. <xsl:otherwise>Visualiser ce script</xsl:otherwise>
  66. </xsl:choose>
  67. </xsl:otherwise>
  68. </xsl:choose>
  69. </xsl:variable>
  70.  
  71. <xsl:variable name="email_text">
  72. <xsl:choose>
  73. <xsl:when test="type ='print' or type='web'">
  74. <xsl:choose>
  75. <xsl:when test="language='en'">E-mail me this article</xsl:when>
  76. <xsl:otherwise>Veuillez me transmettre cet article par courriel</xsl:otherwise>
  77. </xsl:choose>
  78. </xsl:when>
  79. <xsl:when test="type ='pr'">
  80. <xsl:choose>
  81. <xsl:when test="language='en'">E-mail me this release</xsl:when>
  82. <xsl:otherwise>Envoyer ce communiqué par courriel</xsl:otherwise>
  83. </xsl:choose>
  84. </xsl:when>
  85. <xsl:when test="type ='digital'">
  86. </xsl:when>
  87. <xsl:otherwise>
  88. <xsl:choose>
  89. <xsl:when test="language='en'">E-mail me this script</xsl:when>
  90. <xsl:otherwise>Veuillez me transmettre ce script par courriel</xsl:otherwise>
  91. </xsl:choose>
  92. </xsl:otherwise>
  93. </xsl:choose>
  94. </xsl:variable>
  95.  
  96. <xsl:variable name="cat_description" select="document('../articles/categories.xml')/main/category[@category_id = $cat]/description"/>
  97. <xsl:variable name="category_lookup" select="document('../articles/categories.xml')"/>
  98.  
  99. <xsl:choose>
  100. <xsl:when test="$target = 'web'">
  101. <div class="ln-text">
  102. <xsl:for-each select="category">
  103. <xsl:sort select="sort_order" data-type="number" order="ascending" />
  104. <xsl:variable name="catid" select="@category_id"/>
  105. <xsl:variable name="classname">
  106. <xsl:choose>
  107. <xsl:when test="$catid = $selectedcat"><xsl:text>ln-slink</xsl:text></xsl:when>
  108. <xsl:otherwise><xsl:text>ln-alink</xsl:text></xsl:otherwise>
  109. </xsl:choose>
  110. </xsl:variable> 
  111. <xsl:text>*</xsl:text><a href="{$strBaseURL}&amp;vol={/vol_issue/@vol_issue_id}&amp;cat={$catid}" id="{$catid}" class="{$classname}"><xsl:value-of select="$category_lookup/main/category[@category_id = $catid]/description"/>:<xsl:value-of select="count(article)"/>
  112.  
  113. </a><br/>
  114. </xsl:for-each>
  115. </div>
  116. </xsl:when> 
  117. </xsl:choose>
  118.  
  119. <div class="m-bcategory"><h1><xsl:value-of select="$cat_description"/></h1></div>
  120.  
  121. <xsl:for-each select="category[@category_id = $cat]/article">
  122. <xsl:variable name="article" select="document(concat('../articles/', @article_id, '.xml'))"/>
  123. <div class="m-blurbwrapper">
  124. <div class="m-bheadline"><a class="m-bheadline" href="{$viewpagename}&amp;type={../../type}&amp;lang={../../language}&amp;vol={../../@vol_issue_id}&amp;cat={../@category_id}&amp;articleID={@article_id}&amp;mode=view&amp;id={$article/article/video/file/file_name}"><xsl:value-of select="$article/article/headline"/></a></div>
  125.  
  126. <div class="m-awordcount">
  127. <xsl:value-of select="$article/article/body_text/wordcount"/>
  128. </div>
  129. <xsl:if test="../../type='print' or ../../type='web'">
  130. <div class="m-thumbnail">
  131.  
  132. <img height="50" width="70">
  133. <xsl:attribute name="src">
  134. <xsl:value-of select="$image_dir"/>
  135. <xsl:value-of select="$article/article/images/image/source"/>
  136. <!--<xsl:if test="$article/article/images/image/source = '' ">noimage.jpg</xsl:if>-->
  137. <xsl:choose>
  138. <xsl:when test="$article/article/images/image/source = '' and $lang='en' ">noimage.jpg</xsl:when>
  139. <xsl:when test="$article/article/images/image/source = '' and $lang='fr' ">noimagefre.jpg</xsl:when>
  140. </xsl:choose>
  141. </xsl:attribute>
  142. </img>
  143.  
  144. </div>
  145. </xsl:if>
  146.  
  147.  
  148.  
  149.  
  150.  
  151. <div class="m-bblurb"><xsl:value-of select="$article/article/blurb"/></div>
  152.  
  153.  
  154.  
  155. <div class="m-blink">
  156. <a class="m-blink" href="{$viewpagename}&amp;type={../../type}&amp;lang={../../language}&amp;vol={../../@vol_issue_id}&amp;cat={../@category_id}&amp;articleID={@article_id}&amp;mode=view&amp;id={$article/article/video/file/file_name}">
  157. <xsl:value-of select="$view_text"/>
  158. </a>
  159. <xsl:if test="../../type='print' or ../../type='web' or ../../type='pr' or ../../type='digital'">
  160. ***<a class="m-blink" href="{$downloadpagename}&amp;type={../../type}&amp;lang={../../language}&amp;vol={../../@vol_issue_id}&amp;cat={../@category_id}&amp;articleID={@article_id}&amp;mode=email">
  161. <xsl:value-of select="$email_text"/> <!-- <input type="checkbox" value="{@category_id}" name="category_id"><xsl:value-of select="description"/></input> -->
  162. </a> 
  163. </xsl:if>
  164. </div>
  165. </div>
  166. </xsl:for-each>
  167. </xsl:template>
  168. </xsl:stylesheet>
Thanks for the help,
Mar 20 '08 #1
5 1616
Sorry for the double post, but the lack of response has me wondering if my question was clear or needs more information for help to be provided?
Mar 26 '08 #2
jkmyoung
2,057 Expert 2GB
Source xml needed,
to more easily pinpoint the issue you're talking about.
Mar 26 '08 #3
Sorry i'm a little braindead.

Here is source file.

Like i stated in the Above, I want to list the contents of every category on the same page seperated by Category heading.

Expand|Select|Wrap|Line Numbers
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <vol_issue>
  3.  
  4.  <category category_id="2">
  5.   <article article_id="47106"/>
  6.   <article article_id="47032"/>
  7.   <article article_id="47015"/>
  8.   <article article_id="46852"/>
  9.   <article article_id="46828"/>
  10.   <article article_id="46827"/>
  11.   <article article_id="46826"/>
  12.   <article article_id="46825"/>
  13.   <article article_id="46434"/>
  14.  </category>
  15.  
  16.  <category category_id="72">
  17.   <article article_id="47179"/>
  18.   <article article_id="47178"/>
  19.   <article article_id="47177"/>
  20.   <article article_id="47176"/>
  21.   <article article_id="47175"/>
  22.   <article article_id="47033"/>
  23.   <article article_id="47032"/>
  24.   <article article_id="47031"/>
  25.   <article article_id="46945"/>
  26.   <article article_id="46944"/>
  27.   <article article_id="46943"/>
  28.   <article article_id="46929"/>
  29.   <article article_id="46928"/>
  30.   <article article_id="46927"/>
  31.   <article article_id="46781"/>
  32.   <article article_id="46780"/>
  33.   <article article_id="46779"/>
  34.   <article article_id="46767"/>
  35.   <article article_id="46766"/>
  36.   <article article_id="46765"/>
  37.   <article article_id="46764"/>
  38.   <article article_id="46763"/>
  39.   <article article_id="46621"/>
  40.   <article article_id="46617"/>
  41.   <article article_id="46601"/>
  42.   <article article_id="46592"/>
  43.   <article article_id="46591"/>
  44.   <article article_id="46590"/>
  45.   <article article_id="46589"/>
  46.   <article article_id="46588"/>
  47.   <article article_id="46587"/>
  48.   <article article_id="46586"/>
  49.   <article article_id="46585"/>
  50.   <article article_id="46457"/>
  51.   <article article_id="46456"/>
  52.   <article article_id="46455"/>
  53.   <article article_id="46433"/>
  54.   <article article_id="46419"/>
  55.   <article article_id="46418"/>
  56.   <article article_id="46417"/>
  57.   <article article_id="46416"/>
  58.  </category>
  59. </vol_issue>
Thanks, gt
Mar 26 '08 #4
jkmyoung
2,057 Expert 2GB
Still a little bit hard to tell without the referenced documents, but should be something like
After the <xsl:for-each select="category"> and sort, add the header like so:

Expand|Select|Wrap|Line Numbers
  1. <br/>
  2. <h1><xsl:value-of select="$category_lookup/main/category[@category_id = $catid]/description"/></h1>
  3. <br/>
  4.  
It's really hard to tell without the other files, or output.
Mar 26 '08 #5
Thanks jkmyoung,

I noticed the orginal code i posted had some nonsense that did not belong in there so lets try this again.

The XSL file.

Expand|Select|Wrap|Line Numbers
  1. <?xml version='1.0' encoding='utf-8' ?>
  2. <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"  version="1.0">
  3. <xsl:output method="html" encoding="ISO-8859-1" omit-xml-declaration="yes"/>
  4.  
  5.     <xsl:param name="pagename">default.asp?pagename=media</xsl:param>
  6.     <xsl:param name="lang">en</xsl:param>
  7.     <xsl:param name="type">print</xsl:param>
  8.     <xsl:param name="vol">200304</xsl:param>
  9.     <xsl:param name="cat">2</xsl:param>
  10.     <xsl:param name="articleid">12345</xsl:param>
  11.     <xsl:param name="mode">preview</xsl:param>
  12.     <xsl:param name="target">email</xsl:param>
  13.     <xsl:param name="selectedcat"></xsl:param>
  14.  
  15.     <xsl:variable name="strBaseURL"><xsl:value-of select="concat('type=',$type,'&amp;lang=',$lang,'&amp;vol=',$vol,'&amp;cat=',$cat,'&amp;articleid=',$articleid)"></xsl:value-of></xsl:variable>
  16.  
  17.     <xsl:variable name="default" select="document('../xml/default.xml')/main/site[@language=$lang]"/>
  18.  
  19.     <xsl:variable name="website_IP"><xsl:value-of select="$default/website_IP"/></xsl:variable>
  20.  
  21.     <xsl:variable name="twidth">
  22.         <xsl:choose>
  23.             <xsl:when test="$target='web'"><xsl:text>100%</xsl:text></xsl:when>
  24.         <xsl:otherwise><xsl:text>750</xsl:text></xsl:otherwise>
  25.         </xsl:choose> 
  26.     </xsl:variable>
  27.  
  28.     <xsl:variable name="image_dir">
  29.         <xsl:choose>
  30.             <xsl:when test="$target='web'"><xsl:value-of select="$default/web_article_images_url"/></xsl:when>
  31.             <xsl:when test="$target='email' or $target='index'"><xsl:value-of select="$website_IP"/><xsl:value-of select="$default/web_article_images_url"/></xsl:when>
  32.             <xsl:when test="$target='cd'"><xsl:value-of select="$default/cd_article_images_url"/></xsl:when>
  33.         </xsl:choose>
  34.             </xsl:variable>
  35.  
  36.  
  37.  
  38. <xsl:variable name="viewpagename"><xsl:text>default.asp?pagename=media</xsl:text></xsl:variable>
  39. <xsl:variable name="downloadpagename"><xsl:text>default.asp?pagename=media</xsl:text></xsl:variable>
  40.  
  41. <xsl:template match="vol_issue">
  42.     <xsl:variable name="view_text">
  43.         <xsl:choose>
  44.             <xsl:when test="type = 'print' or type = 'web'">
  45.                 <xsl:choose>
  46.                     <xsl:when test="language='en'">View this article</xsl:when>
  47.                     <xsl:otherwise>Visualiser cet article</xsl:otherwise>
  48.                 </xsl:choose>
  49.             </xsl:when>
  50.             <xsl:when test="type = 'digital'">
  51.                 <xsl:choose>
  52.                     <xsl:when test="language='en'">Watch this video</xsl:when>
  53.                     <xsl:otherwise>Regarder ce vidéo</xsl:otherwise>
  54.                 </xsl:choose>
  55.             </xsl:when>
  56.             <xsl:when test="type = 'pr'">
  57.                 <xsl:choose>
  58.                     <xsl:when test="language='en'">View this release</xsl:when>
  59.                     <xsl:otherwise>Visualiser ce communiqué</xsl:otherwise>
  60.                 </xsl:choose>
  61.             </xsl:when>
  62.             <xsl:otherwise>
  63.                 <xsl:choose>
  64.                     <xsl:when test="language='en'">View this script</xsl:when>
  65.                     <xsl:otherwise>Visualiser ce script</xsl:otherwise>
  66.                 </xsl:choose>
  67.             </xsl:otherwise>
  68.         </xsl:choose>
  69.     </xsl:variable>
  70.  
  71.     <xsl:variable name="email_text">
  72.         <xsl:choose>
  73.             <xsl:when test="type ='print' or type='web'">
  74.                 <xsl:choose>
  75.                     <xsl:when test="language='en'">E-mail me this article</xsl:when>
  76.                     <xsl:otherwise>Veuillez me transmettre cet article par courriel</xsl:otherwise>
  77.                 </xsl:choose>
  78.             </xsl:when>
  79.             <xsl:when test="type ='pr'">
  80.                 <xsl:choose>
  81.                     <xsl:when test="language='en'">E-mail me this release</xsl:when>
  82.                     <xsl:otherwise>Envoyer ce communiqué par courriel</xsl:otherwise>
  83.                 </xsl:choose>
  84.             </xsl:when>
  85.             <xsl:when test="type ='digital'">
  86.             </xsl:when>
  87.             <xsl:otherwise>
  88.                 <xsl:choose>
  89.                     <xsl:when test="language='en'">E-mail me this script</xsl:when>
  90.                     <xsl:otherwise>Veuillez me transmettre ce script par courriel</xsl:otherwise>
  91.                 </xsl:choose>
  92.             </xsl:otherwise>
  93.             </xsl:choose>
  94.             </xsl:variable>
  95.  
  96.     <xsl:variable name="cat_description" select="document('../articles/categories.xml')/main/category[@category_id = $cat]/description"/>
  97.  
  98.     <div class="m-bcategory"><h1><xsl:value-of select="$cat_description"/></h1></div>
  99.  
  100.     <xsl:for-each select="category[@category_id = $cat]/article">
  101.       <xsl:variable name="article" select="document(concat('../articles/', @article_id, '.xml'))"/>
  102.         <div class="m-blurbwrapper">
  103.         <div class="m-bheadline"><a class="m-bheadline" href="{$viewpagename}&amp;type={../../type}&amp;lang={../../language}&amp;vol={../../@vol_issue_id}&amp;cat={../@category_id}&amp;articleID={@article_id}&amp;mode=view&amp;id={$article/article/video/file/file_name}"><xsl:value-of select="$article/article/headline"/></a></div>
  104.  
  105.         <div class="m-awordcount">
  106.           <xsl:value-of select="$article/article/body_text/wordcount"/>
  107.         </div>
  108.         <xsl:if test="../../type='print' or ../../type='web'">
  109.           <div class="m-thumbnail">
  110.  
  111.             <img height="50" width="70">
  112.               <xsl:attribute name="src">
  113.                 <xsl:value-of select="$image_dir"/>
  114.                 <xsl:value-of select="$article/article/images/image/source"/>
  115.                 <!--<xsl:if test="$article/article/images/image/source = '' ">noimage.jpg</xsl:if>-->
  116.                 <xsl:choose>
  117.                   <xsl:when test="$article/article/images/image/source = '' and $lang='en' ">noimage.jpg</xsl:when>
  118.                   <xsl:when test="$article/article/images/image/source = '' and $lang='fr' ">noimagefre.jpg</xsl:when>
  119.                 </xsl:choose>
  120.               </xsl:attribute>
  121.             </img>
  122.  
  123.           </div>
  124.         </xsl:if>
  125.  
  126.  
  127.  
  128.  
  129.  
  130.         <div class="m-bblurb"><xsl:value-of select="$article/article/blurb"/></div>
  131.  
  132.  
  133.  
  134.         <div class="m-blink">
  135.           <a class="m-blink" href="{$viewpagename}&amp;type={../../type}&amp;lang={../../language}&amp;vol={../../@vol_issue_id}&amp;cat={../@category_id}&amp;articleID={@article_id}&amp;mode=view&amp;id={$article/article/video/file/file_name}">
  136.             <xsl:value-of select="$view_text"/>
  137.           </a>
  138.           <xsl:if test="../../type='print' or ../../type='web' or ../../type='pr' or ../../type='digital'">
  139.             ***<a  class="m-blink" href="{$downloadpagename}&amp;type={../../type}&amp;lang={../../language}&amp;vol={../../@vol_issue_id}&amp;cat={../@category_id}&amp;articleID={@article_id}&amp;mode=email">
  140.               <xsl:value-of select="$email_text"/> <!-- <input type="checkbox" value="{@category_id}" name="category_id"><xsl:value-of select="description"/></input> -->
  141.             </a> 
  142.           </xsl:if>
  143.         </div>
  144.      </div>
  145.     </xsl:for-each>
  146. </xsl:template>
  147. </xsl:stylesheet>
Categories.xml file many more categories than this but you get the idea.

Expand|Select|Wrap|Line Numbers
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <main>
  3.  <category category_id="54">
  4.   <description>New Releases</description>
  5.   <cd_folder>NewReleases</cd_folder>
  6.   <incl_in_reg>true</incl_in_reg>
  7.   <sort_order>1</sort_order>
  8.   <language>en</language>
  9.   <image_filename>filename.jpg</image_filename>
  10.  </category>

Master XML which hold refernce to individual files.

Expand|Select|Wrap|Line Numbers
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <vol_issue>
  3. <category category_id="2">
  4.   <article article_id="47106"/>
  5.   <article article_id="47032"/>
  6.   <article article_id="47015"/>
  7.   <article article_id="46852"/>
  8.   <article article_id="46828"/>
  9.   <article article_id="46827"/>
  10.   <article article_id="46826"/>
  11.   <article article_id="46825"/>
  12.   <article article_id="46434"/>
  13.  </category>
  14. </vol_issue>
Individual XML file

Expand|Select|Wrap|Line Numbers
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <!DOCTYPE article SYSTEM "article.dtd" [
  3. ]>
  4. <article>
  5. <headline></headline>
  6. <subheadline></subheadline>
  7. <blurb></blurb>
  8. <byline></byline>
  9. <copyright></copyright>
  10. <body_text><parag></parag><wordcount></wordcount>
  11. </body_text>
  12. <images>
  13. <image>
  14. <source></source>
  15. <res_type></res_type>
  16. </image>
  17. <image>
  18. <source></source>
  19. <res_type></res_type>
  20. </image>
  21. </images>
  22. <audio>
  23. <file>
  24. <file_name></file_name>
  25. <file_type></file_type>
  26. </file>
  27. </audio>
  28. <video></video>
  29. </article>
Thank your for patience and help,

Gt
Mar 26 '08 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: JK | last post by:
Hi All, I am working a form which is tabular layout (continuous form) which will display multiple records at a time. Each line of record needs to be reflected on the color code to show their...
1
by: adolph | last post by:
I would like to add a check box to the detail area of a continous form. So that I can check on specific records, then after I've marked all the records I watn to delte, click a button to loop thru...
9
by: Paradigm | last post by:
I am using an Access2K front end to a MYSQL database. If I enter a new record in a continuous form the record appears as #deleted as soon as I move to a different record in the form until I requery...
2
by: Rene_Muench | last post by:
Hi there, I have listed 12 month on a continous form, where as I flag the current month with a tick box. To ensure at only 1 tick box is check not more or all I would want to validate and...
0
by: gavo | last post by:
Hi. using A2K; i have a form containing a continous subform. The question is, how can i call a calculation for one of the fields in the continous subform from the main form. At the moment i...
0
by: ReidarT | last post by:
I have started to develop in vb.net. Earlier development was in MS-Access. I need a lot of continous forms to present data. The customer add and edits data in the continous form. Is use of...
1
by: Daniel Rucareanu | last post by:
Hello, Does anybody knows how can you delete, in just one step, not using a loop, a subset of the child nodes of a given DOM parent node? The subset will be continous, so for example, if the...
2
by: questionit | last post by:
Hi I know how to implement Continous form. In the method i have tried, the source for data on the continous form comes from table using SQL query Now, i want to try something different and i...
5
by: AccessHunter | last post by:
Hi, I have a continous form that displays Name and Address of Suppliers. In the form there is a combo box for 'Active Address' and 10 other text boxes. All the fields coem from one table,...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.