using transfer text to create a.csv file from a query I can either, use an
output spec to use no quotes in the file, OR I can use the HasFieldNames
Parameter to output filednames in the file. I cannot do both. I am trying to
do both  ie. create a file with no quotes and with ...

I have different subforms inside a form, while 2nd subform depends on the
number indicating on the 1st subform. That is, if there exists the number
"1", there should be only 1 record in the 2nd subform. I've already
constrained it with the following code:

MIDNIGHT Club II NISSAN SKYLINE
This is a beautiful car with ?65,000+ professional customisation. It produces 350+bhp, 0-60 < 5 seconds and achieving 165+mph! It also has a Zex nitrous bottle giving up to 100+ additional bhp.
If that's no enough for all you cruising street jockeys ...

Hi,  I am getting a run-time error "The database has been placed in a state
by the user 'Admin' on machine .... that prevents it from being opened or
locked."
I also get another runtime error, "Could not use; file already in use.

I have a situation where I need to reference multiple toggle buttons by
reference. I need to create a loop where each toggle button object is
individual controlled.  For example, the following pseudo-code demonstrates
my intent:

I have just inherited a database and am converting it to SQL Server. There is
one place where a Table is exported to a file. In the code it does a
    DoCmd.TransferText, acExportFixed, "Spec name", tablename, filename
I would like to know what the "Spec name" contains. Is there some ...

Ive got a line of code and its too big to fit on just one line.  Is there
anyway i can put it on two lines but logically link it? or do i need to
rewrite the line of code?
Cheers

I would  back up certain files (other that the usual
office backup)  and save to a SmartDisk a hard drive - I
do this daily - it takes a while to select these files it
possible to create a Macro to do this function?

Hi, from my VBA code I am creating a dynamic control Label and Text Box.  I
need to force a "line feed" or "carriage return" in in the middle of the
text.  I tried adding a Chr(10)  and Chr(13) value to the string but this did
not work.  For example,