Search results

Hi: I should find the position of a number in a sentence and later extracted. The number is attached always to an "E". ie: E1, E2, E3,E4. The range of the number is 1-4. I have this until now: X: InStr("E[#]",[Col1_Comment_1]) but it always return 0 Please, may you tell me where is the...

Hello to All: I am trying to filter a report using a form. The form has the following combo boxes (until now) to filter the report: txtSchool Year (ie: 2012-2013) numQuarter (ie: 1,2,3,4) txtStudent Name (ie: Doe, jane) Now, the search options include all the fields, one or more fields or...

Hi to All: Happy New Year! I guess somebody else have had this issue before. A report needs to be created for a school it should print like this: Student Name .............. Period 1. Period2 . Period3.. Period 4 Subject1 Gradeq1 Gradeq2 Gradeq3 Gradeq4...

Hi Everyone: I have reviewed many post about converting columns to rows and still does not get it. :banghead:As you might imaging, I am new using access. Please, need help. Here is what I would like to do: I have a table which want to normalize. Table Name: FlatFile This is the fields list...

Hi: My name is Maricruz, i am new programming with vba and have issues understanding the syntax of DoCmd.RunSQL Update. This is the line DoCmd.RunSQL ("UPDATE Guardians SET Guardians.Address = Address_Students WHERE Guardians.ID = Id;") :confused: id is a field in the form. When I...