I have copied my database onto a DVd and brought it home to work on but when
I tried to open it from the DVD (datadisk),I got the below error message.
What am I doing wrong ?
Unrecognized database format <filename>. (Error 3343)

I have some old code that I use from the Access 95 Developers handbook.  The
code works very well, with the exception that it doesn't seem to recognize
wide screens, and sizes tab controls so that they are too big and wind up
covering up some of the fields on the main form.

I have searched all over google groups and internet, but I have not
found a solution to this problem that has worked. The solutions I found
helped me single out the line that is causing the problem, though.
I programmatically open a Microsoft Excel file from Access, do some

In my report called rptStockFlow i have the products
underlined with red if balance is not equal to in - out:
Const conNormal = 400
Const conHeavy = 900   ' exra bold

I have a form which is displayed at start up as the default.  I am
the only person who accesses the underlying tables and queries;
data enterers just need the form.  I am running Access 2000.
I would like the form to start in maximized form (i.e. take up the

I have a form with an unbound combobox at the top and seventeen controls
below it. Is there a simple way to prevent data entry in any of the controls
until a selection is made in the combobox?
Thanks!

I posted an inquiry on how to create a database to calculate the cost of an
assembly.  pietlinden was kind enough to take the time to spell it out for
me.....  however, I can't understand the answer.  The answer is posted
below.  I understand the first two items are tables but ...

Is it possible to hide or show a fieldvalue in the DETAIL section depending
on the value of another field ( ArticleNr > 199)
The original value should be kept so totals stays correct
ArticleNr    Quantity  unitprice  Total

I want to achieve that the combination of values over multiple columns
in a table are unique.
I know this works for SQL Server, but how do I declare this in an
ACCESS 2000 data base (prefereable in table design ) ?

I am trying to send email from within access. When I try to create outlook
from within access using Set objOutlook =
CreateObject("Outlook.Application"), I get the 'Automation Error, The
specified module could not be found.".  I can see the outlook 11 reference

Hello friends,
did somebody try this, is it possible to change Linked Table's links on
run time?
Lets say, database in mde format opens, and you need to change location

  I have a huge table with ID, Name and other info. ID can be either 1
or 2 or 3.
I wish to create a query which sorts the data by ID, but in this order
2,1 and then 3. Is there any way to use Order by(or any other option)

Hallo NG,
ich versuche mich schon seit einigen Tagen daran eine Datei per VBA
umzubenennen.
Und zwar möchte ich eine Textdatei in Access importieren, nur leider hat

I have a query [qryRecords] with field names [strFirstName] and
[strLastName].
When I access any given record in form "test", I want the user to be
alerted if there is more than one record with the same first name and

I ave been given a task to find out about Microsoft Access and the future
that lies before it and i have looked on the web without any great luck or
any real new information.
I was just wondering if anyone had any future info or if they could point me