Hi,
Your best and simplest solution is to use ASP which will require you to install IIS from windows cd. And for how to do it, there are 1000s of codes describing connecting ASP to DB on the web.

Hi,
Your example is not that clear but i guess that you need to transfer your query to a crosstab.

Hi,
If you are using access you have to include the code in the before_update event of the text box.

Hi,

Please check the attached example.

Hope it will work for you.

Hi,

I have used lately the developer extensions of access and they don't actually create you a stand alone wersion of your mde or mdb but:
It will create you an installation file with the ability...

Hi,

Add in the validation rule: <=999
and the required message in the validataion text.

Hi,

I think there is no way to format part of the field directly in the table. Accordingy you may need to put it in a query and show it as:
Format(Left([CredNum],11),"XXXX XXXX XXXX " &...

Hi,

Try this (it applies for 2003, I don't have 2000 installed now), delete the linked table and relink it while using the table name there is supposed to be a check box to the buttom right of the...

Hi,

The easiest way is using the function DateSerial so that it would look like Between DateSerial([Forms]![frmCriteria]![txtFrmYr],[Forms]![frmCriteria]![comFrmMth],1) And...

Hi,
I have attached u a DB with one table to check it, if I wrongly understood you please clarify.

Hi,

In the design view select the field and in the format property (in the lower part of the table design view) put 0000. This will show the number 1 as 0001 or 888 as 0888 noting that it is a...

Hi,

The best you can do do is to create an mde file with hiding the database window and menues and running a startup form. This is the nearest you can do to simulate an exe.

Hi,
What brale said is true if you are using SQL Server, but in case of access the wild char. is * so it will be:
where name like "chr*"

Hi,

Please try to replace the True by 1. (Members.Member=1)