Recent content by jirrah

Thanks for reply, and yes please if you can help me, as the two things you mentioned i.e control the record source of an object from anther object/form is new to me... please note that i am using listbox rather combobox

still waiting for any suggestions,...........

i have two tables, tblgroups and tblrecipes on a frmReview i am displaying the groups in a list box so that user selects a group and sees relevant recipes ( which i am displaying in a subform after quering from lstgroups). Default value for lstgroups is "[lstGroups].[ItemData](0)" so that it...

thanks for help, i managed to get it work, thanks all

thanks, but would appreciate if you can explain in a bit simple way, an example would certainly help

i have about 600 records in my database, with autonumber field. the records have been written, edited, deleted. the problem is when i display the autonumber it doesn't match the number in the navigation button, aslo it changes when i use filters. e.g autonumber is showing 569 but the bottom...

yes your point taken and am going to change it now, regarding autonumber i have also some problems (if i can post here), i have many deleted record so the number displayed is not actually the record number, (by the way what is the number shown in between navigation buttons known as), i am...

Thanks John, it worked Actually I am new to this, and vb part of access still I'm struggling (any tutorial suggestion will be great help). Also can i turn off the navigation buttons by putting some code in same place, so the form opens without the default navigation buttons. Regarding the field...

hello i have datasheet display on which double click event i added following Private Sub Name_DblClick(Cancel As Integer) Dim frmMyForm As Form Dim stDocName As String Dim rs As Object, strCriteria As String stDocName = "frmEnterRecipes" strCriteria = "[Name]=" & "'" &...

hi i'm sure this will not be a new problem, but i need help as i'm not that expert, yet. i have made a database for my wife to enter her recipes. two main tables, one containing details and other categories. i have made a form which shows selected recipes depending on categories from combo box...

great, thanks, woderful tutorial, worked perfectly

need help., have a form, have put a combo box to display values from another table, works ok, but when a type a new value, it displays 'not in list', so how to add the value to the table without opening the other table or any other suggestion, should i select values in combo box from a query...

i have a relatively larger access database, which takes some time to load... i wonder if it is possible to make some sort of preloader, display some image or splash screen for the time it takes to load.... or some other solution... any suggestion?? thanks

hi i have form which a list box (displaying category of recipe) and a subform which display recipe name depending opon category in listbox, working fine, but each time i open the form it automatically select one same category and display relevant record, how to make it display all the record or...

i dont know it is possible or not, may be thought only, any wizard software which can convert full access database to vb6 code to use in vb6..... hmmm