Search results

Hi I think this is probably a basic statement but I can't seem to find what I am looking for... How do I combined multiple OR statements in conjunction with an AND statement as follows: If [Len(Field1 & "")=0 OR Len(Field2 & "")=0] AND Field 3 = "Something" AND Field 4 = "Something" Then...

Hi All, This is an offshoot of my previous post but I am still working towards a solution. This is basically the situation (see attached schematic) - sorry the description of the database is so long. I have created a database to track calls from potential participants about a study I am...

Hi I know this is a simple question but I am still not sure of the answer. If I was to test several fields on form close, each of which are independent of each other and will cause an action if they are not empty, do I do the following... Private Sub cmdSaveRecord_Click() On Error GoTo...

Hi I've been working with access on a small scale for a long time, creating databases so I can track information about studies etc just for me. I'm pretty handy with VBA etc but have not put a lot of effort into creating normalized relationships but now need to work on a database that I need...

I know I should know the answer to this but if you are creating a query that includes individual fields as well as calculations based on some of those fields, do you select the source field or the query "field" when using the expression builder?

DOes anyone have any examples that they are willing to post or links about how to build an appointment book in Access? I have tried google but I cant seem to find useful links. Thanks.

I recently changed the code to a case statement which recoded a value into a new field i.e. Case = 1 Me.Field2 = 2 and so on... However the old data would not reflect this change as the Me.Field2 value had already been created. Short of opening each form, changing a number closing it and...

I have a simple query based on two fields that says Component4 total = no of hours sleep/no of hours in bed * 100 where no of hours sleep = 9 no of hours in bed = 10 therefore component 4 total should = 90 instead it equals 89.999999 How can this be? For all the other records the answer is...

I am wondering why access does not follow its own code all of the time? For example I have passworded forms following the tutorial on the Microsoft site. It mostly works when the participants fills in the wrong password we will get an error message box and when they cancel the password...

If I write a select case statement for a field X i.e. 6 to 7 for example will this: 1. Select any fields X where the number is greater than or equal to 6 but less than (and not including) 7 B. Select any fields X where the number is greater than or equal to 6 but includes decimels of 7 i.e...

THis is probably a simple question but I cant seem to get everything coordinated. I have a form that collects information about participant's in a study including height, weight etc. I need to automatically calculate BMI once a person has placed the information in to the form so I created a...

I followed the instructions by Microsoft for passwording a form (http://support.microsoft.com/kb/209871) but once I tried to split my database I get an error message #3219 when I try to enter the password and open my form. I know it has something to do with the code and Set rs =...

Ive have seen a number of threads on this but I cant seem to get my button going. Basically the structure of my forms/database is that there is a switchboard on which there are two buttons, ones to a form called "Data Entry View" each of which has a button for each form that when clicked opens...

I stupidly designed a series of forms in a 17 inch screen not really thinking that the program would be used on a 15 inch or so screen. I had the settings ( border size resizable, auto-centre, auto-resize and popup) so the lines are very clean and although I dont really like it I will out in...

I have a number of fields that hold values (scores - either 0,1 or 2) that need to be summed but in some cases the value is 99 (which is recognised by our stats program as a N/A type of anwer- This occurs when a question is optional and the user hasnt answered it. I did not want to value to be...

Hi I know this is probably a silly question but I had a number of checkboxes in a table and had set their default value to be 0 however I did not do this in the table properties of these fields. I can understand some things like formatting dates in a form but storing it differently in the...

I have a field in my main form that shows values of BMI which is calculated from the users height and weight which they entered on a form attached to the same table. I have a query called BMICalculation which is attached to this field using =DLookup([BMI Calculation, "BMI Calculation"] etc...

Hi I have two fields one which represents the time participants went to sleep, one when they woke up however I dont have any dates - it refers to what they do usually. Is it possible to minus sleeptime from waketime to determine duration of time in bed without dates? Or do I assign dummy dates...

Okay I have a report (rptHorneOstbergQuestionnaire) that is based on a query (qryrptHorneOstbergQuestionnaire). In the report I have a total (HOTotal) which is the result of an expression created in the qry. Based on this result I would like to generate text in a text field (HOType) that is...

Im stumped. I have to create a form based on a questionnaire. I have to recreate the questionnaire exactly and cannot change anything. One of the questions has 6 possible answers - however in order to score the questionnaire two of the possible answers are given the same value of 1. Dont...