Recent content by Thepieman

thanks FAO: Ken - Thanks for your comments. I have now created a backend database and I have checked all the code. I have now deleted a bit of code which is no longer needed. I am going to roll out the database later this week, so see what happens FAO Maxmangion: - There are approx 30 users...

Our department uses an Access database we created to log incidents regarding IT Faults. Users frequently get an error message saying ‘Unrecognized Database Format’, stating the path of the database. Performing compact and repair solves the problem, but only temporarily. Everyone has to exit...

I am currently building a db to record employees IT faults. I have set up an Outlook form which allows staff to record staff no. and description of the fault. Once an email has been received I would like the information to be automatically transferred into my db - but I cannot get this to work...

I am currently trying to build a database that calculates the actual working hours it takes to complete a job - so I need to exclude weekends and any time elapse between 6pm and 7.30am. So for example a job registered 5pm today and cleared at 8.00am tomorrow would show a working time of 1.5...

I have a database which records the time when a call came in and when someone closed (or responded) to that call and I need to to work out the time that has elapsed between the two times in hours. My problem is that I need to take business hours into consideration (i.e. stop the clock between...

Apologies Sorry dont think I explained this very well. The logon screen gets you into the database, I then want to create a button on the main switchbord which the engineers will click on if they want a job. Does this make a difference ? If not can you simplify the instructions (sorry bit new...

I am a relative new comer to access and am currently developing a db for recording IT incidents which are then picked up by one of our team of engineers. I have built in a logon screen (staff number and password required) and want to add a button that when clicked on, by an engineer...

I have a database that records IT Incidents for a major company, when an incident is recorded the date is automatically input in "General date" format. I now need to produce figures that summarises how many faults occur each day, but can't get my query to work. Can anyone help ?

Thanks and more help please Thanks - you're suggestion of allocating a job on the click of a button is a much better way of doing things ! Some info - yes everyone has the same skills and yes I do have a login form using a staff number and password (also records times each person was in the...

I am currently in the process of building a database to record IT faults which will then be picked up by engineers. The database has been built so that the engineers need to login using a user name and password (design lifted from this forum -THANKS...

I am new at this so can you help please ? I am currently building a database for use by a small IT Team which will allow a receptionist to record details of IT Faults which will then be adopted by an engineer. My problem is that I want to add some sort of system that will prompt questions the...