Search results

If I export this form to Excel I get different field names depending on whether I am in form view or datasheet view. One in particular is 'DayofWeek_ID', this is listed as 'Day' on the form and in the original query it is pulling the data from. The order of the fields is also different in the...

I have a form which has a few combo boxes at the top and then a subform which gets filtered by the combo boxes. I need to frequently apply a filter and export the results to excel so I have created a button to export to excel, which have discovered can be done in a number of ways, but every way...

I'm having some trouble with this. I'm trying to set up a couple of combo boxes to filter a datasheet. I have one working but the other two do not and I can't see why. I have attached database with some sample data in, could someone take a look and let me know what I am doing wrong? Also, how...

I am currently using a Navigation Control to switch between a few different forms but I have just learned about the Navigation Where Clause and now realise that I have created a whole load of unnecessary queries and forms. The issue I have now is that I don't know how to set this up so that I...

I need to import a large file of student data in to a database so I have started to set up the structure but things aren't working as I hoped. I have split most fields in to different tables and added an ID field to link them. However, I'm really confused about how I import my data in to this...