Recent content by jtoutou

you must put this statement in SumOfAnnualNonContractSpend criteria.....

you will 57 records instead of 65 because some LOB have maximum 3 or 4 records...and also there are suppliers ranked two places in top 5

In (select top 5 [Detail].[SumOfAnnualNonContractSpend] from [Detail] where [LOB].[Line of Business] = [Detail].[Line of Business] Order by [SumOfAnnualNonContractSpend]Desc) set this statement in SumOfAnnualNonContractSpend criteria

it works fine ...thanx a lot..uncle gismo and pbaldy for your replies

As the title describe my reports are open behind the form .. i think the solution is easy... but i stuck.In my forms i have Docmd.maximize . can somebody help me?

YOUR ARE VERY RIGHT ...Thanx a lot for your advise..i'll check it for a while in the way you told me...

i agree with you totally...i spend at least 13 hours to find out what is going on....the caption property on tables is the label on the field when used on a form...but how can i set the caption string equal to the actual field name when the query and also the report is dynamic. the query is...

there is a query called "My Query" which is dynamic this query is based on a table .. in this table i change the caption on fields. when i run the query i have "field names" the caption i was set. i made then a code to open the report...which is also dynamic .. this is the code i found Dim...

this is exactly the code i use for openning the report..but my query is dynamic....and every time i open the report the labels changes according to the names related to the table and not from the query . in my the table for e.g i have products as name and "products in greek" as caption.. the...

HI AGAIN..... i need help i create a dynamic report based on dynamic query and i need to change the labels...how can i do that.... thanx in advange...note that in the dynamic query i have the lables(column headings) i want to... but in the reports the labels still have the names related to the...

Hello to everyone!!! i need to ask something I CREATE I DYNAMIC QUERY .....HOW CAN I CHANGE THE NAME OF THE COLUMN HEADINGS? THANX IN ADVANCE

good morning rsmonkey....in my application i have something similar and i you this code: Dim strSQL As String DoCmd.RunCommand acCmdSaveRecord strSQL = "Update [Itemdisplay] SET [Itemdisplay].[itemshow] = false" strSQL = strSQL & " WHERE [Itemdisplay].[itemshow] = true" & ";"...

THE FORM IS OPEN ONCE.... OR AS ADMIN .... DoCmd.OpenForm stDocName, acNormal, , stLinkCriteria, acFormEdit OR AS USER .....DoCmd.OpenForm stDocName, acNormal, , stLinkCriteria, acFormReadOnly IS THIS A RIGHT WAY OR NOT?.... IF YOU HAVE ANY OTEHR SUGGESTION I WILL APRECIATE...THNAK YOU

so sorry for all....it was my fault.... when i made changes to subforms in design view i did open the form when it was commanded in read only data mode....so the allowaddition,edits,deletion were still no.... i change to yes so everythimg is seems to be perfect......thanx T.smith

i try also with a command button.. depending on the password the the form opens as readonly (for users) or edit data mode (for admin) but i still have the same problem..the subforms still in read only data thanx for your reply..