Recent content by noaccessidea

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

Where do I set that, on the combo boxes? I am already using the width setting on the combo boxes. This is the form I am using, I don't want the header contents to be exported, just the detail. I noticed that I can set the header and contents to be Screen Only in the Display When setting but...

Sorry, I think I didn't explain clearly. I don't want the combo boxes to show as columns and they have ugly names and are duplicating values already included in the subform fields. In the attached image I just want the columns from CourseName onwards, the first 3 shouldn't be there.

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

Amazing, thank you very much. That works perfectly! Just need to figure out how to reset the filters correctly now.

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'm not sure what stacked forms are to be honest but I'll look it up to see if it would be better suited. I'm still pretty new to access and jumped into it quite suddenly. Thank you for mentioning this, it is something I meant to ask about. It is inconsistent and mostly by design/need as it is...

That's a good idea, it's hard to describe this stuff well. Should be attached now with data removed.

Thank you, really appreciate your reply. The tables/forms so far are relating to lectures and support workers being assigned to each so Available is all lectures where Support Worker is Null, All Lectures is everything. I have created different queries/forms for this but I realised that this...

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 just wanted to say thank you for all the responses to this, it has been an enormous help. I have had to scale down the scope of this project for now but it the tips here have given me a much better idea of how to do it when I revisit it.

It was probably just me not knowing what I was doing and not having the data structure correct. I found that I was getting IDs instead of values and having to create subqueries for both fields and hiding the ID which seemed a bit long winded. I suppose linking tables is doing the same thing...

Wow, thank you for all the amazing responses, I wasn't expecting so much help and insights. I will have a try tomorrow when I'm back at work and we'll see where we are. I think linked tables is the key thing I was looking for, it solves a lot of problems I was facing when trying to create forms...

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