Search results for query: *

No, I was expecting one but it didn't appear

I am importing data into a table and I have set up specific validation on some of the fields. I am expecting some records to be rejected as they have fields which do not fit the validation. It is rejecting these records but does not tell me which records have been rejected. Is there any way to...

Hi sorry I was a little vague. There is a table of term dates for a school, Start, end and half term start and end. The database enters in two sorts of booking, one would be for a one off booking eg. an appointment. and then there would be a repeadted booking eg. period 3 on Tuesday. It is for...

Is it possible to create a list of dates in a query from a start and end date in a table. eg I have a start date of 1st Jan 2006 and and end date of 30th Jan 2006 and it lists all the dates in between as a new record. John

I have a date field which I want to validate against four other date field in another table. I have combined the information in a query and sourced the information for the Form from that query. The date entered must be between Date1 and Date2 or Date3 and Date4. If it is not I need a message box...

I have been so stupid, that is so obvious. Thank you so much for that.

I have two time fields time1 and time2. Where time2 has no entries I want to enter time1's data. I have created a NZ function to insert a 0 when there is nothing in time2 and have created the following expression in a blank field. IIf ( [time2] =0, [time1] , [time2] ). When I run the query it...

I have a field in a form which shows a figure from a query which is from a Count calculation. When I change information which realtes to this Count the figure only changes in the form when I close the form and reopen it. It does not change when I click on a refresh command button. Ideally it...

When I put a command button on a certain form I get the following error message stateing "The expression On Click you entered as the event property setting produced the following error: A problem occured while Microsoft Office Access was communicating with the OLE server ot ActiveX control...

Is it possible to populate a subform when certain information is put into a form. E.G. If you wished to record results for different students who are in different classes. Each student would be recorded in a table with his/her class in the same table. When you come to the form to record results...

I am designing a website using Adobe GoLive 5. I have set up some of my hyperlinks on the pages to open in a new window while leaving the original window open. I want to be able to specify what size this window opens and also to remove all the shortcut and address information at the top of these...

Hi AceMan1 Thanks for the help. I have put the line DoCmd.GoToRecord acDataForm, "Daycare Choice subform", acGoTo, acLast But whe i run it it tells me that the Subfrom isnt open. Any ideas John

I am using the following code on a subform (which is in the form of a list) Private Sub Course_ID_Change() On Error GoTo Err_Course_ID_Change Forms![Information Input].Refresh Exit_Course_ID_Change: Exit Sub Err_Course_ID_Change: MsgBox Err.Description Resume...

Is it possible to refresh a form from an action in the subform, how do i change the code to refer to the form? Current code is: Private Sub Form_AfterUpdate() On Error GoTo Err_Form_AfterUpdate DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70 Exit_Course_ID_Exit: Exit Sub...

that did it, brilliant. Thank you very much. John

yea i have tried that, but when it enters the field from the query it put it in like this [TotalCost5]![SumOfTotal] so the whole code becomes like this: =DSum([TotalCost5]![SumOfTotal],[TotalCost5],[TotalCost5]![AddressID]=[AddressID]) Leaving of the NZ function for the minute.

Yes there is a field called addressID in the same form as the txt box.

i dont think its a requery problem. I have a macro set up to requery conected to a command button, so have run that. The field just has #Name? in it

I have entered it into the control source of an unatached text box on the form. The addressID is numeric

I have entered the formula as follows =Nz(DSum("[SumOfTotal]","[TotalCost5]","[AddressID]=" & [Me]![AddressID]),0) Where SumOfTotal is the field in the query TotalCost5 is the name of the Query and AddressID is the id field in both query and form Its does not seem to run, am I doing something...