Search results

thanks wazz - I knew there must be an easier way Al

Hi I have a ListBox on my form that takes its data from a Query. I have been... opening the query executing a requery opening the main form recalc on the main form How do I execute a requery and refresh my ListBox WITHOUT opening the query ? Thanks Al

The query is to return the total number of days absent a student has had. After the query is run, the number isnt being refreshed in the text box. I thought there might be an easier way of referencing a query without opening it. How do I do this ? Thank you in advance Al

well I tried it and using "Forms" instead of "Me" has resulted in the form not being found ?? Also, the requery seems to put the code into a loop as it starts the Current event which in turn triggers the Sub I was in, hence the loop...

thanks bob

Hi Can anyone tell me why the text box underlined below wont refresh when I re-open the form and refresh it. DoCmd.OpenQuery "Pupil_Absenteeism_All_Query", acViewNormal, acReadOnly DoCmd.Requery DoCmd.OpenForm "frm_Pupils" txt_Absence.Value =...

Perfect Thank you Al

Thanks Ross, I will give that a go...

Hi, I have a form which has a combo box on it that takes its data from a query. When I open the form the query works fine and the combo box behaves as expected. However, I have now embedded that form within another form (frm_Quotation), and now I am getting a prompt for the form. See the...

Hi, I have a list box with 3 columns and several items in the list. When I double click a particular item, I want it to launch the form related to that item. The same form will be used for all items, I just want the the form to open with the appropriate record filtered. I am happy that I...

I did think about using a Guardian table for Guardian, Mother and Father, but, it may well be that the father of one child, might be the Guardian of a different child. I think forcing a Guardian type against a Guardian record might be restrictive. It seems to work fine as I have it right now. Al

I had a play around with the list box idea and I got it to work

OK - heres how I fixed it. I have a field for Mother and a field for Father in the Student table. I created a query that uses the Student_ID, Father_ID and Mother_ID I have set the following criteria... Father_ID = [Forms]![frm_Students]![Father_ID] Or Mother_ID =...

Ahhh I see. Is there a way of returning a zero if there is no record ? Al

I tried this but it doesnt work... Absent_Days.Value = Nz([Absent_Days_Query]![SumOfQty_Half_Days],0) What is wrong with the syntax ?

The Primary Key for my Employee form is "Employee_ID" so as I go to the next record (next employee) the number of absent days updates for each employee. I obviously have a criteria filter in my query for Employee_ID So how would I Sum the total of just a particular Employee ID in a table ? I...

Hi, I have a query which results in a single total representing the number of days absent relating to an employee. I have embedded the query in my Employee form and I have managed to pass the Total number to a text box using this code. Absent_Days.Value =...

Ive kind of worked round it by putting a button on my form which opens the query but Im puzzled why I cant drag the query onto my form.

thanks lag. Ive since changed the code (which runs On Current) to... DoCmd.OpenQuery "Siblings_Query", acViewNormal, acReadOnly DoCmd.Requery DoCmd.OpenForm "frm_Pupils" ...and the query refreshes perfectly each time. However, I have created a sub form from my query and tried to...

What is wrong with this code ?? DoCmd.OpenQuery "Siblings_Query", acViewNormal, acReadOnly Me.Refresh 'Refresh the query DoCmd.OpenForm "frm_Pupils" Me.Refresh The query works fine when I open it manually and refresh it manually. Its pulling criteria from a control on a form...