Search results for query: *

thanks very much Remou

Hi, Trying to work out the difference between a given date and the start of the next financial year (April 1st) AXB Addition: DateDiff("d",[LHFH_Start_Date],"THE NEXT APRIL 1st") Can someone please help - thanks

p.s. I know there is alternate ways to allow them to delete records (e.g. double click and confirm) but i would like to understand what is going on

Hi all having a problem with some users being unable to delete records in datasheet view I can right click a record and select delete record. However when some users right click on a record it will not stay highlighted. It "jumps" to the first record. This makes no sense to me as all users...

here is the actual query if you want to have a go but truthfully I think I'll have to stick with the command button - I've been doing this on and off for over a week and the command button is the only progress i've made! Thanks very much for the help though SELECT tblContracts.ContractCode...

The fields Day1 and ContractStatus are both on the same query as Days late. This query is the record source for FormA - (sfmNoticesOfIntention) There is also a field called contractname, double clicking on this field opens formB (frmContractNotes2) On closing formB the error appears Maybe the...

I tried that but it doesn't work Forms!frmContractMonitoring!sfmNoticesOfIntention.Form.Refresh the problem is with a field that is based on the following query field Days Late: IIf([Day1]<=14,"On Time",Format([Day1]-14,"0")) & IIf([ContractStatus]="NOE PREPARATION","NOE","") this field...

Hi, trying to refresh formA, on closing formB Placing a command button on formA (with wizard) I get the following code. DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70 What I want to do is put this code under OnClose in formB. However I'm not familiar with DoMenuItem and...

that gives me a type mismatch but it is the correct method -I think I should move the code to the form that opens thanks for the help!!!

the message box is part of an if statement, so I think the form would close even when not required here is what I have as a back up. What I really want is for "vbYes" to occur when clicking on ok (does that make sense?) Private Sub cmbONE_AfterUpdate() Dim strMessage As String...

My message box is a vbOkOnly style. All I want to is close a form when the user clicks on ok. I'm familar with message boxes in vb but I just can't seem to track down this answer! (usually use select case vbYes,vbNo etc) thanks in advance

sounds like a good idea - is it possible to keep changing the record set? also what is the rs.EOF() bit do/mean? thanks barry

thanks - nice idea Unfortunatly I'm exporting the report to excel and labels do not show up in excel I'll try to get a text box to appear on no data

thanks but unfortunately it doesn't really help I cannot use the solution where another table is included in the query because my query does not show any records (it's just a count). Also setting Can Shrink to No has no effect. This is the example of the type of query SELECT Count([Query...

Hi, I'm running a report with several subforms. Each of these subforms is based on a query that counts the instance of something. However when the query returns no data the subreport does not show. I been working with the subreports no data property: Private Sub Report_NoData(Cancel As...

I'm with you now I did actually try that with SELECT Count([1].Block_Code) AS CountOfBlock_Code, [1].Block_Code FROM 1 GROUP BY [1].Block_Code HAVING ((([1].Block_Code)=[Reports]![contract properties report].[block_code])); but couldn't work out why it wasn't working Requery in the group...

cheers for that but not sure I fully understand. Where would the source of the text box come from. The source of the report is Query: 1 I have actually used a subform with a record source as the list box but would prefer your solution as there is about 5 subforms required thanks

Hi, I have a report that lists properties in Blocks. I have set up a group header that seperates each block. In the header is a list box that is supposed to show the number of properties in each block. Currently I have the below as the list box source: SELECT Count([1].Block_Code) AS...

hi golom have made the changes you suggested: Days Late: IIf([Day1]<=14,"On Time",Format([Day1]-14,"0")) & IIf([ContractStatus]="NOE PREPARATION","NOE","") However this has not solved the problem. Maybe if I explain a little further. The form concerned has 5 pages on it, each of the five...

hi - I have a subform (subform A) with a query as a datasource. One of the query fields is a "calculation": Days Late: IIf([Day1]<=14,"On Time",([Day1]-14)) & IIf([ContractStatus]="NOE PREPARATION","NOE") Users can jump into another form by double clicking on a unrelated field. However when...