Search results for query: *

Hello friends, I've been acquainting myself with the new features of Access 2010 by picking apart the Northwind 2010 example database. I'm trying to figure out how the inventory levels in the Inventory table are updated. I've located the data macro named "UpdateInventory_Received" that calls...

Hi Folks, I'm getting an "overflow" message when running this function. Does anyone know what I'm doing wrong? I'm a bit of a newbie so don't laugh at my code/logic. The user enters a date in a parameter query which gets passed to the function. The function is supposed to find the next...

Hi Everyone, I'm trying to flag only the first record for a street that has a positive latitude value: update savoy set flag = 'Y' where street = (select distinct street from savoy where lat <> 0 and rownum = 1); The result I would like is this: STREET LAT LON FLAG miller st 0.000000...

Can a DLookup be run on a Memo field in a report? I am trying to get a Memo field to appear on the Report Header of my report. The code I'm executing is this: =DLookUp("WhatsNew","tblFiscalYear","FY=" & [FY]) Any suggestions? thanks as always, oneleaf

I'm trying to delete a record from a List Box. When I run the code below, I get this error: "undefined function '[Forms]![frmFiscalYear]![lstMembers].Column' in expression" tblFYMembers, where the List Box items are stored, get its values from the FY field on the Form, and the ID field in...

I have a report for work that lists the survey responses for each of our Conference workshops. Information about each workshop is displayed in the Report Header. Also in the Report Header are the total ratings the workshop received, ranging from 1 to 5. These totals are acquired from...