Search results

I have a form with a query as rowsource.When I open the form in data sheet view form header is not showing(Though it is visible in form view).Is it possible to show the form header in datasheet view? Vengsiva

I have a form with a combo and a pivot chart in a page control.Can i filter the rowsource of the pivot chart on the value selected in combo? vengsiva

Thanks It works if I rewrite PIVOT Format([Reception],"mmm") In ("Jan","Feb","Mar") for quarter 1 similarly for other quarters.I am now trying to work out way to generate a query with VBA which will work when user inputs a quarter for which he wants the cross tab by clicking on a listbox vengsiva

I have a table like this Cultureworkload Reasonfortesting IRLNumber Diagnostic sputum specimens processed Follow up specimens processed Reception Follow up 7/2013 0 1 02-Jan-13 Diagnosis 8/2013 1 0 02-Jan-13 Follow up 9/2013 1 0 02-Jan-13 Diagnosis 10/2013 1 0 02-feb-13 Follow up 11/2013 1 0...

Thank you-That is exactly what I wanted

I have a table with the following fields LabID PatientNo Testdate Testresult On different dates the test may be repeated The test result may be either Sensitive,Resistant or null I have grouped all patients using find duplicates(PatientNo) I wanted to build a query or VBA to find out the...

This link is also worth a visit http://www.fontstuff.com/access/acctut14.htm vengsiva

Urbecar "Syntax error in date in query expression '[datum_posoje] =#4.6.2005#'" The expression should have been [datum_posoje]=#4/6/2005#.The solution you found works only when the criteria is current date.Krunalprajapati's works for any date provided proper date format is used vengsiva

Alternative code for validation Hello usermj While designing the form if a value is compulsory you can assign the error message as a tag property for the control .Then try the following code Dim ctrl As Control For Each ctrl In Me.Controls If IsNull(ctrl) And Not...

Macro error fixed Pat I have since been able to fix the error.I simpley had to specify view for opening the form.Altough vb code allows for a default view macro does not.I dont understand why.There is some problem with unload event of the form frmPrereport at gmultiselect.Perhaps the data base...

Problem in membership sample database Pat I got an error message clicking the menu item pivot chart in switchboard: Macro name:mopenAttendancePivotchart conditon true Action name Openform Arguments frmmembersAttendingPivot,,,,edit,normal vengsiva

From access to excel Please see this link http://www.mvps.org/access/modules/mdl0035.htm vengsiva

To update suqty hello Instead of putting the value in the data property of txtbox at the footer you may assign it via vbcode in the after update event of the field qty thus Private Sub Qty_AfterUpdate() Me.Txtsumqty = Nz(DSum("qty", "yourtablename", "month(edate)=Month(Date()) and...

Sum qty for current month Hello Have you tried this =nz(DSum("qty","YourTableName","month(edate)=Month(Date())"),0) vengsiva

Another solution? Hello rythem Since the time of last posting I did some rethinking and came up with another query SELECT Query1.ProductId, Max(Query1.DtTransaction) AS MaxOfDtTransaction, Last(Query1.Balance) AS LastOfBalance FROM Query1 INNER JOIN qryGetBelowThreshol ON Query1.ProductId =...

Last date transaction for each product Hello rythem Define a public function thus Public Function DaysElapsed(TDate As Date) '******************************************************************** ' ' Comment: Get Days elapsed between transactiondate and Lastdate Transaction for each...

Setting criteria or filter Hello Have you tried inserting the criteria DtTransaction=date in query1 and then running qrygetthreshold or setting the filter to dmax("dtTansaction","tbltransactions) for the report? vengsiva

Using alias Hi.In the query design view right click the table and in properties give the alias "a" for the table vengsiva

Checking for threshold Rythem Please whether the attached db serves your purpose.As subquery is used it may be slow Vengsiva

Inserting date for summation Referring to the post by 3239 I think the problem is because there is no date field in the table AlAccued_Details.I inserted a date field Date_Acrued in that table and built a new query from alUsed_details as below SELECT a.ProductID, a.Date, a.Quantity, (Select...