Recent content by satswid

  1. S

    Converting this Excel VBA code to Access VBA. A really challenging task

    Detailed Explanation: I had an Excel file which is imported into an Access table now. Now I want the same functionality, that was in the Excel file. The given subroutine was made in Excel VBA, hence it is using Cells() and Range() to refer to cells. However in Access tables, things are...
  2. S

    Converting this Excel VBA code to Access VBA. A really challenging task

    Hi guys, Earlier I had a excel file with many columns. I wrote a code in Excel VBA to fill up the last two columns according to the data in the other columns of the row. It worked fine. Now, the whole thing is transferred to an Access table. Pls help me convert this Excel VBA code to Access...
  3. S

    Simple query(but not for me)

    I did that however it gives output in the wrong manner The output must be: Values: 1 P -from Column1 1 O -from Column1 1 R -from Column1 1 T -from Column2 1 U -from Column2 1 G -from Column2 2 U -from Column1 2 E -from Column1 2 S -from Column1 2 E -from Column2 ... ... ...
  4. S

    Simple query(but not for me)

    Hi, Attached the db file. I have a table with 4 columns IDNO,Add1,Add2,LineNo Values are 1 P T 1 1 O U 2 1 R G 3 2 E E 4 2 S N 5 2 E G 6 3 L H 7 3 I A 8 3 S P 9 4 O I 10 4 L C 11 Output...
  5. S

    Back with a more challenging query

    No dudem I an not askin avt concatenation. But I am asking of Merging two columns, eg: Field1 Field2 a 1 b 2 c 3 Becomes: Field3 a b c 1 2 3
  6. S

    Back with a more challenging query

    The link Did not help. :( I simply need to change a report that is to add a field which is combination of two fields, one after the other, studentwise
  7. S

    Back with a more challenging query

    I have a table in the following manner Class| Student Name| Address_Eng| Address_Por| Percentage| Subject| Marks 1 st1 Tinsel Town Trerfmd 100 1 st1 XYZ Street XYZ Aerd 100 1 st1 Bldg ABCD Blefdg ABCD 100 1 st1 ---------- ------------ 100 2 st2 China Town China Retedaw 75 I have created a...
  8. S

    A challenging query on reports(atleast for me). Pls help

    Hi, I am very new to this forum as well as MS-Access. I am stuck at the very beginning.. Plz help This is my requirement I have a student table with these columns Roll No, Name, Class, Subject, Percentage I will create a form where user selects the class and then click "Generate Report". I...
  9. S

    Need help for form desgin

    Hey buddies, I am new to this forum as well as to MS-Access. I am using Access 2003 and I need to develop some forms and a report as my college assignment. I need to develop a login form, which appears after clicking a button at the main form and only after logging in succesfully, should the...
Back
Top Bottom