Search results

Hi, Bit of a long one but I require some advise if people can supply it. I've started creating a DB that is now getting out of hand due to me being inexperienced. The things I want to do now are getting way to complicated. From reading various posts I know that this is all being caused by my...

First of all thanks for the help. I have tried to use the code you suggested but all that happens is the list4 box losses the entire list and the information is not paassed over to list40. Thanks anyway though

Hi, I'm having a problem that is really making me want to pull my hair out. I'm also new to VB so please be gentle. Down to my problem. I have two list boxes . The first one (List4) gets it data from a query that runs after a refresh even after an update to a combo box (the different option...

Thanks for your help with this matter. I manged to sort it out with a list box and refresh comand.

No I don't I just have one table What I want to happen is, while reviewing a record for a staff member the form also shows the reference ID (primary Key) of all other records that maybe raised against that particular person. In essence what I want the form to do is, If the Staff ID (in...

Hi, I've got a simple database with a form which, has a sub form. The main form has a field called Staff ID. I want the sub form to be able to list all records with the same Staff ID as the one you are looking at. For example if the staff member had 5 records, when you looked at one them you...

Hi, I was wondering if you out their can give me advice. I have a company DB that I've been asked to create and I'm having problems with conditional formatting. I'm using access 95 so I'm having to do this with code I believe (if there is an easier way I'm all ears) Basically I have a report...

Hi All, I'm nothing more than a experinced user on access and I need some help. I've been asked to create a database for work which I have done so and it is all working fine. My problems is I have a Vaule list look up box on one of my forms with the vaules of Green Amber, Red and Risk closed...

Sorted I've just figured it out so no need to bother looking at this

Hi I'm a bit new to Access, however I created what I think is a fairly complex database and now preparing some reports. I want to have a drop down option for one report and from reading through these forum I know I need to link a form to the report and link the form to a query. The problem I...