Search results

Hi Firstly, sorry if this is already answered elsewhere in this forum, I've searched for a couple of nights and can't find the answer (how do you search when some words are disallowed?). Anyway, the real question: We use Access 2003 at work and I design/modify our database using Access 2007 at...

Hi all I have a database containing information about students. On one of my forms the user selects a course number and student name and then a subform (based on a select query) displays other information about the trainee. Instructor comments etc. At the moment whenever someone scrolls down...

Hi, is it possible to have an image go across or over the border in a report? Eg, can it go over the Report Header/Page Header boundary? I'm trying to make my report look "smart" and every time I drag the image over the boundary it automatically moves up, forcing extra space into the Report...

Hi I have made a report based on a query that looks at student results. I'm trying to display a photo of the individual student in the Student Header that corresponds to the records being displayed. I have tried two different approaches with code in two different locations and receive...

Hi all I have an expression in a query which is checking a list box on a form. If the list box is empty (is null), then I would like the query to search on the highest (maximum) value in the specified field (CourseFK), otherwise it will look for the value in the list box. Expr1...

Not quite sure where to put this one, as I don't know if it is a query issue, coding, or just form design? I have attached a cut down copy of my database and the problem lies with when I try to update a date field in the subform. To replicate the error, open the mainform, choose "Daily" &...

I am going around in circles. I am trying to design a database to submit for an assignment but it is driving me mad! I am not sure if the problem is with my actual database structure (eg the relationships) or the way I am trying to use the forms? What I am trying to do is have a main form with...

Can someone please decipher the following error that I have received while designing my database: "The LinkMasterFields property setting has produced this error: 'The object doesn't contain the Automation object 'Tbl_Faults.'' I get two choices, click 'Ok' or 'Help'. When I click on help I...

Hi there. I've been racking my brains the last few days trying to figure out how to hide a subform based on the results of a query. It seems I don't know as much as I thought I did! Essentially I have a main form with several checkboxes, a single button that runs the query, and the subform to...

Hi, I'm probably overlooking something real simple, but it's been a while since I played with access. I have a form (frmInputData) based on a table (tblStudComments), which contains comments about student performance. The form also contains combo boxes, the second combo box list is based on the...