Tags → Access Sql Function

Insert Date into Access Database

When inserting a date into an Access database you should use the format YYYY-MM-DD. Our function AccessDate returns a date in YYYY-MM-DD format. When working with a date in Access always use the # delimiters in your SQL statement.

• Categories
  • ASP →
  • Tips and Tutorials →
  • Date and Time
• Platforms
  • Windows
• Licenses
  • Freeware

Bf.Calendars

This robust, feature packed calendar will help everyone on the team track, maintain, and communicate important dates and times. With public and private calendar entries, recurring entries, attachments, user-based permissions, and the security of bf....

• Categories
  • ASP →
  • Scripts and Components →
  • Calendars
• Platforms
  • Linux
• Licenses
  • Freeware

Buy and Sell

Have your visitors buy and sell through your site. In less then 5 minutes you have this complete function running at your site, It''s totally ready to go. It uses access 2000 database, dynamic dropdown boxes, ability to search products, advanced...

• Categories
  • ASP →
  • Scripts and Components →
  • E-Commerce →
  • Shopping Carts
• Platforms
  • Linux
• Licenses
  • Freeware

SPROC Function Builder

SPROC Function Builder is a really handy windows app designed to take the backache out of writing functions to access SQL Server stored procedures. Written in .NET this application is small, easy to use and very effective. It is not limited to any ...

• Categories
  • ASP →
  • Software
• Platforms
  • Linux
• Licenses
  • Freeware

access2asp

access2asp is a conversion tool for access databases that converts your db to clean, commented pro asp /asp.net code. It produces a ''front end'' and an ''admin'' section with ability to view,search,add, edit and delete. Also prod...

• Categories
  • ASP →
  • Scripts and Components →
  • Database Tools
• Platforms
  • Windows
• Licenses
  • Commercial License

Add New Data Access Routines to Your Arsenal

This article presents three modular routines to access and fetch data easier with ASP. Topics include: Fetching a Recordset, An alternative to the GetConnectedRecordSet function that opens a connection, fetches a recordset, and immediately closes the...

• Categories
  • ASP →
  • Tips and Tutorials →
  • Database-related
• Platforms
  • Linux
• Licenses
  • Freeware

Alzabo

Alzabo is a two-fold program. Its first function is as a data modelling tool. Through either a schema creation interface or a custom perl program, you can create a set of schema, table, column, etc. objects that represent your data model. Alzabo is a...

• Categories
  • CGI and Perl →
  • Scripts and Programs →
  • Database Tools
• Platforms
  • Linux
• Licenses
  • Freeware