There Appears To Be Some Confusion.

The Server Name That You Are Being Asked For Is NOT Necessarily The Name Of Your PC. It Is The Instance Name Of The SQL Server Installation.

NOTE: You Can...

If All The Labels Are On The Same Form, Then Use A Control Array Of Labels With Index Values 0 To 9

Then A Loop Will Do The Trick


Function MaxLabel ( Optional nLoopMax as Integer = -1 ) as...

You're Having A Laugh.....Surely !

If You Really..REALLY Don't Know How To Do This, Then Send Info On :

1. Why It Appears You're Using Dynamically Generated Labels
2. Where The Integer...

It Would Help If You Gave The Table Information & Your Attempts @ Joining Them. Then I Could Suggest A Course Of Action.

You Can't Embed Software Into A SQL Table Field !!

Do You Mean Put The Human-Readable Form Of A Barcode Into A Field That Can Then Be Extracted To Send To A Barcode-Printer ?

I've Used The...

This Is All Very Well, But You Haven't Said WHY You Want To Do This. If You Put It In Context, Then Maybe More Help Would Be Forthcoming.

Also, What About Words With Double/Triple Letters :
...

OK, But What Is It You Want To Do ?

1. Count The Number Of Different Combinations....This Is A Straightforward Factorial Problem.

2. Enumerate (List) All The Different Combinations....This...

I Don't Think There's A Built In Function Specifically To Change The Base.

The DIV & MOD Function May Help. Without Some Fancy Maths, Use These Functions To Create A String & Then Use The VAL...

You Say Something SEEMS Wrong. Did You Get A Runtime Error ? If So, What Was It.

It's Been A While Since I Did Any VB, So Someone Will Correct Me If I'm Wrong.....

There's Nothing Wrong With...

Hmmmmmm

I Know I'm New To DaniWeb, But I'm Afraid I Agree. I've Been Rather Suprised @ The Number Of Replies I've Sent Introducing People To Google !!!!

Is It Them Being Bone Idle......Or Me...

Are You Still Having Trouble With This Or Have You Sorted It ?

Yes, But You're Better Off Checking It Out For Yourself !

Just Try Google "Temp Table" !

Really, If You Just Google "Access Expression Builder" You Get Lots Of Useful Stuff.

However, As It's A Quickie. I Generated A Table (tblPerson) With FirstName, LastName & DOB. To Get The Ages Of...

OK, So I Assume You Have Something Like The Following (Using Visual Basic Terminology)

Sub TabMenu_Click (Parameter List)
{
Something That Tells You Which Button Has Been Clicked/Actioned -...

OK. Cool.....Is It The DeskTop Version 'Cos I Just Tried With The Standard Version & It Basically Said Client Tools Only.

It Seems You Want 'comment_mreference' To Mean Two Different Things. Why Bother. Add An Extra Field Into tblRegister register_type (0=Admin, 1=Guest etc)

Also Include Administrators As Registered...

You'll Have To Excuse Me For Being Dense.

What Do You Mean - You Can't Use TabIndex Because You Used It For A TextBox ? Did You Not Read The Last Post ?

What Programming Environment Are You...

You Can't Install SQL Server 2000 Standard On XP Pro Either.

You Must Use SQL Server 2000 Desktop (Personal) Edition

It's Not Too Clear What You Want.

1. A Query That Gives You Rows Where id1<id2 ?

2. A Query That Gives You Rows Where id2<id1 ?

You Mentioned Temporary Tables, So Either You're Making...

I've Attached The SQL & Explanation For Both Queries

I Hope This Helps.

Rob

Firstly, I'd Suggest Microsoft SQL Server Expess, Rather Than Access. It's Free & Downloadable From http://msdn.microsoft.com/vstudio/express/sql/

It Allows You To Generate Relationships Between...

If Your Experience With Databases Is As Limited As You Say, It Seems Your Rather Jumping In @ The Deep End.

Maybe Focusing On Some Of The Fundamentals Will Provide A Better Starting Point.
...

First Off, If You Haven't Already Got A RDMS (Relational Database Management System) You Need Something Like Microsoft SQL Server Express. It's Free & Downloadable From...

Straight From MSDN :-

Control.TabIndex -

Gets or sets the tab order of the control within its container. Namespace: System.Windows.Forms

Control.TabStop - Gets or sets a value indicating...

First & Foremost, Why On Earth Would You Want To Monitor Changes (Inserts, Updates, Deletes, Create Tables !) In The WHOLE Database ?

What Programming Environment Are You Writing Your Application...

I Think The New Layout Is Better.

I Wouldn't Worry Too Much About An Extra Join In The SQL Query. So Long As The PKs Are Integers & You Use Clustered Indexes (Assuming You're Using SQL Server /...

No, Not Always. If The Diagram Is Getting Messy, Then It Points Towards The Database Design Needing A Look At.

I've Checked Out The Sample Pic & My Thought Is That There's A Lot Of Pairings Of...

Please Tell Me You've Sorted This By Now.

Try An Embedded Connection String !

Google "database connection strings" For Details

Hey,

I've Attached The Reply.

What About The SQL ? Have You Got SQL Server Or Some Other RDMS To Play With ?

Where Is The Formatting Taking Place - SQL ?

FORMAT Is A (Among Other Things) A VB/VBA Command - NOT SQL

Regardless Of This, 31st Dec Is the 1st (Or 2nd Day In A Leap Year) Day In The 53rd...

Hey,

I've Attached The Relationship Diagram.

It Might Not Mean Very Much Without The Table Contents To Flesh It Out. But I'll Get To That Soon.

How Much Detail Do You Want To Go Into With...