This is for those of you that use MS-Access often and would like to simplify some of your code development.
For years, I used to use SQL Server Management Studio (SSMS) to spit out the SQL to create a Table and then I would do some Search and Replace on the code provided by SSMS to take something like this:
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
And create this:
Expand|Select|Wrap|Line Numbers
sSQL = sSQL & "", [Attachment].[AttachmentID]""
sSQL = sSQL & "", [Attachment].[Attachment]""
sSQL = sSQL & "", [Attachment].[Type]""
sSQL = sSQL & "", [Attachment].[Category]""
sSQL = sSQL & "", [Attachment].[Supplier]""
sSQL = sSQL & "", [Attachment].[Reference]""
sSQL = sSQL & "", [Attachment].[Description]""
sSQL = sSQL & "", [Attachment].[Suggested]""
sSQL = sSQL & "", [Attachment].[Internal]""
sSQL = sSQL & "", [Attachment].[CreateDate]""
sSQL = sSQL & "", [Attachment].[LastUpdate]""
sSQL = sSQL & "", [Attachment].[LastUpdateBy]""
I knew I should automate the process, but it was one of those things I kept putting off till later. I finally got around to creating a basic version of this about a year ago and it wasn’t pretty but it worked and I’ve been using it a while now. I’ve had a few spare hours this week, so I packaged it up all by itself and here it is. Please let me know if there are bugs or things that need improvement.
What’s inside? …not much. There is one Form and a couple code modules. A Screen shot of the Form is below and the top three fields (and two checkboxes) are used to generate the code in the bottom Field.
The magic happens in this function:
Expand|Select|Wrap|Line Numbers
Public Function reportTableColumns(ByRef sDatabaseName As String, ByRef sTableName As String, ByRef sFormat As String, ByRef bIncludeType As Boolean, ByRef bCRLF As Boolean)
' Gets a list of Table Column Names and Formats per request
Do you know where to find some peace of software/code which I can
implemented in my desktop java application which will protect it from
illegal using?
I imagine something like: buyer can install...
I am converting optimization code from legacy C to python. Generators are a
HUGE convenience, because the original code structures have the optimizer
as the main code calling your function, while...
Hello there,
I have written a code generator for our internal use. Right now it is
implemented as an independent application. The generated code (which is
really a block of code containing 4-5...
Our Product is 100% free, we are not trying to sell anything here.
MyGeneration is a .NET Code Generator that allows you to create
templates in either VBScript or JScript, it also serves up all...
Hello
I do have a sudden problem with my Visual Studio (.NET Framework 1.1, Visual Studio 2003 version). All was fine and well until 2 days ago when unexpectedly I started to receive the following...
Hi over there,
I'm building a webservice (C#/>Net 1.1) and I'm trying to add a web
reference , a WSDL file from a location "c:\inetpub\WSDLfile.wsdl" . (This
is the WSDL file of another webserver...
I have a database with several tables. I need to create pages, and
most of the pages would talk to only one table.
I am wondering if there is any wizard/code generator which I can use to...
It's been over 10 years that I don't look at Access. I've been working
in asp.net for the last 5 developing intranet sites.
Just got a project where we are trying to avoid building an...
HI,
When i am going to make Exe file my visual basic application shows "unexpected error occurred in code generator or linker" this error how can overcome this one.
Thanks in Advance,...
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation.
Take...
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...
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
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...
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...
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
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...