Search results

Hi all, I'm having problems with the kill comand. Basically wanting VB to provide an archive function for a folder when some on a access DB says the records is closed. My basic code is below. I keep on getting file not found error at the kill comand. Can anyone explain what I'm doing wrong...

Hi, I'm really want to discuss datbase design. I am creating a new database and I need help with the basic design. I'm trying to creat a databse that profiles the access people need to do a specfic function. Basically in my head the DB would be something like Table 1 - Function Details -->...

Hi, I've looked thought the forums to see if I can get help with this but no luck so far. Basically I have got some code that will take data from a word form although it wont run even though it appears correct. From what I can see I presume I didn't have the correct references enabled, but...

Hi, Any assistance someone can give me with this append querry issue is appreciated. I have a table called tblRoleAssignments that has three fields RoleAssignmentID (PK), RoleprofileID & ApplicationrightID. It looks something like this. RoleAssignmentID, RoleprofileID, ApplicationrightID 58...

Hopefully an easy one for someone. I have a report that is grouped by a column called RAG status (Red, Amber, Green) to reflect the status of the respective issue. I now have a status report that I run and wish to order the report so Red issues are at the top followed by Amber and finally...

Hi, I'm at my wits end on this one and any help you can give is appreciated. I'm creating a Role profiling DB for my work. While making several access DB before this is by far the toughest one I've done. I'm now stuck at this stage for what seams like months (see my previous posts). I have...

Hi All, I was wondering if a kind sole out there can help me or give me some advice. I'm creating a DB (I have attached a simple copy) but I'm having real problems with it. On the Roleprofileform I want to give the users the ability to choose what applications they need. I've done this by...

Hi, First of all thanks to everyone who has answered my questions already, although I'm still having problems (more with my understanding and lack of Knowledge) I'm creating a DB and I'm stuck, I'm trying to create a form that has three fields mailbox, applications & Drives. Each of these...

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...

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...

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...

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...