Search results

I have read the FAQ at the Microsoft website, applied it to my database and it is secure at my home computer. However, when I take the database to work (to any different computer), none of the security features are present. What do I need to do to keep the security features with the database...

Yes! That did it. Thanks for seeing this through with me.

Same error I copied and pasted your code changes and they worked well. But when I try to add the student name to the code, I get a syntax error (missing operator). CurrentTerm = Me.Term StudName = Me.StudentName RecDetect = DLookup("[scrStudent]", "Attend", "[AttStudent] = " &...

StudName is a control on my form. Here is the project I am working on. I found the basic part on the forum and adjusted it to my needs. All I want is the student's name to be passed on (Insert Into) to the "Attend" table along with the other information (Date, type of absence, student number...

Thanks for the bit of code. This is actually a small part to a larger piece of code I am trying to adapt. The code below (I found on this forum) inserts the student number, date and attendance code when you click on a calandar. StrSQL = "INSERT INTO Attend ( AttStudent, AttDate, AttType...

Found my mistake... I need to use Paramaters to declare it is text. I am having some difficulty with how to type it in VBA. This gives me an error. StrSQL = "PARAMATERS [StudName:] Text ;" & "INSERT INTO Attend (StudentName) " & "SELECT " & StudName & ";" Thanks.

I cannot seem to get this portion of code to work: Dim StrSQL As String Dim StudName As String StudName = Me.StudentName StrSQL = "INSERT INTO Attend (StudentName) " & "SELECT " & StudName & ";" DoCmd.RunSQL StrSQL Where "StudentName" is the field name with data type "text" in the table...

My SQL is very, very limited (that is why I started in VB) so I have never heard of SWITCH. It looks simplier so I will give it a go. Thanks for all your help. Wait... Switch is a VB function. Is is also used in SQL? If I was to put this code into a report I don't think it would solve the...

Done! IIf([Percent]>=97,"A+",IIf([Percent]<97 And [Percent]>=93,"A",IIf([Percent]<93 And [Percent]>=90,"A-",IIf([Percent]<90 And [Percent]>=87,"B+",IIf([Percent]<87 And [Percent]>=83,"B",IIf([Percent]<83 And [Percent]>=80,"B-",IIf([Percent]<80 And [Percent]>=77,"C+",IIf([Percent]<77 And...

Probably. If that is the way to go then I can do it.

I have a report based on a query that calculates percentages for academic areas (Math, Science, English, etc.) for each term (1 to 4). The report then consists of 4 rows (1 for each term) and in each row is the corresponding percents for the academic areas. What I want is a text box next to...

When I tried that I got a bunch of pages with the first subquery and then a bunch of pages with the second subquery all together. I am sure I can put page breaks in , but I could not get the two subqueries to print on the same page with that student.

I have a report that has two subreports that are built upon seperate queries. I preview this report by selecting a student from a textbox and Access creates the student's "Progress Report." Both queries that the subreports are built on have their Student Name criteria set to the name that is...

I have an embedded media player on a form. I want to be able to pause the video and then click a command button that extracts the current position of the video into a text box. I have tried Me.VideoTime = Me.MediaPlayer1.Controls.currentPosition and Me.VideoTime =...

Success! With the second one! Grr, I cannot seem to find the rules anywhere for using quotes " or the ' with the dlookup function. Thanks!!

I have a table where I want to look up the reading grade for a student for a specific term. I have a form where I select the student, then a command button to generate the report. The code below is not generating the correct name. =DLookUp("[ReadingGrade]","ReportCard","[Name] =' " &...

I have created an elementary gradebook for my school district. After a teacher enters students grades, they want to be able to e-mail progress reports home to parents using Snapshot. Is there a slick way (VB or other) of completing the following: 1. Generate the report based on the first...

Yes! How clever! Thanks.

Can I somehow name a text box by using an array? For example is there a way to name the text box "textbox(1)" and then when I am programming, refer to the text box by n = 1 Me.textbox(n) = 50 and then the value of textbox(1) will be 50? My experience so far is that names of controls are...

Thanks That should get me started!