deanvilar
Last Activity: Jun 9 '13, 03:54 AM
Joined: Apr 5 '13
Location: Kazakhstan
-
thanks sir @Rabbit awesome! -
String selection except last 6 digits
Hello Gurus ...
txt = CS000001
I selected a part of the string by"returns 000001"... but what I really need is to take the strings before these 6 digits "CS" .... I cannot useCode:RIGHT (me.txt, 6)
because the the letters before these 6 digits can be 1, 2, 3 or more letters .. for example CS000001, CSC000003, MBMMS000005, etc...Code:LEFT(me.txt, #)
thanks in advance ... =) -
yes it's simple as u told .... thanks again!Leave a comment:
-
I GOT IT! thanks sir @Rabbit its awesome!Leave a comment:
-
thanks for the reply sir @Rabbit .. let me try that now .. thank you!Leave a comment:
-
sir @rabbit can you please show to me a sample code? thanks in advanceLeave a comment:
-
sir @Rabbit ... I suspect you only want one field to be distinct but pull data from the other fields without creating any additional rows. <=== this is right
for example
as you can see ..0001,0002 an incrementing number for asset number 425525 I want to eliminate...Code:0001 425525 TOYOTA PRADO 0002 425525 TOYOTA PRADO 0001 623455 LADA NIVA 0001 623111 OFFICE BUILDING 0002 623111 OFFICE BUILDING
Leave a comment:
-
how to query Select Distinct field + showing other fields?
Gurus,
how to query Select Distinct field + showing other fields?
e.g.:
...Code:SELECT DISTINCT assetMovementTable.assetNo, assetMovementTable.moveCode, assetMovementTable.compCode, assetMovementTable.compCodeDesc, assetMovementTable.assetDesc, assetMovementTable.equipType, assetMovementTable.equipManufacturer, assetMovementTable.equipModel, assetMovementTable.constYear, assetMovementTable.plateNo FROM
-
i got it ... I created a public function in my form then call it .
Code:Forms![ASSET_DISPLAY].goHere
Leave a comment:
-
How would I call goTo goHere: from another form?
Gurus ...
How would I call goTo goHere: from another form?
e.g.:
thanks in advance.Code:Forms![ASSET_DISPLAY]!goTo goHere
-
deanvilar started a topic opens an excel file and copies values from access textboxes to excel cellsin Accessopens an excel file and copies values from access textboxes to excel cells
Hello Gurus ...
Is there any simple method how to open an excel file and copy certain values from access textboxes to excel cells??
thank you! -
thank you sir @seth ... u always save the day!Leave a comment:
-
DMAX function Data Type Mismatch error
Gurus, please help .. am having Data Type Mismatch error with my below codes...
fromDate is a date variable
txtTest is textbox in my report
Code:Me.txtTest = DMax("[mtrRead]", "fuelMngtTable", "[issueDate] < 'fromDate'") -
thanks for the reply sir @Neopa, i did like what sir @rabbit told .. it worked fine...Leave a comment:
-
thanks for the idea sir @Rabbit ...Leave a comment:
-
Create query from a different database to populate a combobox
Hello Gurus ...
I have a combo box that I want to populate using data of another access database...how would I do it? I tried searching...but I cant find any.. thank you. -
it' a long story sir @Rabbit if I will explain it ... anyways ... I got the results I needed so for the meantime I'll stick with the vba coding =)
thanks for your time sirLeave a comment:
-
sorry sir @rabbit for that ... i'll use code tags in my next posts....
that's 1 of the problem, because 1 of the fields in my report ENDDATE is fetched thru DMAX in detail format event of the report so there's a complicationLeave a comment:
-
I got it ...
created a textbox and placed an iif statement ... iif([released]="NO",1,0)
Then created another textbox to call that text to count the totalLeave a comment:
No activity results to display
Leave a comment: