A2K
Say a combo RowSource query has 5 columns, with the last four visible in the
drop down list (column width of 0" for column 1). The bound column is column
1. After a selection is made, I want the displayed column to be the fourth

I have a form with two check boxes PPL & DLP both
controls are in tblReviewH1
on enabling one I want the other to disappear.
I am attempting to use Dlookup to validate the state of

Hello, I have a 45.000 record table with a field that has addresses, (street
name and street number). In my country we write the address in the format:
Address name and then address number, for example "Rhodos 59". I need to
know in which records there is no number after the street ...

I've managed to get Access to send information directly to a Word document
filling in the necessary fields in the Word document as necessary (aren't
bookmarks wonderful!!).
Anyway, whilst that has worked perfectly well where there is only one result

I am new to advance processes of access.  I would like to stop warnings in a custom form.  There are two buttons for previous and next records.  Each time the end is reached a warning comes up that says "you might have reached the end of your records".  This is disturbing to ...

In a table I have two columns that may sometimes hold the
same codes, for Example:
Col1    Col2
xxxx    xxxx

How do you find the 1st Friday after a variable date?
TIA,
Jake

I have a system set up for single merging of data (many thanks to Albert)
What I am looking for now is the methodology to allow me merge a list of addresses onto a standard word template
What I have at the moment is a form with a list of addresses with a check box and I would like ...

Hi Al
I have been asked to setup a new database for staff training..It doesnt have to be majorly complicated but i thought i would ask your advice.  My first project has some aspects that aren't normalised so i thought before starting another one i had better learn how to do it ...

I got a 'Cannot open any more databases' message. I have no idea what this means. I had one database open and was printing a report
There may have been a DLOOKUP somewhere in the report, just in case thats a factor
Anyone got any ideas, it sounds serious ?!?

I have a fishing vessel with a different crew of three people when they go
out for a fishing trip. I have started building a database to try to capture
what has been caught during each day of the trip by each fisherman and I am
having a dillemma with one of the forms. Here is the ...

when i try to start access 97  on my windows XP home
addition machine I get the message " microsoft access
can't start because there is no license for it on this
machine."  It is part of my office 97 pro cd and all the

What's the best way to login users, then only display data that pertains to
them?
I'm creating an Access Time Clock of sorts, and would rather not have
everyone see everyone else's hours and payrates, etc.

I have 45000 records. In one field about 80% of those records are in a
format: 4numbers space and a word (any word). What I need is  to delete
those 4 first numbers in every record that begins with 4 numbers. Is it
possible? Can someone help?

I am a real access simpleton (although improving all the time). I have a
query and subsequent report which has three columns showing -  names,
number of items required (using the count function) and number of items
dispatched (also using the count function) I would like to find a ...