Search results

Hi All, I have a report based upon a query, which returns data based upon a financial year. I have, in the query, included a month ranking from 1 to 12 to allow it to display July to June correctly in order, however, I have created a Chart Report and I am unable to get it to sort by the month...

Hi All, I have learnt VBA in access 2000, and am now working in a place which uses access 97. I am having some trouble in creating a new record, by memory all I used to have to do is; forms!frmMaster.recordset.addnew However, this does not seem to work within 97? Can someone point me in...

Hi All, I have created a very simple form for a progress meter when the database is making copies of databases (eight copies). I have put this in the form load event for the progress meter form, however it appears that the meter doesn't display till the end of the process (as it is working in...

Hi All, I am trying to figure out how to get a search form to select all records where the check box is false (or true) and am having some trouble. I have tried having all sorts of combinations; strWhere="Where Request.ReqComplete=False" strWhere="Where Request.ReqComplete=-1" However, am...

Hi All, I know this sounds familiar, however I have searched for about 4 hours and have picked up little pieces of info here and there. Here is my problem; I have a login screen which searchs a table for accepted users. From this it picks up the Name of the user and stores it in a UName...

Hi All, I have the following problem; I have an equipment management database which enables staff to book equipment etc. The database has seperate tables for like equipment, people, business unit etc. What I have currently is a query which shows existing bookings at that period of time...

Hi All, I have a list box linked to an SQL search. On certain items if searched returns blank rows, is there any code which can hide these blank rows so only ones with values are returned? Cheers & Beers rat_b76:(

Hi All, Just a quick thanks to all that respond to my queries, as this forum is fantastic. I have a question, I have a database which does some searching through sql. I have linked this to show the results in a List Box with matching returns based on the query. The problem I have found is...

Hi All, I am relatively new to the realms of VBA and am wanting to search a form for specific details. I understand the DoCmd.FindRecord function, however, it does not really suit my need as I need to be able to list a return of matching records and the user to select the one which is most...

Hi All, I have a table with one field called 'Comments' as a Memo. This area records specific details to a person, and I have had the request if this area could only be changed to allow additions to the comments are, however, does not allow the deletion of the existing data. Is this possible...

Hi All, Please forgive my ignorance if this is easy to answer. I have a query where it requests the [Start Date] and [End Date] of a specific field and obviously the dates in between are returned. As I have six other fields which are of the same type but hold different information on date of...