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

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;

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

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

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

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

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!

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.

what seems to be wrong with my date between syntax ???? =( ElseIf CDate(tstEndDate) >= CDate(Forms![ASSET_MOVEMENT_PRINT_MODULE]!txtFromDate) <= CDate(Forms![ASSET_MOVEMENT_PRINT_MODULE]!txtToDate) Then

Help Guys .... I need to hide a row in my report for example (in Detail Format event of the report): If me.txtReleased = "YES" then hide row endif thanks in advance.

Hello Gurus, is there a way in report that I have 2 reference queries just 1 is to populate all details and 2nd query to filter details and will be the final reporting information???

PDF was generating and saving to the correct location, but when I open the PDF file ... it's blank =P am using access 2003 and acrobat standard 9 Private Sub cmdPDFByAssetNo_Click() Dim MyFilter As String Dim MyPath As String Dim MyFilename As String MyFilter = "" MyPath = "O:\Onshore Asset...

am already set to publish my MDB but I want to have a FE and BE application so that even 2 - 3 users can access them .... I tried to split it manually, but no avail... got an error RUN-TIME ERROR '3219'; INVALID OPERATION and highlighted my recordset ... (attached image) do I need to connect...

I used Dlast function to determine last record of such Field as reference, but as the fields are apart from the record it does not return the last record why is that so? attached is a sample of the records dim rYear as String rYear = Nz(DLast("returnedYear", "documentLog", "fileCode LIKE'" &...

Gurus ...in desperate need of your help =) situation is this, i have 1 combo box for FileCode (Alpha) and 1 text box for FileCode (Number). When saving it in the table it becomes FileCodeAlpha & FilecodeNumber e.g.: CAM0001 I wanted to do something like this: after selecting from combo box the...

Gurus, I found this wonderful login codes and I think its very cool...but 1 thing! I can't define USER LEVEL ACCESS after DLOOKUP .... can you share your ideas? thank you... Private Sub cmdLogin_Click() 'Check to see if data is entered into the UserName combo box If...

Hello Gurus, I need your help to validate if a Field in my table is NULL, details of which will not be included in my report. I attached sample report wherein the data is sorted by EXPIRATION DATE, first rows displayed the data of NULL EXPIRATION DATE FIELD ... Thank you in advance.

Hello Guys my name is Dean, I was a VB 6.0 programmer about 8 years ago and forgotten all logical and algorithms aspect of being a VB programmer and worked as a SAP Asset Administrator. I saw this site and wanted to join as I wanted to create an Access type Archiving system to be used internally...