Search results

It's a routine that is running from 'frmDirectory', which is supposed to open the 'frmStudents'. FYI: The 'frmStudents' is using a query called 'qryStudentVisit' (a combination of 3 tables). I can add/edit the contents in my 'frmStudents' form normally. I've also tried to create a new table...

Thanks for the reply! Yes, I see your point... but I have not opened anything up. I've tried to check this by closing the entire Access application, then open the .MDB file in question - and directly open up the 'frmDirectory' file. Not even the 'tblStudents'... I get the same error. Now...

Hi everyone, I'm having problems figuring out what to do... Background: I've got a form called 'frmDirectory' which has a directory of students, I would like to link this with my 'frmStudents' where I can then display and edit the fields. FYI: The 'frmStudents' is using a query called...

That did it! Thanks!! That was it!!! Thanks guys! I managed to turn off the scroll bars there too. :) Many thanks for your kind help and reply, Sab.

Yes, that's correct - it's found inside a subform; but I can't seem to find the right option to turn this thing off... I'll continue trying, but if anyone has a suggestion that would be great. Likewise, I'm trying to turn off the scroll bars which appear on the right side, which flip between a...

Hi guys, I'm sure this is easy to do, but I can't figure out where to find the name of this bar to search for it online or in the help... But how do I turn off this grey bar along the side? <picture included> Thanks for your help, Sab.

Can anyone please tell me why my form data is not updating? I thought I had it working before, and not it's not working. I must have touched something, and I can't think of what. Any help you can give me will be greatly helpful!!! Thanks again, Sab. Note: Please either 'Shift' + 'Open' the...

Thanks again for the confirmation on that! I believe I'm doing this correctly now in my database... However, I seem to be able to 'see' the fields of the query in my forms - but it appears that I cannot "Add" new data to it. Is that the limitation of extracting information from the query...

Thanks maxmangion!! As a newbie, I didn't even think of binding the forms to the queries... but now it works great. I still have one problem as I'm not certain if each of the combo-box should also refer to the query I created. All of them seem to work except one which points to "Mentor Name"...

Sorry for the newbie question but... I've got a form called 'frmStudent' which is linked to 'tblStudent'. I have designed it as a tabbed form, the first tab has "Student name", "Student Number", etc. The second tab is linked to visits by the student to a mentor (such as a tutor etc). Here...

Thanks! Thanks for the answer! Note for those who have wondered the same thing... I had converted and saved my db in Access 2003 as a "2003" version; and restarted. However this alone did not display or convert the buttons. The only way I could manage to display the buttons, were to create...

Hi everyone, This is perhaps a simple question for which I have not been able to find an answer to. I've been trying to create a form which contain command buttons, but the problem is that the look of these buttons are not similar to those found in Windows XP. I know it’s purely cosmetic...

Ah-ha! Of course!! I was so fixated in sorting the "A+" grades column I forgot about the numeric values (I had tunnel vision :rolleyes: ) Thanks for your help, Sab.

[RESOLVED] Sort Output... Hi again, I'm working on trying to get my Query output of school grades to sort in the following manner: A+,A,A-,B+,B,C+,C,D+,D,E,F,INC I'm having little luck in finding a way to sort the results of table "Old_Grade", column "Entered_Mark" in the above mentioned...

I appreciate the suggestion dcx693, Unfortunately this will not be a 'one-off thing'. I've got hundreds of these to do, and many to keep up from semester-to-semester and year-to-year. Oh I see what you're suggesting... I'll try to come up with a SQL code to do that. I'm only a newb so it may...

Thanks for your reply M8KWR, I've done as you suggested, but for some reason its not working out for me. I've even named my Tables in the same format as you have but still nothing... When I copy your code into my Queries window and run it, I first get a dialog stating 'Enter Parameter Value'...

Hi everyone! I'm new to SQL and Access, and I would like to ask your help: I've been asked to create some way (SQL script with formula) for me to use in order to 'read' and 'place' an equivalant numerical number to an alphabetical list. Here is an example: I'm creating a student report list...