Recent content by jonobugs

Okay, I see. Well, I guess I'll just have to change my query that I use to load the form to change it back to the old filter otherwise it shows an error. Thanks!

I have a student database (Access 2007) and on the student information form I have it filtered so that only the active students are shown. The filter is on the "Data" tab on the property sheet. Although I could filter this out on a query, I do it this way because I sometimes want to have...

I think I may have solved it. I created two subReport queries and then filtered out the results by year. I then just placed each subReport in separate columns and that seems to work.

I'm trying to create a report that contains data from a table but I want to include different records for the same userID. I created a subreport to display some marks, linked the userID fields and it seems to work, but I also want to be able to format it in a specific way as it creates a long...

Okay, got it!

Thanks. Someone else pointed me to using Wordpress, so I may check that out as well. I won't be able to use Access for the obvious reason that most of my students won't have access to the database. I was hoping to make something that they could log onto from a website.

Great! I'll give this a shot on Monday when I go in. I'm thinking about making a separate and simple database for the students to log in, so hopefully I won't need something 'commercial'.

Thanks for the information. Although I spent a lot of time learning Access, it's an old version (2007) and I'm starting to think that I need to simplify my database to put something online that people can log on to with a web browser. There are far too many students who are using smart phones...

I'm not even sure where to begin with this question, but I would really like to know what's involved i. creating an online database. Details: I already created an Access Student Database which works well (for the most part) but know I've been asked to create a database which can be accessed...

Thanks for the information. I guess I need to put a bit more thought when I'm making a table. I suppose not all tables need to have an automatic generated PK! Thanks again for helping me. Your advice was greatly appreciated. Jonathan

Wow, that worked like a charm Colin! I guess I need to think a tiny bit more when I make these tables! For future information, is it possible to explain a bit more why the query wasn't editable? I now know it has something to do with the PK, but I guess I just don't know enough about the...

Hi Colin, I suppose I could do that, but it will take a bit because I would need to remove the data. I'm not so sure it would work very well without any data though. I don't think I found the answer, but I read that I could change the recordset type to "Dynaset (inconsistent updates)". That...

Hi Colin, I read the page that you recommended which was helpful understanding some things, but as far as I know, my read only query has not been caused by the reasons listed. I changed the query properties to Unique Records = Yes, and I added the Student Table, which properly links the two...

Thanks again. I'll give that a try tomorrow. It's late here and I'm off to bed.

Thanks for taking a look at my problem, Ridders. I'm not sure what reasons will cause a query which will allow editing or not. Anyway, I took a snapshot of the query I created which does not allow editing. It does however, show me the results that I want. It's a bit strange, but I can view...