Search results

Hi David, Here is the sql view of my query.. SELECT tblBuyer.byrID, tblBuyer.byrFName, tblBuyer.byrLName, tblBuyer.propBlk, tblBuyer.propLot, tblBuyer.propSQM, tblPayment.PDATE, tblPayment.ARNO, tblMOP.BankName, tblMOP.AccNo, tblMOP.AccName, tblPayment.REFTRANSNMBR...

ok can you please tell me the dB is "lock" and "not lock" considering the two stages "development" and "production".. because for me as newbie thinking, why should i lock if i am still working and still in my possession (work station/computer)..sorry again but expert and newbie may differ in...

Hi Gasman, Yes it is a simple DB.. record the buyers of a piece of land (lot), record their payments, monitor their balances, monitor the available and sold lots in every location..

Thanks the-doc-man.. you gave me a point to start how to answer the boss..

Hello all, As a newbie, may i ask when is the database be called functional, what are those minimum objects, features available?. I ask this because my boss asked me, is your project now functional and can be installed now?. Thank you,

Hi, well what do you mean by the "db lock" exactly.. terminologies of experts and newbies may not be the same, so my apologies..

Hi Gasman, I know it is not read only because i am at development stage..

Hi David, I think the problem is my MS Access itself.. Now i could not access the design view of my queries, forms and reports..the only options available on right click is open and export..

HI David, Yes i did that, i change it..

Hi, 31/12 - may date field (pdate) is a medium date format. textboxes are correct.. still, it gives same error.. what am i doing wrong here.. Any suggestions please..

Hi arnelgp, It gives me same error..

Hi, Same error "unrecognize" field name or expression..

this is what i put on my query..

Hi arnelgp, I got this error see attached.

Hi arnelgp, Thank you, just a clarification, should i replace the date value on the expression (12/31/1899 and 12/31/9999) ? for what these dates for.. Thank you.

Hi Pat, Thanks for the reminder.. will take note of that..

Many thanks cheekybuddha (David)..

Many thanks arnelgp for picking up my post, you help me lot on my first project.. What about if my criteria is a date, ie. "txtstartdate" and "txtenddate".. at present i used "Between" "And".

i have a query to filter report record..(Enter PropertyID), see attached.. What should i add to the criteria so that if there is no criteria entered, it will show all records.. Pls consider the changes, It will be change to "[Forms]![frmPrintMgr]![txtPropertyID]". What would be the expression...

Hello all, As a newbie I have based most of my report from a query (parameter Query). However, i read that too much query makes the access file bigger. How could I convert my parameter query to filter my report(s).. like i have this on column byrid criteria...