Search results

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

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...

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...

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

Thank you so much Tess

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...

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

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?

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...

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

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

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

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...

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...

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...

Hello I would like to put up a navigation bar in all my forms, like-when i open any form, i should get the list of all forms in my dB and when i click on any form, the control should get transfered to any form.How can i implement this?anz suggestions pls.

Hello, the following is the procedure which I've written to open my db. Set db = OpenDatabase(Application.CurrentProject.Path + "\myproject.mdb", False, False) But,the database is getting locked and I am able to edit the forms and code before running this procedure.why is it happening? could...

Hello I want to control the size of my form depending on the monitor size.How should i do this?I dont want to see the record navigation bar at the bottom of the screen and minimize,expand and close buttons on the top right hand side of my form. Please help me.

Hello I am trying to display records in my list box from 3 tables using the following query. SELECT [Field1],[Field2] FROM Table1 UNION SELECT[Field1],NULL FROM Table2; UNION SELECT [Field1],NULL from Table3; I am able to list all the records in the list box from my tables. but, i want it to...

Hello llk, could you pls tell me how to do with a d-lookup function. This what i want to do actually. I have a table called risks with risk_id as a primary key field.There are so many fields in this table:risk_name and priority being among them.I have a form designed with a list box and 2...