Search results

form opens fine with DoCmd.OpenForm "frmstudentperformancepoorprevious"

i've tried that but it just says the operation was cancelled DoCmd.OpenForm "frmstudentperformancepoorprevious", , , "[popUPID] = '" & Me.StudentPerformanceID & "'"

I am trying to open a second form that is linked to the first form but i cant get it to work it keeps coming up with a syntex error DoCmd.OpenForm "frmstudentperformancepoorprevious", , , popUPID = '" & Me.StudentPerformanceID & "'" Any ideas?? trying everything to get this form to link and...

Possibily! Quite possibily that is my problem! Sometimes its so Obvious I miss it completely!

I have a form which holds all the student information on a subform called 'frmstandardletters2' I have a combo box with different letters that are sent home i.e. truancy, uniform, behaviour etc. On selecting say the uniform letter a pop up box for the uniform options appears. The code on the on...

Hi I was wondering if anyone could shed any light on this problem. I have a new database going live in two weeks. My problem is that I keep getting a message telling me that someone else is editing the record.. which is an impossibility as it is a stand-alone copy on my hard-drive at home! How...

I have been desperately trying to link pop up forms to the main form with no success.. I have tried the examples but it still isnt working.. is it because all the forms are based on the same table? I really want the ID Field and the Admission field carried over to the pop up forms... but at the...

SendObject Although for a couple days it worked now it is back not working :( I took the suggestion above and re-did the buttons with the coding... but now either which way I do it the button stops working after the first click

everything ok Just found out that its a microsoft fault to fix the problem you have to remove some characters from the message.. Alternatively there are various ways of fixing this problem SendObject Method Fails in Access 2000

I have a form with email addresses on to forward a report to a particular person. Code is below Private Sub cmdMail7_Click() On Error GoTo Err_cmdMail7_Click Dim stDocName As String stDocName = "rptConsPrint" DoCmd.SendObject acReport, stDocName, acFormatSNP...

This is my first time doing this so bear with me, i have tried a couple examples in the database but keep getting stuck at the same point (my VB is not the best) I want to run student reports for students selected through the list box, on highlighting them it puts their Admission Number into a...

thanks will take a look at it.... thought it was going to be easy :( got the form all ready, stupidly thought i'd be able to load the other form behind it without too much of a problem! I should have learnt by now Not a Problem = Big Problem!

I have a form with a man that does carwheels across the form with the message please wait, i have been trying to get this to run while my other form loads and cant get it to work :( either the please wait screen freezes and doesnt do anything till the other screen has loaded... or I have to load...

ooops I am so embarressed =IIf([Excluded For] Like "*arson*",Yes,No) Obviously time to go home!

I have a check box that has the following code in the control source =IIf([Excluded For]="Arson",Yes,No) this works fine... but it could be Excluded for Arson and defiance this wont be picked up so I need to alter it with Like but it wont work :( =IIf([Excluded For]= Like"*Arson*",Yes,No)...

Puzzled.... I put this code into the frmOffRoleContact form in the before Insert of the form but it hasnt done anything? Its still using a 0 instead of the ID number from the frmOffRole. Me.ID = Forms!frmOffRole!ID

I have a database with students off role.. and the contact we have had with these students... frmOffRole has the Students in with a button called add contact which on clicking brings up a seperate form called frmoffrolecontact which should link the admission number so when you close the...

:confused: right this is a little difficult to explain but basically what I have is a form where you select the class and then the module and then the students enrolled in the class are llisted in a subdatasheet with an attainment column next to it... on occasions there maybe 125 Students who...

I am creating a nightmare of an assessment database and the leadership group at work's latest request has had me a little worried and so I am seeking some advice on how best to achieve it. The assessment database as such isnt the problem but what they want is for everyone to have a copy of the...

I have two tables tblAutomaticSchedular holds all the timetable information and tblrooms holds all the rooms we have in the school I have created a query called qryroom which narrows tblAutomaticSchedular down to a particular time and day... using [Which Day?] and [What time?] in the query...