Help.
I am a bit flummoxed by the problem of how to transpose "normalized" (in the
database sense) data records into columns of for a data entry form, and then
back again when the user is finished.

Firstly, I want to thank all that have helped me out with getting grips
on Access each time I've had questions. This has got to be one of the
most helpful groups that I've posted to over the years.
Now my problem...

I have recently looked at somebody else's access report for printing
labels. I don't understand how it manages to shuffle data about to
format the labels correctly. Any ideas would be appreciated.
The report has 6 Text boxes decending vertically down the label with

(dhl) Using Access 2K.  I have a ISBN number that is 10 char long and
has dashes somewhere in the number. I need to remove the dashes and
just leave the numbers.  Is there any way of doing this?  Thank you
for your help. David

Okay, I'm beginning to think about what I should do about distributing my
new program to my clients once it's more polished.  I wrote my existing
program in dbase/switched to Foxpro and it's still in DOS.  So, you can
probably see I've had a bit of a learning curve to overcome.  I'm ...

In general will I see any query performance gains?
More of a DB2 guy myself.
Regards
Phil

I'd like to change the top margin of a text box based on a State
Field.
If the state is LA  I want the box to appear 1" from the top, if it's
CA I want it to appear 2" from the top.  I was trying code similar to

I have a text field on a form which has names with a comma between them like
this: 'J. Smith, A. Jones, A. Man, J. Johns'.  I am trying to find a
procedure that will count the number of people in this text box and put the
number into another text box (4 in the case above).  If I ...

OK...here we go again...
Here is what my report looks like...it is sorted by "code"
Code N
    Date        Job Number   Amount

I am making a quiz with a four-option-multiple-choice scenario.
When you enter the quiz, you provide one answer and three wrong answers.
Then the contestant opens the quiz and I trying to present them the four
answers on the page in a randomized way (i.e. you have no idea which one

I have a vba string taht dynamically creates the query which has two dates
in it that it grabs off an open form as a string from the textbox.
What I generate in vba is:
SELECT DOSMBK.Date, DOSMBK.[DOSM-DSName] FROM DOSMBK WHERE

I have an Access2K table in which several records have nulls in some
fields. In code that iterates through this table the statement
If Not IsNull([Field]) Then ...
(or If IsNull([Field]) Then ...)

Is there a way to hide the Access window from code?

I have an Access 2000 database where each record has it's own photo stored
as an OLE object.
I am trying to export a report (of all the records) to HTML format.
The data for each record exports without any problems but how do I get the

My form has "Arrival" to be filled in by user.  I need a report of all the
arrivals for the next 7 days.  In MSWorks database, I used => now() and <=
now()+7 to filter, naturally it doesn't work in Access 2000.  Is there a
comparable command?  TIA