Search results

Ahh, I didn't think parenthesis worked like that in Access. OK I will try this out and get back to you. Many thanks!

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...

I know it seems like I am storing the same info twice but some people will never get to the telephone screening stage even if they have completed the online survey questions. Conversely not all people who do the telephone screening have done the online survey. However everyone who wants to do...

OK. Getting there (slowly - with your help) :) Now the issue for me is that when the AddNew form closes/does the before update (I have to think about this some more), the telephone screening form is not yet open. Which means I have to pass the addnew data to the table rather than the...

Thanks everyone. This is basically the situation (see attached schematic) - sorry the description of the database is so long, but I can't TL;DR it. I have created a database to track calls from potential participants about a study I am recruiting for. These participants can approach us in two...

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...

Thanks - so I wasn't off the mark. I will prepare a sample database and upload it in the next day or two. Many thanks!

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...

Sorry can you work through that solution a little slower? I am definitely sure that the fields are name txtCaffeine1 and so on..

Hi I am trying to build another module and am coming up with the name error again :) This module is to report the total caffeine intake of a participant in a study. The participant reports how many cups of coffee, tea and so on they drink and I need to calculate (based on standard vlaues) how...

Do yuo think I could build this around the existing diary database that I sent you? Since we are doing telephone screening and not everyone gets to the point where we ask them those questions but we do records all incoming calls where possible (i.e. we have their first name and cell phone...

I understnad that but that is quite a simple example... Lets assume that I was using the expression builder for whatever reason. I referred to those fields already earlier in the query (each of those fields were already a column) do I then refer back to the fields in the original source table...

I think we are talking about the same thing however when using the expression builder in query and you have to refer to list price and ourcost in the expression if gives you a chance to get those values from the query, table, forms etc..in the first column of the expression builder. do yuo use...

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?

Hi Mike Did u get a chance to look at it?

If I understand you correctly you have created a query to filter data and u are trying to save the filtered data as a new table? If you are trying to create a query as a filter you cant actually save the data in the filtered state - the filter is like a window shade that only lets you see part...

Have you tried to do anything yourself yet?

What type of information are specifically trying to collect?

opss sorry - I am always doing that in emails! :o Here u go.