Search results for query: *

Okay, I figured it out. The "UpdateInventory_Received" data macro is triggered by an "After Update" Event macro on table PurchaseOrderDetails. From the table design view, I clicked on the "Create Data Macros" menu option on the Ribbon > then clicked on the "After Update" menu item. This...

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

carp -- Your solution worked perfectly. Thanks very much. Thanks, too, for the side note. Right now, I don't care about which lat/lon pair gets chosen for the street, just as long as the street gets represented. cheers, oneleaf

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

Remou, It worked -- again you have come to my rescue. Many thanks, oneleaf

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

Remou, Wow, it worked. Thanks so much! 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...

Okay -- I got it. Instead of =Sum([txt1]), what I needed to do was =Abs(1*([txt1])) =Abs(2*([txt2])) =Abs(3*([txt3])) =Abs(4*([txt4])) =Abs(5*([txt5])) Everything runs fine, and the average rating for each workshop is correct. onelarf

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