Search results

Hello All. I am using the same form (form_x) to add new assignments and new tests. The form (form-x) gets invoked with two buttons (New Assignment – New Exam). In the form (form-x) I have a combo box by which I identify if the record is type Exam or Assignment. I am using the following code...

LOL......... I wish I could.......

Yes, ..... Yes....... Thank You :),,,,,, It works like a charm......I see the problem...... Thank you.

Thanks for your help........ I still need to do a lot of work on it but here it is....... from the initial list you can invoke the Add Student button and then you will get the form.....let me know if you have any question.

thanks for the reply....... It doesn't give me the error message, it adds the Student_ID to the Student table but it doesn't add it to Guardians table...... I have tried so many different variations on this, I think I ran into this before.....Don't quite undrestand why it doesn't add it the...

Data type in both tables are The error is :

Hello All…. I have two tables (Student, Guardians), well there are more but these two are involved in this SQL…. Student_ID is the linker between the two table (many to one – multiple guardians to a single student). I have a form(frm_Student_Add). My goal is once I add a student (capturing...

Thanks........

Hello All: I have two forms, A and B. Form A is detail info of students. From Form A I am opening Form B to Add assigned tests. Once I Save and close Form B, I like to Re-freash form A so the record that was just entered in Form B shows up in Form A subform. I am not sure under what event...

Thanks....... Been reading abt the Multivalue and how it works. interesting. seem to be an enigma between all developers and the community in general. I found it intreasting as to how Access keeps the values in it's system files and presents it graphically to the user. in any event, I had...

Yes you are right, I keep forgetting abt the reserve words.....I changed it to INSERT INTO Grades ( GUSD_Student_ID, C_S_ID, Type, Test_Date ) SELECT Students.GUSD_Student_ID, [Forms]![frm_Test_Add].[Subject_ID] AS S_S_ID, [Forms]![frm_Test_Add].[Type] AS Type...

OK... This is good start.... I have constructed this in the sql window of query design if I click the design icon to see what it did it gives me the error. INSERT INTO Grades(C_S_ID, GUSD_Student_ID, Type, Total_Score, Date) SELECT GUSD_Student_ID, Forms!frm_Test_Add.Type...

Thanks for the reply....... not being strong in coding I was thinking of the same thing, but still couldn't put it together, because the append needs to take all student's ID's and the same Test ID and append........ I also am not sure which is faster the code or query or it's the same..........

Hello All: I am trying to build an access applet for my wife who is a K5 teacher. I am fairly new to Access and like to think I have fairly reasonable understanding of the relational databases. I however am not a programmer. I am not done with the applet yet so please don't judge it as is, I...

Thank you both for your prompt help, I really do appreciate it...... CJ_London: Sorry for the confusion, but I thought if i have the database attached it would be evident, My mistake. I will be more careful in the future, please accept my apology...... plog: It totally makes sense, I see...

Hello All: This is very confusing:banghead:, maybe one of you guys can shed some light on this or give me a solution. I am trying to do a update query on a table. I have constructed a formula which is not working in an update query but it will work in a select query. I have the database...

Thanks Paul for your help , I do Appreciate it.....

I have tried Paul's Suggestion If Not rs.EOF Then MsgBox rs![Assets.Well_ID] Else MsgBox "No Record" End If What do you guys think,,,,,,, it works......

Hello Paul, Thanks for the reply. Wonderful it worked:p, had to change it a bit for some reason MsgBox rs![Assets].[Well_ID] and well_ID didn't work kept giving me Run-time error '3265' - item not found in this collection. So I tried MsgBox rs![Assets.Well_ID] and it worked. For some reason...

Fair enough: My assumption is that the sql string is returning one record, well one field from a record I guess. The MsgBox rs is the one causing the error 13 type Mismatch, but it could be the strSQL string also I can't tell. From your response I guess the issue could be in Set rs =...