Recent content by xaurien

cool, thanks for the help, thats loads to get me started, and im sure i can get the rest on my own! :D :D :D Thanks Sean

lol im sure client will change his mind again soon. table structure is 2 tables. tblStaff -name -staffid (primary) tblCourses -courseid (primary) -staffid -coursename -expiry date so i would like to insert name + course into the calendar entry and to set them on the date of the course expiry...

Hi all, I have an access database to manage when people need to retake a qualification. I would like find a way to integrate these into an outlook calendar as individual entries. I have found one way by exporting to a csv file and then importing that from outlook. Is there a way i can...

Lol. When u have clients they change their minds about as often as they have a cup of tea :(

Hi Thanks for your reply, but the client has changed their mind about what they want done. Sean

Hi all, I've been asked to create a database which will need to output events to outlooks calendar.(i think i can find vba on the net to do this) However the main problem is that once the database has been filled with data it will not be opened very often. Is there a way to get outlook to...

My apologies, have now solved problem. Just encase anyone is wondering the property is in the form properties, in Other tab and called modal. Sean

Hi all, I can't remember how i set this up and can't find a setting for it, but when i open a form from the switchboard it then disables the switchboard until that form is closed. I would like to turn this feature off. If anyone can help that would be greatly appreciated. Sean

Ok, well thanks John and missinglinq for your help, I've created the report and it leaves me with a few problems, but i will look at how to solve these. Regards Sean

Sorry!!! didnt see your post, thanks for being more helpful, can u confirm that a subreport will print fully over several pages? Thankks! Sean

lol ty for the advice to use a report, but if anyone would care to answer my question I'd be very greatful! Sean

Like I said this is the initial way i set up the database, using a report will mean a lot more work for me. can anyone tell me if it is possible to get the subform to print correctly please?

Hi all, I know it is bad practice to print forms, however the database I'm working on was my 1st ever database and thats how its done. My problem is that I have a form that I need to print, with a subform, and when I print the form however the subform is limited to stop when it hits the end of...

Thank you very much, its not a huge database, and i now dont have time to alter the way im doing it. Thx for the work around! Sean

Hi. Im currently working on a project and need to take the total value from a crosstab query and store it in another table. This may be the completely wrong way of going about this so here is the situation. I have a table for invoices, with 2 relevant fields. Invoice number and Total I have...