Search results

And this can be done with a single line of Code using ado to any already existing table To add constraint use CurrentProject.Connection.Execute "ALTER TABLE Table1 ADD CONSTRAINT MyConstraint1 CHECK (MyField between 6 and 10)" To drop constraint use CurrentProject.Connection.Execute "ALTER...

I have posted a sample in a thread some time ago it has constraints on table based on other tables and other fields in same tables have a look at it Here

In the query designer link the name and it will show you only that names which are in both tables

You can use the replace function to update data Like Replace("My Name",'"','""')

Can you give some detail whether you are using bound form or unbound

you can filter records on the basis of criterea

try this code =Dlookup("Sum Of Expr4" ,"[qry_sales]","[Expr3]='2010_01' And [product_category]='Category1'")

On report header use this =count([Club_Id])

I am sure its accde

Yes there is not runtime but lot of usefull documentation with Office 2010 Technical Preview Invitation Also access 2010 database opens in 2007 but forms and tables containing new features dont open giving a message that required version is 14 for example I have created triggers in tables...

Use this sql TRANSFORM First(Format([StartDateTime],"HH:MM") & " " & [shifttype]) AS ValFld SELECT YourTable.Name FROM YourTable GROUP BY YourTable.Name PIVOT Format(Int([StartDateTime]),"dd/mm/yy");

You cannot use another query field as criterea unless that query is a part of current query i-e joined or included in the grid atleased

Is qryUnionResourcesColumnsToRows part of your current query

use on format event of section in which that control is placed code would be some thing like this if me.check1=true then me.control.backcolor=vbred elseif me.check2=true then me.control.backcolor=vbgreen endif

What parameter it is asking for Also check your field names are they written properly

Download the sample from the link given below it has a sample query just like you want Click Here

Paste this sql in the query and replace field and table names TRANSFORM First(Format([StartDateTime],"HH:MM")) AS ValFld SELECT YourTable.Name FROM YourTable GROUP BY YourTable.Name PIVOT Format(Int([StartDateTime]),"dd-mm-yy");

Or more simply IIf(nz([ResidentialAddressCountry],"")="","A" & [HomePOCode],"X" & [ResidentialAddressCountry])

I think you are doing it through crosstab wizard You can complete your query through wizard and then open the query in design view and add further row headers you can add as many as you want

How Many row headers you want