Search results

Sorry for the delay. Can u please direct me on how to send you the database ?

No error messages. When the form opens it still contains previous records. I want it to display a form ready to receive new data in its fields. Louis Buhagiar.

Tried that. Still no joy. Could there be something over-riding the settings ? Many thanks. LOUIS BUHAGIAR

Tried that. Still no joy. Could there be something over-riding the settings ? Many thanks. LOUIS BUHAGIAR

I have been having problems with opening a form to add new records only. I have gone through all possible solutions but somehow the problem persists. I want to add new records only and not view any of the existing records. I have set the form properties to Date Entry Yes, Allow...

Can someone please remind me how to reference a value on a combobox in one form from an object on another form. I have put in =Forms![Company Name].Combo7 in the field object on the form and I have got the ID autonumber of the Company Name. So far so good. It worked. When I put in...

Hi, Many thanks for all your comments. I changed the format of the upper and Lower limit fields to numeric etc. And now the conditional formatting is working according to plan. I suppose the software was comparing numbers with texts and was becoming erratic. Thanks Paul. Louis

Ok. So I removed all objects from the database except those that concern us. By that I mean the subreport with the source query and tables. On opening the sub-report in report view on can see that the conditional formatting is erratic. I hope that I have written up the conditional formatting...

Hi Paul, Many thanks for replying. I have been trying to solve the problem since. I will try to export the main report, sub-report and the query on which it is based. Sorry to sound so naïve. Can you direct me on how to export these items separately from the database ? Many thanks...

Hi Paul, Thanks for replying and for thinking about my problem. No I cannot see a pattern. All I can notice is that some results are rightly formatted as expected, while others are wrongly formatted. Generally they are wrongly formatted when they are within the normal range. I am sure...

I have a report in Access 2007. This has fields with names of patients, and clinical details. It has three subreports. The first has laboratory results of blood tests. On the report there are reference values with lower and upper limits of normal laboratory values. The blood results occupy...

In fact I have now inserted a module with INSERT/MODULE, placed my code there and Bingo it is working. Never really grasped the difference between class modules and the others, and why the former do not appear and the latter do appear in the navigation pane. In any case I wish to thank you...

I would like to write a Public Function in access 2007. I have written such before and they work well. I am now working on this new database. I would like to make a calculation so that I could derive a value called eGFR from a patient's serum creatinine. This is a test of kidney function. I...

I appreciate your help in this problem and your direction. However, I am having problem making changes to my database program because of this problem. As I have explained to you I have a back-up of my database front end. So at the moment it is not a question of retrieval of program or data...

I have a database that I have been using successfully for seven years. I update it frequently with improvements and additions as needed. Recently I have been getting error 3197. "The Microsoft Jet database engine stopped the process because you and another user are attempting to change the...

Very kind of you. Why is it that even when there was a picture for that particular resident I was still getting the same error ? Thank you Paul. Louis

Paul, Many thanks for your reply. I changed my code to the code you posted and, presto it worked immediately. Cannot thank you enough! As it is, the default picture only appears when the there is no picture for that particular resident of the form shown. When there is picture for that...

My database contains a list of residents in a retirement home. One of my forms contains all their particulars. My goal is to get each one's picture on the form. I know I could include the filepath of each picture as field in the table containing their particulars and include this as a...

jdraw, Many thanks for the information which is useful. However, i cannot find a way to automatically show the date and time when a picture is taken and show it as a field on the form. The picture comes up quite will using the path to the picture as the control source of the image. This...

I have been searching around to solve this problem. Apparently when a digital camera takes a photo it stores other data along with the image. The date consists of the camera type, focal length, exposure, date and time, etc etc. It stores the data in a record and transfers it along with the...