Search results for query: *

Sorted it out already, there was a space in two places in the query for [ qryAllPersons]

Hello, I have a query with the following structure: qryAllPersons: Select tblPersons.ID, tblPersons.Name, tblPersons.DateRecorded_A, tblPersons.DateRecorded_B, tblPersons.DateRecorded_C, tblPersons.DateRecorded_D, From tblPersons; And this gives the following result when executed...

Thanks, but I solved this one now. Used a update query instead.

Hello, I have have searched through numerous post in this forum, but I still have the following question: I have a database with a table say tblPeople. This table contains e.g. the following fields: ID----NAME----SURNAME----HAND---PERCENT1---PERCENT2...

Thanks, with using some if...elseif...else statements i got my version to work!

Good morning! I have a form which an user fills in, and before clicking on a button to go to the next form, there must be a check that all controls have been filled in completely. For example, if I have frm1 with fraOne, cboOne & txtOne, I wrote the following code for the OnClick event for...

Solved it now... The problem I had was that I am using a German version of MS Access, and somehow it did not understand the term Iif. Strange, cause it can translate other terms, like Nz, True, IsNull etc. Seems there is a bit of a language barrier problem at Microsoft... Well I got it to...

Well just got back to this problem... EEEESSSHH It turns out that I will have to use this Nz function in the QBD grid (pardon my previous misspelling "QBE"), because I will be basing a search form on this query. Can I maybe send this sample DB to someone who can then check it out? Regards, JP

Yip that worked now, but it really boggles me too why that was an error with using Nz() in the QBE... thanks guys - stars for you

Nope, created a new query, in design view, with the following in the "field" box: BMI:Nz([BMI_L], Nz([BMI_R], Nz([BMI_VID], [BMI_VTH]))) still no luck...(syntax error)

OK here goes the SQL.... There are 4 calculated columns in this query, namely BMI_L, BMI_R, BMI_VID and BMI_VTH. See them? SELECT [tblVersuchspersonen_test].[VPNummer], [tblVersuchspersonen_test].[Nachname], [tblVersuchspersonen_test].[Vorname], [tblVersuchspersonen_test].[Abteilung]...

The text box is called e.g. txtFinalValue, but i do not see why that should matter. I tried using this in a query, by typing it into the "field" box of QBE, but it still gives me a syntax error....

No, as I said in my first post, the textbox is based on a column in a query, called Value1, Value2 etc.:

Yeah what I mean is that I get a syntax error. (trying to enter this expression in the Expression builder of the ControlSource property of the text box) When I leave out the "=" sign at the beginning of the expression (as in =Nz(Value1, Nz(Value2....), I get no syntax error, but the value in...

Thanks PH, OK that is fine for 2 columns then, but what about if I have a Value 3 and Value 4 column? I tried something like this, but it doesn't work: Nz(Value1, Nz(Value2, Nz(Value3, Value4))) Regards, Jean

Hello, I have a Text box based on a form, called e.g. txtFinalValue. I want the value that displays in this textbox, to depend on something though. For example, if I have the following columns in a query, which the recordsource for the text box is based on: ID Value1 SubValue1 Value2...

OK OK got an answer already, thanks to KenHig from Access World. said i should do this "Set the multirow property to yes and manipulate the widths? " and it works! cheers JP

Thanks for those links...I will keep pursueing my goals with these!

Hi, I was not really sure how to formulate this question, but I'll try. I would like my Access form to also be tabbed e.g the tabs should be able to go under each other and not all be in one horizontal line. If this is unclear, please see this post ( Click HERE ) that I posted on Access...

Hello, I know that Google can be man's best friend in such a situation, but was wondering if anyone can help me more here. I am looking for some ideas on how to build a form which searches for values as given by a user. E.g. this form has maybe 10 text boxes for search criteria, which can be...