Question In Need of big help!!!

[Nathan_M]

hi,

i am new to this forum, i am creating a student database which also has a section of it for staff, now, i have a number of problems.

1. on my student details form, i want to create a button which prints that particular record onto a report, however, when i do this, it prints off evrery single record onto a report.
2. i want to stop the 'enter perimeter value' message box from popping up as it is constantly interferring.
3. i want to create a section where each staff member can click on there name and got to a form called 'my hub' which is where they can view their details. on this one i have created to of these forms as i have split it up into the two offices.
4. i want to stop a form from coming up at startup as i allready have a startscreen for the startup.

i have been trying for weeks to do this and i am having no look, if i am am honest, it is only these problems plus a few more that is holding me back from completing the database ready for use.

i am no it wizard and so i only have a basic understanding of VB and Macros.

thanks.

i hope this can be solved quickly.

i would upload my database but unfortunatey it is not letting me so if you have a solution, please send me an email to me at:
n d m a r t i n 0 8 @ g m a i l . c o m
(without the spaces) and i will happily send it to you.

 

[John Big Booty]

Welcome to the forum.

You should be able to upload your DB if you follow the advise here.

 

[pr2-eugin]

Hello Nathan Welcome to AWF..

on my student details form, i want to create a button which prints that particular record onto a report, however, when i do this, it prints off evrery single record onto a report.

It depends on how the Query for the Report is designed, You have to double check the Query, change it according to your need.. Something along the lines of..

SELECT * FROM [COLOR=Blue]theStudentTable [/COLOR]

WHERE [COLOR=Blue]studentID[/COLOR] = Forms![COLOR=Blue]formName[/COLOR]![COLOR=Blue]controlName[/COLOR]

The above query will select the details of the ID the report is called from..

i want to stop the 'enter perimeter value' message box from popping up as it is constantly interferring.

Make sure all controls are properly named, spell checked, and also make sure that no controls on your form are named the same as in your report..

i want to create a section where each staff member can click on there name and got to a form called 'my hub' which is where they can view their details. on this one i have created to of these forms as i have split it up into the two offices.

Needs a bit more information !! Is the data split in two tables? If so how are they related?

i want to stop a form from coming up at startup as i allready have a startscreen for the startup.

See if you have any AutoExec macros that automatically open any forms.. Or see if there is any code behind the form that you have set to open, that opens this other "unwanted" form..

i hope this can be solved quickly.

It depends..

i would upload my database but unfortunatey it is not letting me

Follow this link to see "How to upload files"..

 

[pwbrown]

1: Would need to see your code for this, you probably didn't select the one record.
2: Again need to see you code I have no clue what it's doing but you must have asked for an input from the user.
3: DoCmd.OpenForm "your form name here"
4: method depends on your version of access eg. 2003, 2007...

 

[Nathan_M]

Thanks everyone for the reply.

now attatched is my database so you can see for yourself.

again, i am not that confident with VB.

 

[pwbrown]

What version of Access are you using? I can't open the database in A2007.

 

[Nathan_M]

hi,
thanks for the reply, i am using access 2010

 

[pwbrown]

hi,
thanks for the reply, i am using access 2010

Unless you upload a version compatible with Access 2007 I can't check the database. Someone else will help I'm sure.

 

[Nathan_M]

Unless you upload a version compatible with Access 2007 I can't check the database. Someone else will help I'm sure.

HI, Sorry but i am unable to change the compatibility of it. sorry

 

[jdoathout]

Nathan, you should be able to go to save as and save it as an access 2007 dbase and post it. I too use access 2007.

A few things I note that may help is maybe for your staff hub you could create Specific Switchboards? it is possible to use a login form to send the person to the switchboard. as far as the students (build a query that accesses an individual students info from your source then create an exact duplicate or the report with that query. That will limit the printing to that specific student.