the following query works fine:
select link.idx, link.x_table, link.x_id_a, link.x_id_z, a.strandid,
b.strandid
from link_detail, link, strand A, strand B

I have an ole object field (Access XP/2002) which I store images in.  I have
a couple of questions regarding this; is it possible to determine the image
dimensions?  Secondly, is there any way to determine what application is
associated with the stored OLE Object and is there a ...

Fields in MyTable:
PostID
PostDate
RollQtyXfer

Generally, I do not monkey with renaming controls on forms
whose name, by default, matches the name of their related
table fields. But I noticed the following today
   If IsNull(Me!VColor) Then

On frmVehicleEntryForm...
I wanted to change the DefaultValue property
of one of my textbox controls on a form from within
code. I wanted the setting to be no setting - as if

I have a select query (Query1) that, when run, could have either a 1,
2, 3, 4, 5, 6, 7 or 8 in one field (Field1).  I then have a follow-on
query (Query2) whose source is Query1 and one other table (Table1)
which is a one record table.  What I'm trying to do in Query2 is look

This is a tougher one, but I'm quite sure someone will have a solution
for this.  Of course, a last minute thing thrown at me by my boss.
I have a unique identifier consisting of regions, districts, a road
class value and then sequential numbers, in that order, eg:

Does anyone else get "ghost" VB editor windows appear on their computers
when developing in Access 2003?
These are VB editor windows with no menu items and a grey empty
background.  I usually get them when I contact my work computer through

I have a summary query in Access97.  I look for staring and ending date
and sum the grosspay.  I took the sql from the query and I'm trying to
convert it in VBA withing Access.  I keep getting Error:  Expected line
number or label or statement or end of statement.  I know I'm ...

hello..im new to this group and i need some help with my work
im trying to find code that will allow me to print a microsoft access
table in vb
does anyone know the code?

Here's the issue:
I have roughly 20 MS excel spreadsheets, each row contains a record.
These records were hand entered by people in call centers.
The problem is, there can and are duplicate phone numbers, and emails

Problem: Query record selection criteria reads Like [Last name?] & "*"
 BUT, then Access changes it to non-functioning Alike  [Last name?] &
"*"  
Any ideas?

Slight little problem again (hopefully the last one).  The script below
should check whether my file path exists and then either load the data
or prompt the user to choose a path that exists.  At the moment I'm
getting a bad file path error.  Well, that is the idea.  If I choose

When I reach a certain record, I receive the following message:
 " The Microsoft jet database engine stopped the process because you and
another user are attempting to change the same data at the same time."
I have tried refreshing the record but was unsuccessful.

I've got a form that is opened in readonly mode and no fields can be
changed, great
but if I click on a combo box that has an _enter() event that sets a
field on my form to a value (albeit the same value it currently has),