LQ.Net

Excel Articles and Tutorials on Excel Functions and Excel VBA Programming.

MS Office and XML Tips and Samples

Articles and lessons for MS Office products, XML, VB and web scripting.

XSD - XML Schemas

Programming with XSD Schemas and XML. ... XSD Schemas. Printer Friendly Page Basic XSD Format:. <?xml version="1.0" encoding="UTF-8"?> XSD Namespace: ...

Setting Auto Numbers in Access Databases

How to reset, change or work woth AutoNumbers in Access.

DLookup Command in Access

Working with the DLookup command in Access VBA programming.

Display an OpenFile Dialog Box with EXCEL

Excel OpenFile Dialog in VBA Code. ... Display an OpenFile Dialog Box. Printer Friendly Page The following code can be used to display an OpenFile dialog ...

Reading through files in a folder in Excel

Read through a folder with Excel in VBA Code. ... Reading through files in a folder. Printer Friendly Page This code allows the user to read through a ...

VBA Code for Creating ID Numbers

Example of generating Auto-numbers in VBA code. ... GetID Utility. Print Version Printer Friendly Version. Instead of using an auto-number in a database, ...

Domain Aggregates in Access

Working with Domain Aggregates in Access in Queries and in VBA code.

Combo Box Control in Access or VB

Using Combobox in Access and VB or VBA. ... Combo Box Control. Printer Friendly Page. The ComboBox control is an VB/VBA control that can also be used in ...