To whom it may concern. I am putting together some simple Access 2003
databases at work and I am linking several tables to the accounting software
MAS90. everytime I open a MAS 90 linked table, I have to type my network
login id, but not my password.

I have two large tables - > 14K in one and > 16K in the other.  I am trying
to show only those records that match.  When I link the two tables in the
query via the common field and tell it to show the data it takes over fifteen
minutes to show the data.  I have even tried to show ...

I'm trying to use VBA to automate the import of a file that has the extension
of .xls but is in fact a delimited file.  When I open excel and try to open
the file the text import wizard opens.  I have tried to do a transfertext
method but it gives a runtime error 31519. ANy ...

how would I tranfer textboxes, comboboxes, and listboxes on a form to a
listbox that would keep all the info - which would go to report after?

I do a lot of programming within Access to export data and programmatically
generate charts in Excel.
Usually I can just record what I want in Excel and transfer the code(with
some syntax changes) right into my Access module.

Via code how do I rename a field in a table (Tbl_Table) from
Original_Filedname to New_Fieldname?

I want to fill a ComboBox from an Access table but I can't to do it.
Anyone knows any method?
Thanks and sorry for my English

Can you START at a chosen line within a text file, or do you always have to
start at line one.
For that matter, can you start at the end of the file, and work your way
backward?

in access 2003, the statement:  =IIf([Accounts
Subform].Form.RecordsetClone.RecordCount=0,0,[Accounts Subform].Form!Balance)
worked just fine.... when I converted to access 2007, I get:  #Name ?
I'm not a programmer, but I was using a template to keep my accounts balance:

I have a button on a form that exports various queries to a pre-built Excel
file that has links and formats just the way I want it.  The code I use is:
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "Report Map",
DestinationFile, True

Hello!  I am relatively new to Access development work.  I have been doing
excel programming for a few yeas now, and understand that tool pretty well,
but using Access is a completely different experience.  Anyway, I am
currently using a sample that I found at this site:

I set startup properties based on permissions when the db opens and lock them
down again on close.  I always leave the ByPassKey property set to true so I
can get back in by holding down the shift key.  However, I got copy/paste
happy and set it also to False and now am locked ...

How do I apply formatting (bold, for example) to text created during a sub
in access that automates word.  
For example, this code will open word, create a new document, add the date
(right aligned), start a new paragraph (left aligned).  How would I bold the

I have got a question regarding date formatting. I have got a database where
a date is stored in the format (YYYY/MM/DD).
After reading the dates I need to be able to export these dates to a text
file in the format (DD.MM.YYYY). Is there a way to format this?

I have three fields in access:
1/31/08             3/31/08                 USD 3/31/2008
Fields 1 and 2 contain multiple id numbers which I need to sort and match up
or align the records. Field 3 is the amount as of 3/31/2008. I need to sort