I would like to make an editable continous form, where most
fields will be from table A and editable, except 1-3 fields are
a glimpse into table B and uneditable. Table A relate to table B
in one-to-many relation. I don't need to see all values in B

I would like to pass full name (path) of a list box (ListBoxName) to a
function, so that I can reference it inside the function as
ListBoxFullName.Column(0, varItem).
How should I declare ListBoxFullName ? As object, name, string or something

Is it possible to connect Access xp(frontend) to a sql server 2005 database?
hans

If I have two arrays, what is a good paradigm for comparing what is in
them, to determine what elements they share, or don't share?
Specifically, each array could potentially contain the integers 1 to
9, but probably not all 9 integers.  

I have Office 2000.  I am creating a database that will record stats
from football, basketball, and hockey games.  One table will contain
info about a game.  The game could be a football, basketball, or hockey
game.  There will be at least 2700+ records per season.  Each record

I need  a help with an If Clause. i have three contradicting conditions
and the results are not always stisfactory.
The conditions are :
If IsNull(Me![Customerid]) = True Then

A2003, XP Pro.
I have a text box on a form.  The text box is bound to a hyperlink field.  I
want to use the contents of the text box in code so I'm assigning the
contents to a string variable.  Typically, the contents would be:

I have a Report A, which compute daily sales.
Example:
Date: 18 Jan 06
Pen - 4 pieces

Situation: Stored procedure 1 which is related with Stored procedure 2
which has parametar.
Does anyone knows how to transfer value of some field from stored
procedure 1 to parametar in stored procedure 2?

I'm getting as bit confused with my queries. I simply (!) want to insert a
space into a postcode field the 4th character from the right, so, for
example, ML201TQ becomes ML20 1TQ, which is the post offices format.
Unfortunately I've been given a database with postcodes that don't ...

I come up with these questions during the day, do some research, and then
look for experienced users' input.
1. In Access, we already know it's pretty much an automatic save if you
enter data.  How can I prevent that?  How can I make an effective way in

I have the following update statement that updates one table by the
values from the other table which seems have some problem with the
syntax.
UPDATE tblResolve SET tblResolve.txtWhatIssue = tblIssues.ShortDesc,

Sorry for all the questions lately (I am trying!) :)
Here's an interesting one.
I need to create 3 records on the many side of a relationship for every
record on the parent table.  I'm importing some parent records and in this

I'm just looping through some tables and printing the names to the immediate
window.  I notice that  I lose the first few after the code has run. If I
step through they do get printed intially.  It's about 100 tables.  Is the
immediate window limited to the number of lines it can ...

Wondering if there is a way to determine that a given module is a class
module or not.
In looping through the AllModules collection, it would be useful for me
to do different things to class vs. standard modules.  I can't get at