I have two tables connected by Medical Record number.
I would like to pull DOB from Main table to Encounter form, that is based on
the encounter table.
I tried this

Hi Des this is Gloria from work at centa care
How have you being for the last 4 months?
where are you working now?
I miss you a lot

I deleted a couple of records from my table, is there anyway I can re-order
the ID number that is assigned, so it goes consecutively, rather than skip
around ex, 7, 10, 11......

Hello. I need to create a TABLE3 from TABLE1 and TABLE2.
 TABLE1
 field1
 1000

I am trying to do a "vlookup" on access where I need the following:
If the name of the company "Account Name" - (table called cac) - is similar
to the "unique name" - (table called log)- than bring the "NBC Country
agreement code" located on table CAC. Is it possible to do this?

I have some strange problems happening with some lookup lists created in a
table using the Lookup Wizard.
I have a field for State of Residence [GRES] that is a number field
(integer, 2 characters). I have a separate table that has three fields that

Below is a snippet of code that I need help finishing.  One of the fields in
my AccountNo table stores the cell location to retrieve data from an excel
spreadsheet.  The data stored looks like this "Sheet1!K5" i.e. the sheet name
and cell location.  I am also getting the path and ...

I created a sales order invoice tracking database based on the
NORTHWIND database.
I have keep everything as close to default as possible and modified a
few field names in the forms to track sales order id/date due

I've migrated my tables to a SharePoint site and with a few edits,
things are
going well.  Except one field.  I have an unbound text box in my form
that

2003
The VBA module exists in Tools.mdb
So I run NewAccessDatabase() from Tools.md
I get pieces parts to work but not the whole thing.

In Access 2007 database table, the AVERAGE function at the bottom of the
table has 14 numbers after the decimal.  I only want one.  Help!

there is a small bookstore in Chicago that needs saving. It's the only truly
dedicated Spanish and Bilingual bookstore in the Midwest, and one of the very
few remaining independent Spanish bookstores in the US. The owners are
struggling to survive, and don't have much money to ...

I have a large database in a multi-user environment. The database has a main
form with a subform as well. Several times now, someone has gone to open the
database, and the subform has disappeared from the main form. The table with
all the data is still in the database and so is ...

The database works perfectly fine in runtime with 5 out of 6 users.  The 1
user can open the database with runtime, but errors out upon opening a form
from a command button.
 The error "Execution of this application has stopped due to a run-time

Once I enter an employee ID, I want access to populate the first,last name
fields accordingly so I don't have to type it in every single time.
Example: I have Joe Smith with ID 9999. I want to type 9999 in a field and
have the name populated.