Search results

excuse my ignorance but what do you mean by extended properties? Dave

hi Daz, to follow my suggestion you need to have what I suggested in 1 query for the 10 fields you have, so it will be something like this: TotalCount:count (*) TempField1:dcount ("[FieldName1]","tblName", "[FieldName1] = "Criteria") PercTempField1: ([TempField1]*[TotalCount]/100)...

One thing I have noticed: ********************************************** stDocName = "Word Answer Query" txtRightAnswer = DLookup([Word_Answer], "MyAnswer") ********************************************* shouldn't txtRightAnser be: DLookup([Word Answer Query], "MyAnswer")? also, pls post the...

Have a look at this: http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3BQ209696 Dave

I would suggest that you search the web for access tutorials. There are many that explain in fairly good detail the development of databases. good luck Dave

use a query?

Yes, you can do all that with Access using a table and a form. The table would contain the raw data, the form contains raw data + formulated data eg: RetailPrice = CostPrice + Tax Raw data is entered in the form, the calculation are done by code after the last field of raw data has been filled...

You have your sintax a bit wrong, it should be something like: =DLookup("[FieldName]","TableName","[FieldName] = "Criteria") if the criteria is a value in a form it should be: Forms!frmFormName!FieldName = etc Dave

use the Max function, eg. Max([FieldName] + 1) Dave

a) count total records eg. a:count(*) b) count required records eg. b:dcount ("[FieldName]","tblName", "[FieldName] = "Criteria") c: calculate percentage of b over a. repeat for each field Dave

Put the code in the AfterUpdate event of the list box. Dave

There is also the issue of size, Access will store up to 2 G of data so, eventually, you will run out of space. Dave

pls post your code in full Dave

did you dim xlApp? did you create the excel object (Set xlApp = CreateObject("Excel.Application")? Dave

you can even do it without code: File===>Get External Data===>Import then select the exel spreadsheets you want to import Dave

No, but you could use a pop up form with a combo box full of criteria values to apply to the query. The criteria in the query would be something like: forms!frmPopUp!cboCriteria Dave

something like this in the Exit event of the answer field: dim txtRightAnswer txtRightAnswer = dlookup etc if Me!FieldName = txtRightAnswer then Me!ScoreField = 1 else Me!ScoreField = 0 end if Dave

wish you said so at the beginning, I never worked with adb projects Dave

Unfortunately you cannot. What you can do is get rid of the Access supplied tab format all together and create your own. Off hand I cannot remember how to do it so, if you wish, I will let you know on monday (friday, nearly knock off time in here....) Dave

I would change the field named Date to something else. Date is a reserved term in Access (there is a function in Access Date()) so that could be a part of your problem. Dave