From: KB on 17 Mar 2010 10:29 I am building a database catalogue of all our reports and want to include the SQL and VBA used in the reports. I have added a memo field to hold this data but the database becomes unstable when I add the VBA (I copy it from MS Excel and paste it in the memo field). I suspect that Access is trying to run the VBA. Could someone suggest how I can embed this data in the database. I know that I could hyperlink to files external to the database but don't want to do this unless there are no other issues. Thanks
From: Jeff Boyce on 17 Mar 2010 11:22 It sounds like you are trying to document the application. Do you require electronic documentation, or could you use Access' built in documenter and print off the documentation? For that matter, instead of documenting it yourself, what about just using Access' built in documenter? Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "KB" <KB(a)discussions.microsoft.com> wrote in message news:3DEC5924-ABF4-4737-B005-61340095370A(a)microsoft.com... >I am building a database catalogue of all our reports and want to include >the > SQL and VBA used in the reports. I have added a memo field to hold this > data > but the database becomes unstable when I add the VBA (I copy it from MS > Excel > and paste it in the memo field). I suspect that Access is trying to run > the > VBA. > > Could someone suggest how I can embed this data in the database. I know > that > I could hyperlink to files external to the database but don't want to do > this > unless there are no other issues. > > Thanks >
From: KB on 17 Mar 2010 12:59 Hi Jeff Thank you for your response. To give you a bit more background, we have a number of reports within the department that we want to document in a way that can be searched by anyone in the department (so that they can find which reports might be relevant to them and to reduce duplication). We are building a MS Access catalogue that will be the main data store with a sharepoint user interface. Although most people won't need to see the VBA and SQL stored in the database we want to have all the documentation/backup of the code for the various reports in one place i.e. within the database. A number of the reports that we want to document are built in MS Excel and are automated through VBA. I thought MS Access would be a good way to go and that VBA in a memo field would be seen as text but it seems to be corrupting the databse. I have used Access's documenter in the past but do not have a similar documenter for Excel (although I am aware there are products we could buy). I am loathed to have a central folder with backups of the code and hyperlinks due to the fragility of them but would welcome any ideas..... K "Jeff Boyce" wrote: > It sounds like you are trying to document the application. > > Do you require electronic documentation, or could you use Access' built in > documenter and print off the documentation? > > For that matter, instead of documenting it yourself, what about just using > Access' built in documenter? > > Regards > > Jeff Boyce > Microsoft Access MVP > > -- > Disclaimer: This author may have received products and services mentioned > in this post. Mention and/or description of a product or service herein > does not constitute endorsement thereof. > > Any code or pseudocode included in this post is offered "as is", with no > guarantee as to suitability. > > You can thank the FTC of the USA for making this disclaimer > possible/necessary. > > "KB" <KB(a)discussions.microsoft.com> wrote in message > news:3DEC5924-ABF4-4737-B005-61340095370A(a)microsoft.com... > >I am building a database catalogue of all our reports and want to include > >the > > SQL and VBA used in the reports. I have added a memo field to hold this > > data > > but the database becomes unstable when I add the VBA (I copy it from MS > > Excel > > and paste it in the memo field). I suspect that Access is trying to run > > the > > VBA. > > > > Could someone suggest how I can embed this data in the database. I know > > that > > I could hyperlink to files external to the database but don't want to do > > this > > unless there are no other issues. > > > > Thanks > > > > > . >
From: Jeff Boyce on 18 Mar 2010 12:00 I've not run across this issue before, so I'll step back. Hopefully one of the other newsgroup readers has some insight on this... -- Regards Jeff Boyce Microsoft Access MVP Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "KB" <KB(a)discussions.microsoft.com> wrote in message news:46D4D9DE-364E-42CD-AEB0-098EB999803B(a)microsoft.com... > Hi Jeff > > Thank you for your response. To give you a bit more background, we have a > number of reports within the department that we want to document in a way > that can be searched by anyone in the department (so that they can find > which > reports might be relevant to them and to reduce duplication). We are > building > a MS Access catalogue that will be the main data store with a sharepoint > user > interface. Although most people won't need to see the VBA and SQL stored > in > the database we want to have all the documentation/backup of the code for > the > various reports in one place i.e. within the database. A number of the > reports that we want to document are built in MS Excel and are automated > through VBA. > > I thought MS Access would be a good way to go and that VBA in a memo field > would be seen as text but it seems to be corrupting the databse. I have > used > Access's documenter in the past but do not have a similar documenter for > Excel (although I am aware there are products we could buy). I am loathed > to > have a central folder with backups of the code and hyperlinks due to the > fragility of them but would welcome any ideas..... > > K > > "Jeff Boyce" wrote: > >> It sounds like you are trying to document the application. >> >> Do you require electronic documentation, or could you use Access' built >> in >> documenter and print off the documentation? >> >> For that matter, instead of documenting it yourself, what about just >> using >> Access' built in documenter? >> >> Regards >> >> Jeff Boyce >> Microsoft Access MVP >> >> -- >> Disclaimer: This author may have received products and services mentioned >> in this post. Mention and/or description of a product or service herein >> does not constitute endorsement thereof. >> >> Any code or pseudocode included in this post is offered "as is", with no >> guarantee as to suitability. >> >> You can thank the FTC of the USA for making this disclaimer >> possible/necessary. >> >> "KB" <KB(a)discussions.microsoft.com> wrote in message >> news:3DEC5924-ABF4-4737-B005-61340095370A(a)microsoft.com... >> >I am building a database catalogue of all our reports and want to >> >include >> >the >> > SQL and VBA used in the reports. I have added a memo field to hold this >> > data >> > but the database becomes unstable when I add the VBA (I copy it from MS >> > Excel >> > and paste it in the memo field). I suspect that Access is trying to run >> > the >> > VBA. >> > >> > Could someone suggest how I can embed this data in the database. I know >> > that >> > I could hyperlink to files external to the database but don't want to >> > do >> > this >> > unless there are no other issues. >> > >> > Thanks >> > >> >> >> . >>
From: KB on 18 Mar 2010 12:50 Thank you for trying to help "Jeff Boyce" wrote: > I've not run across this issue before, so I'll step back. Hopefully one of > the other newsgroup readers has some insight on this... > > -- > > Regards > > Jeff Boyce > Microsoft Access MVP > > Disclaimer: This author may have received products and services mentioned in > this post. Mention and/or description of a product or service herein does > not constitute endorsement thereof. > > Any code or pseudocode included in this post is offered "as is", with no > guarantee as to suitability. > > You can thank the FTC of the USA for making this disclaimer > possible/necessary. > > "KB" <KB(a)discussions.microsoft.com> wrote in message > news:46D4D9DE-364E-42CD-AEB0-098EB999803B(a)microsoft.com... > > Hi Jeff > > > > Thank you for your response. To give you a bit more background, we have a > > number of reports within the department that we want to document in a way > > that can be searched by anyone in the department (so that they can find > > which > > reports might be relevant to them and to reduce duplication). We are > > building > > a MS Access catalogue that will be the main data store with a sharepoint > > user > > interface. Although most people won't need to see the VBA and SQL stored > > in > > the database we want to have all the documentation/backup of the code for > > the > > various reports in one place i.e. within the database. A number of the > > reports that we want to document are built in MS Excel and are automated > > through VBA. > > > > I thought MS Access would be a good way to go and that VBA in a memo field > > would be seen as text but it seems to be corrupting the databse. I have > > used > > Access's documenter in the past but do not have a similar documenter for > > Excel (although I am aware there are products we could buy). I am loathed > > to > > have a central folder with backups of the code and hyperlinks due to the > > fragility of them but would welcome any ideas..... > > > > K > > > > "Jeff Boyce" wrote: > > > >> It sounds like you are trying to document the application. > >> > >> Do you require electronic documentation, or could you use Access' built > >> in > >> documenter and print off the documentation? > >> > >> For that matter, instead of documenting it yourself, what about just > >> using > >> Access' built in documenter? > >> > >> Regards > >> > >> Jeff Boyce > >> Microsoft Access MVP > >> > >> -- > >> Disclaimer: This author may have received products and services mentioned > >> in this post. Mention and/or description of a product or service herein > >> does not constitute endorsement thereof. > >> > >> Any code or pseudocode included in this post is offered "as is", with no > >> guarantee as to suitability. > >> > >> You can thank the FTC of the USA for making this disclaimer > >> possible/necessary. > >> > >> "KB" <KB(a)discussions.microsoft.com> wrote in message > >> news:3DEC5924-ABF4-4737-B005-61340095370A(a)microsoft.com... > >> >I am building a database catalogue of all our reports and want to > >> >include > >> >the > >> > SQL and VBA used in the reports. I have added a memo field to hold this > >> > data > >> > but the database becomes unstable when I add the VBA (I copy it from MS > >> > Excel > >> > and paste it in the memo field). I suspect that Access is trying to run > >> > the > >> > VBA. > >> > > >> > Could someone suggest how I can embed this data in the database. I know > >> > that > >> > I could hyperlink to files external to the database but don't want to > >> > do > >> > this > >> > unless there are no other issues. > >> > > >> > Thanks > >> > > >> > >> > >> . > >> > > > . >
|
Next
|
Last
Pages: 1 2 Prev: Memo Field Truncates my Data in Table?! Next: Why won't Single take my number? |