Search results

Hello Gurus, How to save another data into another database taking the last "moveCode" of another database? below sample of saving a data in the current DB. Private Sub cmdSave_Click() Set db = CurrentDb Set rst = db.OpenRecordset("fuelMngtTable") If Me.txtAssetNo = "" Then MsgBox...

open up in a different way =) btw STUPID ME ... I made the field of the dates as TEXT damn! thanks for your replies .. now its ok =D

am trying to give a check once more ... I think people here should open up a bit .. =D

oh thanks! ha ha

no error messages ... it just returns all the data in the table ...

Hello Paul ... it returns all the data in the table .. it does not filter the dates as BETWEEN ..

Hello Gurus ... what seems to be the problem of my SQL query? thanks in advance. SELECT * FROM XFEMainTable WHERE (XFEMainTable.memEndDate BETWEEN forms!PERSONNELINFO_PRINTMODULE!txtFromDate And forms!PERSONNELINFO_PRINTMODULE!txtToDate) ORDER BY XFEMainTable.memNo;

thanks for the idea ... yep for sure "running" is not the right term .. but the concept is somethin like that i suppose. I'll try using Dmax then if there's some positive result I'll surely post .. thanks

Hello Gurus ... is there such a calculation in REPORT wherein I can have the Running Difference of several numbers? Example is several Kilometer reading of a vehicle: 18716 18731 18742 difference of red color numbers: 15 difference of 2nd red color number and blue color numbers: 11 total...

in the other form make the image object bigger .. then on the properties of the image SIZE MODE: STRETCH ... think it will do the trick

it did the trick! thanks ...

thanks for your reply ... let me try

Hello Gurus ... txt = CS000001 I selected a part of the string by RIGHT (me.txt, 6) "returns 000001"... but what I really need is to take the strings before these 6 digits "CS" .... I cannot use LEFT(me.txt, #) because the the letters before these 6 digits can be 1, 2, 3 or more letters ...

I GOT IT!!!! thanks guys!

oh am so sorry Ms. Pat ... =) sir @Brian can you show me a sample code on both? thanks

one field to be distinct but pull data from the other fields without creating any additional rows 0001 425525 TOYOTA PRADO 0002 425525 TOYOTA PRADO 0001 623455 LADA NIVA 0001 623111 OFFICE BUILDING 0002 623111 OFFICE BUILDING as you can see ..0001,0002 an incrementing number for asset number...

Gurus, how to query Select Distinct field + showing other fields? e.g.: SELECT DISTINCTROW assetMovementTable.assetNo, assetMovementTable.moveCode, assetMovementTable.compCode, assetMovementTable.compCodeDesc, assetMovementTable.assetDesc, assetMovementTable.equipType...

i got it .. thanks for the idea Forms![ASSET_DISPLAY].goHere

Gurus ... How would I call goTo goHere: from another form? e.g.: Forms![ASSET_DISPLAY]!goTo goHere

Hi ... no the excel file exists and just needs to update some cells according to access' textboxes ... thanks.