Recent content by am_sarath

  1. A

    query explanation

    hello, could somebody please tell me what exactly the following lines of code is doing? Set rsValidate = projectdb.OpenRecordset("Select * from raw_risks where cluster_id=" & lst_clust.Value & " and raw_risk_description Like '" & txt_raw_risk & "'") If rsValidate.EOF Then ----------- thank you
  2. A

    something really easy, but how:-/

    Hello I have a group header in my report with two fields in it (Ex: Somename and Priority). In my detail section I have some 4 fields(Ex: Action, person, state and Date) Now, for each somename i can have many actions.My problem, i want to make the report view looking good.I want to insert a...
  3. A

    Each record in a new page

    Hello, I want to print the records, one in each page. Let us assume, person, address,city, and so on are in the report layout.In my db i have some 10 records. when i would like to print the report, only one person and his details should be printed on one page and the 2nd person in a new page...
  4. A

    page width

    Hello My reports are too wide for A4.can some body pls tell me how we can set a report width for an A4 size.Should we just check on trial or do we have any width fixed for different sizes of the paper. Thank you
  5. A

    code explanation

    Thank you so much Tess
  6. A

    code explanation

    Hi Tess, This is the code which i need some explanation.It would be kind of you if you can explain me in the same way you did before.Thanks! Private Sub lockall() Dim c As Control For Each c In Form If TypeOf c Is TextBox Then If c.Name <> "goal_value" Then...
  7. A

    form layout

    hi marina it helped me to some extent.but, it even prints the main access window. i just only want the form alone(not in the design view). Do you have any idea? Thank you
  8. A

    code explanation

    wow! TESS, thanks for your help, it helped me a lot. I got few more examples, i am not sure if you can help me in the same way as you did now. can i post it?
  9. A

    code explanation

    Hello, could some body please explain me the following code, like what all the queries or functions used.Your help would be highly appreciated, this would be really useful for me. Many thanks. ------------------------------------ Private Sub cmdSave_Click() Dim rs As Recordset Dim rs1 As...
  10. A

    form layout

    hello, How can one copy the form layout on to a word document? Thanks
  11. A

    update

    Hello i would like to update the records in two tables simulatanously.Like, i am able to select records into 2 tables using join.But, how should i do incase of update.I want to do it with only 2 tables. Thanks in advance
  12. A

    Report - Landscape View

    Hello How should i make a report to view in a landscape? Thank you
  13. A

    Report layout

    Hello I want to insert a table like view in my report.I've have 4 fields in my report and they are of different length.I made my text boxes shrink and grow.Now, After each record, i should have a horizonatal line and after each column i should also have a line.I tried with inserting a line, but...
  14. A

    List box

    Hello could some give me the code for the following: I have a text box(txt1) and a command button(cmd1) and a list box(lst1) in a form. After entering the text and click cmd1, i store the text in my table(tbl1)and at the same time, i've to display the text in my listbox(lst1). Please give me...
  15. A

    Combo box

    hello I have a combo box which displays all the available forms in my db.Now,i want to display ONLY SELECTED FORMS.How should i modify my code, pls help me. Private Sub cmbForms_AfterUpdate() Dim strForm As String If Me.CmbForms <> "" Then strForm = Me.Form.Name DoCmd.OpenForm Me.CmbForms...
See more
Top Bottom