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

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 I have a list box displaying some records when I open a form.when i click on a record,the record is displayed in a text box on the same form.so far it is done.Now,based on the record which I selected in the list box it has to search in my table and fetch some more records which corresponds...

when i was designing a report using report wizard, i selected 1 table and chosen the fields and also i selected other tables in the second step and chosen some more fields.but, when i see the properties in the design view, i could see only the fields from the table which i selected first. how...

Hello I have a combox box which lists(TOP25, TOP15, TOP10 and TOP5)in a form .when i select TOP10, and click on view the report, i should get the reocrds associated with TOP10.similarly it should hold the same with the other selection. I have a designed a report and i am able to view the...

Hello I need to have a navigation bar in my forms. For example: when we click on favourites(tool bar) in internet explorer, we get all the list of favourites stored on the left side of the screen and from there we can connect to our favourite webpage.I need to have such system implemented in...

hello I need to create a menu bar like which we have normally in MS-office. for example, we have file,edit,view and so on in MS-ACCESS menu bar. I need such sort of bar on my form.when i open my form i should be able to see such sort of menu.could some body help me how to create this. Thank you