Search results

Hi everyone, I need to delete a record by the command button. I used the wizrd to make the command button, but it deletes the record sometimes and sometimes it doesnt. Can anyone tell me what do i do to delete a record? here is the code prosuced byt the wizrd: Private Sub cmdDelete_Click() On...

hi everyone... I have a simple problem...but i am not able to solve it... I have two comboboxes and i want to filter the second combobox based on the selection in the first combobox. its like this: 1st combo: cboGroup 2nd combo : cboSubGroup I have written the code like this Private Sub...

Hi everyone, I am trying to print labels based on the selection from a listbox in a form. It works great just that the labels are not aligned properly. They get aligned anyhow on the page. Can anyone tell me how to align the labels next to one another? Thanks for ur help ! dB

Hi everyone, I have a form where i select some items on the first form and depending on the items, i want to open another form, where i get to choose the fields to be seen on the labels...then when i click on preview on the 2nd form,i will get to see the chosen fields for the chosen...

Hi everyone, I am having trouble with some coding since a long time. I have 2 listbxes and i select a place name from one list bx and transfer it to another listbox. The i click a cd button to open a report. I want to view only the records for those names which are present in the 2nd...

HI everyone, I have a database in which i have one person and each person can belong to more than one place. Now i have a form on which i select the places and then run a report based on the chosen places. Since i have one person and multiple places, i am getting multiple labels for one...

Hi everyone.. this is really urgent... I need help here.. I have atatched a smaple dB and have written code for the same,but its not working...i amnot able to see what is going wrong. Pleaseee help ! go to forms- frmListBoxes- select "ARUP" from 1stlistbox and click Moveselected-- then click...

Hi everyone, I have attached a smaple db with this message. In the forms, there is a form frmListboxes. When you open it, click on ARUP in the left listbox ..then click moveselected...and then click on the Choose fields command button. It opens a report whhich shows all the records...How do i...

Hi everyone, I have 2 listboxs on my form. In one listbox there are names of groups( group is a field in my table) and the other listbox is blank. When i select the names in the first listbox and press the button "Move selected", the selected name go in to the 2nd listbox. PROBLEM: I want to...

Hi everyone.... I am trying to design a form in which i have a listbox with suppose 5 number of groups listed in it. What i would like to do is that when a user clicks on any group or groups, the names are transfereed in another listbox. When the user is done selecting the groups, he clicks on...

Combo box for prompt box Hi everyone, I want to have a combobox instaed of a textbox on the prompt box where you have to enter data. Is it in any way possible??????? Any help is really appreciated. Thanks dB

Hi evryone, I have a form on which i have tabcntl. In my dB i have info about ppl and every perosn can belogn to one or more group. Now i need to have a cmd button which will ask me the group name and then when i enter a group, it will open one page of the tabcntl . Can anyone tell me how to...

Hi ... does anyone know how to make a word in bold in access report? and italic too?? thanks dB

Hi everyone, Can anyone help me with grouping data in mail merge in word? I have been trying to group data in word... I have data like this First name:Tom C Topics: A B C D I have a qry in access, Select FirstName, Topics from tblInfo. This qry gives me the FirstName "Tom" 4 times since...

Hi everyone, I need help here ! I have a combo box and i want to select any value from its drop down box so as to use them as fields in my label report. ie. I have a combo box with values in the drop down box as: First Name Last name Home addr Clinic Addr Department addr I want to make a...

Hi everyone, I have a basic problem... I am preparing labels which contain first name, lastname and address. On the report design sheet, I have a textbox which says =Trim([FirstName] & " " & [LastName]) it gives an error here. Can anyone tell me what wrong that i am doin ? thanks dB

Hello everyone ! I am designing a form on which I have a combo box with values yes/no and depeneding on whetehr it is ye or no, the textbox gets enabled. If the combobox value is yes, the textbox is enabled and if no, then it is not. For the combo box i have written this code in the onchange...

greetings everyone, I am writing some text in the footer section of the field which I have grouped on : name_id footer. When i preview the report, It shows a blank page after the detail section and then on the next page it shows the footer... Can anyone help me please? Thanks

Hi everyone... I need help with a query which i need to make for a report. I am making a report where I need to have first name, last name and the topics assigned to a person. I have two tables 1) info with fields name_id ,first name and last name 2) Topics with fields Name_id,Topic_index...

Greetings Everyone.... I am making a report where I need to have first name, last name and the topics assigned to a person. I have two tables 1) info with fields name_id ,first name and last name 2) Topics with fields Name_id,Topic_index, Topic_id ,MainTopic and SubTopic Each person can...