Search results

CJ_London, Thank you for your help, that worked nicely. thanks again

Hello, I have a service database for equipment. We have discovered a new user has changed existing data in fields by mistake, over a three week period. I have a backup backend which i know is fine. How would i go about checking each record looking for changed fields based on my backup? Thanks...

Thanks pr2-eugin. I thought it might be a bit tricky with a query. This is for monthly audits sampling a small number of studies, so really needs to be off a query so it can be dynamic rather than exported. Thanks again for your advice.

Hello, I hope you could advise. Is it possible to only show a percentage, like 5% of records using a query? Ideally i would like my query to show a random 5% sample from a table, that would be great. Is this sort of query possible?

Hello, i hope you might be able to help. I have two dates in a query, ExamRequested, and TestDate I am trying to figure out how to show all test dates which were done 30 days over the requested date. But ignore the test dates which are inside this 30 day period. Any pointers would be...

Thanks to you both, This one had me stumped! :( I like to work my way through problems and in most cases I get it or with the help of searching the forum since most of the time someone else has gone before me. Have a good weekend.

WOW you were quick :) It worked. I have spent hours trying to figure this out. Thank you SOS Best wishes, trevor

Hello, I need a bit of help please with the following query. I have a query based on a products table “UnitsReceived” and Orders Detail table “QtySold” My auto calculation field in the query is as follows:- In Stock: [UnitsReceived]-[QtySold] If there is no value in field “QtySold” I get...

A couple of favourites : Fast Stone Image viewer / editor: http://www.faststone.org/ Excellent, opens most picture file types and is great if you do a lot of digital photography Backup Utility, Karenware, works across networks, any file types, very simple to use...

Hi, I thought I would let you know the outcome in case something like this happen to you. Our server has a raid controller with a hot swap, and mirrored drives. One of the hard drives had failed. This was replaced, server rebooted and back in business. I don’t know why it had such an effect on...

Hello, I have an Access 2003 developed database, works fine on Access 2000/3 and was fine on 2007 until today! I get a debug screen, looks like it won't resolve the "acNewRec" line. Code is as follows: Private Sub Form_Open(Cancel As Integer) DoCmd.Maximize DoCmd.GoToRecord , , acNewRec End...

Hi Paul, Thanks for that. What I ideally want to do is make the subform visible after three of my required fields on the main form have been completed. Is this possible?

I would like my subform to become visible once a couple fields on the main form have been filled in. I want to prevent data being entered into the sub form without the main form being populated. Any help would be appreciated. Thanks!

Fantastic, Thank you both for your help.

I would like to run a query to return all dates for a year like 2007. I need to ignore the day and month so the user will be asked to enter the year “2007” they require a form list on. I have used the between date query:- Between [Start Date] And [End Date], and it’s okay but it would be much...

Hello Mark, That worked a dream, Much appreciated. Thank You! Regards, Trevor

I have a print button on a form, when the button is clicked (to print report) I would like a text field to automatically show 1, if pressed again in future would show 2 and so on. Users have asked for this so they know if someone has printed the report. Your help would be great. Thanks Trevor

trevor@mius.fsnet.co.uk

Rule NUMBER ONE!! make sure you have a master copy of your database safely stored out of harms way before you go doing anything. I’m paranoid, I always have a nightly FE & BE copied. Stating the obvious but people “forget” to backup and come to regret it... I have!

Sure you can. If you like I can give you a ste by step guide. Hy, Im no expert but I have several db's split and accessed remotly by sales guys and engineers. Trevor