Search results

Argghh.. I can't get this to work! I have a list box based on a query. The query is based on tblSolutionPartner which has partnerID, PartnerName,Expertise, additionalexpertise1,additionalexpertise2,additionalexpertise3. The Four Expertise fields are lookups from tblSolutionMainCategory. The...

I have two really simple tables which both have a field called BP which are both number long integral fields. I simply wanted to create a query that looked at tblBPWithShipToPrimary and linked the BP To the table tblZDEL and then provided me a list of matching BP numbers from TBLZDEL. Really...

Okay I know i've been incredibily stupid and made a tremendous mistake but what i need is the best solution to the problem i have right now... I have a database its msaccess with SQL Tables at the moment. There were an expected 40 wireless users expected but after horrendous crash on day one and...

I have created my own menus to navigate round the database. However I'm a little stuck as different user groups can only have access to certain menus.. Is it possible that you can hide menus dependant on the user logged in the database. I.e. Leadership get full menus General Staff only get...

Is this possible I want to have a msgbox pop up and dependant on the value entered it will open a particular report. So for example if they type in EN then it will run the English Timetable Report and if they entered MA it would run the MA Timetable. Now I know I can use the If statement to get...

I have a field on my report =Sum([Achieved])/Count([Surname])*100 & "%" with decimal place at 2 and format at Percent. This works fine except that it doesnt round to 2 and instead gives the percentage like 46.666666666667% I tried to run it without % added at the end of the formula but it...

Please can someone help me after keying in all the programming to get the buttons to become visible as I need them, it is now coming up with an error that the procedure is too large! Is there anyway at all of simplifying my code. basically on selection from the combo box three text boxes and a...

right, struggling here. Basically I have continuous form listing all the standard letters sent out when I double click on a letter, I need to to run a query for me. The code I have put behind the button is: If ([StandardLetterType] = "Homework") Then DoCmd.OpenQuery ("qryHomeworkClearMailMerge")...

Can anyone see what I've done wrong here? I cant get it to work and been over it a thousand times :( If ([Present%] >= 97) Then FrmWiseUpGold.Visible = True FrmWiseUpBronze.Visible = False FrmWiseUpRed.Visible = False FrmWiseUpPurple.Visible = False FrmWiseUpSilver.Visible = False Else If...

Right, I knew this day would arrive and have somewhat been dreading it but excited by the idea of a new development at the same time. We have a database within the school on our server that staff would like to be able to access at home through the internet. They will need to be able to view...

right I have a subform which holds assessment data it is a tab-control form which monthly assessment data each tab has its own form i.e. "frmCurrentAssessment-October2005", "frmCurrentAssessment-November2005" and they are based on their own queries i.e. "qryCurrentAssessment-November2005". It...

right I have searched and searched the forum but obviously this isnt as simple as I thought it would be! I have a main form called "frmAllStudents" based on a query called "qryAllStudentsMainScreen". The unique field in all forms is Admission Number. I have on this form a data-entry subform...

I have a form with a subform attached. on the Main form you select the student then you enter letters sent out in the subform. Basically there may be 22 letters going out all the same just to different students. so the standard letter type will always be the same as will the date field I know...

I have a form with a subform which has a listbox on it which lists all the letters sent home to a student. However despite the subform being linked by admission Number the list box is showing all records and not just the ones associated with the student. I know this is going to be really...

I have a form which has a listbox listing all the letters a student has had sent home. Basically i want to be able to click on a letter in the list box and for a popup form to open with the record details. However it just brings up a blank record. The list box has a unique field called...

I have a subform that I want to automatically go to a new record but I dont want a data entry screen as they need the previous as well. I've tried putting DoCmd.GoToRecord , , acNewRec on the form open command that doesnt work.. tried it on the onload().. I thought this was going to be really...

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

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