Search results for query: *

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...

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 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...

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...

I understand the principal in using the dsum function, just not how to apply it. I have a form (address). I wish to put a field, in currencvy format, in this form from a query from a subform (finance). Each record on the form has its own ID (AddressID) which is also used on the query. There are...

I have a form which has a subform and that subform has a subform. There are fields in the parent from which come from a query which is made up of fields from a couple of these forms. I have a refresh button on the form but it is not refeshing the data from the query, which only changes once I...

I have done a calculation in a number of querys and wish to show the totals in the parent form of the database. I can display the information by use of a sql statement without any problem, but as soon as I link in the querry it then does not allow me to enter new records, anyone got any ideas.

I have a form (call it [parentdetails]) and this form has a subform (call it [childdetails]). There are therefore several children attched to each parent. The subform has been set up from an original form so is displayed as a straightforward form not a list as it would if access had auto created...

I have a form with a subform, which was created from an existing form. The form records can have multiple records in the subform attached to it (eg one parent that has multiple children). I wish to group a total from all of the records attached to the individual record and display that total in...

I have set up a query with a table as its source data. This query then linked to a from for entering data into the table. The table holds information about children including their Date of birth. I would like to be able to filter out certain children when they reach a certain age. This filter...

Access 97 doesnt seem to have Nz the ability to use Nz functions. Is this correct and is there any way arround it?? many thanks John

Ive done something really stupid and lock myself out of any administration controlls by limiting access to toolbars when starting up the database. Is there anyway to get back in. John

is there a way to set a criteria to show everything but one type of entry in a field in a query. John

Is it possible to limit the number of charaters in a memo field. John