Recent content by AJ IT Student

hiya.. prob my last post on the project i'm doing.. but just to finish it off (I'm just finalising the last report!!), I'm trying to do a nice IF query. Its simple logic.. basically its a textbox, and depending on the value of the variable 'Performance' I'd it to say different things. IF...

done it! gracias senor!

Mile.. sounds right! Jon - tried C:/ and C:\

Hi all. I'm trying to create a few reports.. I'm having trouble with a specific one, however. I have a table called OfficeLocation, and a table called Employees. Each employee is assigned to an OfficeLocation via the LocationID. so in 'Employees' there is a column called LocationID with...

Hi All... I've tried to create a link to launch a user manual from access. I did this via a macro with the RunApp command.. I just put in: C:/personnel manager/usermanual.doc This is the right location.. yet it doesn't work. I've tried looking in help but didn't think it was very clear. Any...

The LAST thing that needs fixing is the EMERGENCYCONTACT form!!

Don't be silly! Names - even I can manage to change those! :p I'm very grateful for your effort. That's exactly what I wanted. Merci Beacoup!! aj

ahhhhhhhh! I'm still getting an error. I've tried everything. =DCount("[ManagerID]","Location","[LocationID] = " & [LocationIDtext]) LocationIDtext is my textbox which contains the LocationID. Its quite strange cos the query I actually want is LocationID = LocationID. But the first one is a...

Thanks for the reply. I would like to be notified when a value is entered into the form. For example: if the guy has 25 days of holiday a year.. and he puts in 25 days used - it would come up with a box saying - "all holiday used up" - and disable the field? Also - if he tried to say he's...

Mile - thanks! I have read about the function and yes it is the appropriate one. However I'm an error :rolleyes: My code is: =DCount("[ManagerID]","Location","[LocationID] = '1'") it says: #error in the box ManagerID is the field I want to count. Location is the table name.. and I...

Brad - that was absolutely perfect. Thank you very much! Sick day? unfortunately not! Next best thing - work from home! :P :P

guys.. thanks for all your help. Some of the points you raised are very true also. I'll post my application after its been marked and someone may want to further develop (hmmm!! not exactly a great starting point!) or another beginner may find it of some use! I solved most of my problems I...

Ok, sorry to post another question - i'm sure you're sick of me. Anyhow I'm gonna try my luck. I haven't been able to find something relevant in the help files (that I can understand/adapt!). I have a table called 'Location' in my database. This has a list of locations (defined by a primary...

Hi all. Thank you very much for all your help so far. My application has shaped up very nicely because of your help and advice - though there are still some little bits and bobs I need to iron out... Anyway.. to the topic: On one of my tables, for employees I have: HolidayAllowed...

Hi all. Please don't think I'm spamming the board! Rest assured you should be rid of me by tomorrow evening latest!!! I've created an example of what I need to do. I need to link the top field (a primary key) to the rest of the form. With a drop down menu, I'd like to be able to select the...