Recent content by Trystyn

Have tried the first 2 with no joy, hoping not to have to resort to the last if theres an obvious solution.

Thanks for the prompt reply. To answer your questions: 1) It is a different version now, although back when the problem first occured, it wasn't. I had hoped that work updating their version of Access may fix the problem. 2) Non-split 3) Nothing in OnCurrent 4) Yes but why would this affect...

Getting very frustrated that I have a database working fine on my home computer but crashing at work. I have a Mainform, and within it, Subform1 and Subform2. I have linked Subform1 and Subform2 by way of a textbox called Link, linked to a Field in Subform1. I have used this method many times...

Resolved Me.SubformCountry.Form.Filter = "[MinOfYear]<= " & Chr(34) & Forms![Countries by Year].[Year] & Chr(34) Me.[SubformCountry].Form.FilterOn = True

Given this some more thought and I am maybe making a mountain out of a molehill. I think what I need to do is apply a filter to [MinOfYear] in the subform where it has a value <= [CurrentYear] in the main form. Hopefully this is possible with some code in VBA? Thanks

Hi, I am trying to create a database showing a history of my personal travel which expands as the years progress. As such, I have a main form which scrolls through the field [CurrentYear]. I have a table which links the countries [Country] I've visited to the years [Year] I went, and a query...

Sorry for the delay in posting, this has had to take a back seat for a while. I have taken your advice, the DB is not quite everything I'd envisaged from the outset as doing it this way, I have to input each new training procedure for each employee to build the data.

Been back on this again and hopefully with the images attached I can explain a little better. Title to procedure.jpg shows a working query where I can update which procedures are required for which job titles. Similarly, employee to title.jpg shows the query where I am able to give each...

Thanks for your response. The three tables listed are to my mind the raw data. I have stated just below this that there is a link table LinkTitleToProcedure. In order to make this work I had to change the primary key of the TrainingProcedures table from the ProcedureID autonumber, to the field...

I haven't created a database for a long time and perhaps the reason for this problem is very obvious and easy but I am struggling to get my head around why one of my queries is working as intended and the other isn't. I have essentially 3 tables: 1) EmployeeList, with fields: EmployeeID...

I will give this a shot when I get a bit of time. I have managed to get around the problem last night by using an update query. This copies the values obtained from your original code back into the manual entry field of my table when I exit my input form. As a result I can leave the form and...

Ok So previously, I was manually inputing the Yes/No column. Now using your SQL code, I query this column for the yes/no dependent on whether it's the earliest year. The list of birds is linked to the highlighted year field in the main form and switching from one year to the next now takes a...

Sorry, I adopted EarliestYear from your own code above. This tells me for any given year in the form whether the species seen was a 1st in that year. It all runs perfectly except for the speed, it requeries each time I jump from one record to the next.

Further to this, I have a form which views all the birds seen in any given year. Master field Year, child BirdYear. When I load the form or flick between records, the requery is taking a great deal of time. Is there anything I can use to prevent this? My thoughts were to try copying the...

Thank you, thats brilliant. Nailed it in one.