Jump to content

analycer

Members
  • Posts

    5
  • Joined

  • Last visited

analycer's Achievements

Newbie

Newbie (1/7)

0

Reputation

  1. nope, still doesn't work...i'd say there's no hope left for me thanks aspnetguy and Pollux for your help!
  2. yo, thanks for the fast replyyes, i tried it but it still doesn't seem to work. i add all the users (Guest, Guests, Everyone) and grant Full Control permission to all of them.by the way, this is the link to the file. please help me out here, it will only take you guys a few moment to figure this out the only thing is, i need those update quries to be able to executehttp://s24.yousendit.com/d.aspx?id=2TZLO3H...WZ2FOAJSLEBXK08thanks in advance
  3. hi, thanks for your commenti tried it out but it doesn't seem to work. i configure the database in such way that everybody has full access, but that didn't work.even though, i try setting up an update query, which doesn't update any row. however, the query still shows the same error message.please help me out here, i'm so desperatethanks
  4. UPDATE Daily SET Daily.SoldWeight = SoldWeightWHERE ((Daily.Date)=วันที่) AND (SELECT SUM(Record.Weight) as SoldWeight FROM Record, Trans WHERE ((Record.TransID)=(Trans.TransID)) AND ((Trans.TransSum)=True));but still, the value seems not to be update in the DailyAccount table (it still showing 0). however, when i execute the SELECT query, it returns what it should be.any idea?
  5. hi all, i'm really new to this stuff.i have created 4 tables, which are-Daily-DailyAccount-Record-Transit's a simple database design, where table Daily keeps the cash in, cash out. DailyAccount keeps the calculated cash in, cash out (from table Record). Record keeps all the transaction made within each day and Trans keeps the transaction ID and it's details.the following SQL query was created in MSACCESS database,UPDATE DailyAccount SET DailyAccount.SoldWeight = (SELECT SUM(Record.Weight) FROM Record, Trans WHERE ((Record.TransID)=(Trans.TransID)) AND ((Trans.TransSum)=True))WHERE ((DailyAccount.Date)=dd); (note that 'dd' is the user input date to update the data)when the query is executed, MSACCESS returns this errorOperation must use an updateable query...have no idea what's wrong with it. i tried changing the SELECT command to number like 999 and the query works fine.appreciate all the help
×
×
  • Create New...