Search results

Hi guys, please bear with me as I am just new with access and I dont understand the comments or may maybe I have not told clearly what I really want for the db..... 1. the form shall be used only on creating new records so I am confused of why do I have to make it a combo box.... on this this...

I now remove the spaces in the field names, however I cant change the table lookups to avoid mis typing since I am not the only one who will use this database. I am new on Access . I just want that when I am creating a new record thru the form I want it that when I finished selecting the code...

Hi everyone, I have this table tblTeam with fileds namely staff no, staff name, code, role type, and gender... codes are assigned to different role type in another table and role types corresponds to a certain gender which was defined in another table.. Can you help me so that the field...

Thanks @MajP for the advice..

Thanks @MajP , I got confused at first ... I copied all the code and paste them on the "on click" event procedure and it was not working and blocked by an error message then I deleted the "Public Sub FilteReport()" at the top and the "End Sub" at the bottom and now it is working perfectly fine...

Thanks but I cant find the line of code to delete...... I tried do delete some code but it messed the process.... and what should I change so that the "Print Selected" button will work on succeeding searches

Thanks for the response... I tried the code, opened the form and try to search for "en" and this message pops up after I clicked "Ok" it brings me to the print preview of the search result after I close the print preview I tried to make another search and click the "Print Selected" button...

Thanks for the code...........my PK is the vesselname, I tried the code but on the print priview its just showing the selected record (1 record) instead of what the results on the search.

This is the sample of my database. Its fine with me if I cant format the column head of the text box.... I just want to be able to print the search result on the listbox when I click the "Print Selected" Control Button

I want the text of the column head to be bold and the text of the record remains normal As for the auto select of the 1st item on the list. I checked @oleronesoftwares attachment and its working but @MajP code is what I exactly need as I dont want to show the primary key on the list. In this...

Hi to everyone, I have a form (frmA) with a list box (ctrList) where records are taken from a query (qryA) and all fields on the query are taken from the main table (tblA) Please help me to do the following things as I am slowly trying to learn how work around MS Access and VB codes. 1. Want...

thanks guys, @Gasman 's code helps me to navigate my subform. :)(y)

thanks

I tried to set recordselectors of the subform to no but it was still showing

Hi Guys, @arnelgp , I tried the viewer and it works..... thanks for your help.....I am going to use this database on my office as my tool... I tried do same but I cant run the reg file as our IT have a strict policy on running this type of file.... so I end up with June7's suggestion. I knew...

how can I move and test them?

thanks

I have tried to cahnge the view property but theres no option for page preview only datbase view, split, continuous and single

Hi, I have this form with control buttons at subform where I want to show a set of records (just like a report) from a table in a pages (not in continuous form) where I am planning to navigate these pages the subform through the control button I put on the main form.... I tried to save a report...

Thanks my subform is now locked for editing, the subform was still in continuous form...how can I make the subform comes in pages? I am planning to add a control button on the main form to navigate the pages on the subform if I am able to break it.