Where can I learn how to create unique alphanumeric employee ID codes for an Access database? I want it to be two initials and a four digit counter ie LL0000...

I want to set up my form, so that, if a person answers yes to a field on another table, they cannot enter information into a separate table. Is this possible?...

I would like to be able to enter a components description and then its serial number. After I enter the serial number I would like to enter another using the...

I am looking to import some lookup tables at startup to speed up the database. I am using make table queries which work fine except for one problem. The new...

how can i perform an autocomplete for a textbox in access forms

I am trying to write a couple lines of code in vba to support a print function... How do I print "hello" from within my form code? If I could get this...

My database used to be built on a single table. I recently split it because I needed to use one of the fields as a lookup for another field, and I got error...

Tach zusammen, ich erstellen Access-Tabellen mit SQL aus DIAdem heraus (Access 2002). Eine der Spalten soll einen Link beinhalten. Wie erstelle ich...

I would like to be able to enter a components description and then its serial number. After I enter the serial number I would like to enter another using the...

I want to ensure that users entering data in a form cannot enter duplicate values in records and have an error message automatically displayed. The table...

I'm planning to use the Microsoft Inventory Control template database to track supplies for my office. For reference, it can be found...

My system lets me add tasks and appointments on the computer, but when I touch keyboard or letter recognizer on the hand held PDA, it flashes on for a second...

I'm re-designing a database. One of the forms in this database has 10 checkboxes - each one is bound to a separate field in the underlying table. The user can...

How to convert a text field to a number filed in a formula?

I have a form that requires an ole to be inserted. These are usually pics for the various projects. Is there a way of loading jpegs (these files are usually...

I would like to know if there is a way to generate an "Order" Page. This would present details of the Customer. Then I would place a Sub-Page in it...

I have a pable that i want the primary key to be the the date followed by a sequetail number and I need the number to restart each day... Can someone assit me...

ı cant open access file which ı made at another pc why How can ı solve this problem access 2000 version

I would like to have the spell check done automatically when I send the message. That way I can review the spelling and make corrections as needed. The as you...

My database classes were nearly a decade ago and I was never very good with normalization to begin with. I could use some help with this: I am writing a db to...