Search results

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

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

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

Hi, I'm looking for some help on how I would go about doing the following: I have a query YearLink which links an primary key of a bird species table to the years they were seen so it looks like this: 1 2000 1 2001 1 2004 2 2000 2 2002 3 2000 4 2003 and so on. What I would like to do...

I'm trying to manipulate the size of a text box based on the masterfield. the code: RandomSubform.form![RandomField].Height = Number works perfectly for this, however, when I shrink the textbox, the 'Detail' field remains stretched. RandomSubform.form![Detail].Height = Number Does not...

Hi, Hoping someone can help with what I need to do to allow the following to work: I have a main formlinked to a subform, within the subform, I have a second subform. I am able to edit and add data in the main form, and the first subform. I am not able to edit or enter data into the second...

Hi, Currently have a database set up as follows: MainForm containing: Subform1 Subform2 OLE object (Spreadsheet file) Subform 1 is linked to MainForm via the field Year Subform2 is linked to Subform1 via a field in MainForm which shows the current record in Subform1 There is also an...

Hi, New to the site and hoping someone can help me with the following: I have created a form which contains 2 subforms. The 1st subform is linked to the main form and displays data in continuous form view. The second subform is unlinked. It shares several fields with the 1st subform but...