Search results

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!

thanks again

this is cool!

am going to do something like that too, in my opinion you must have a list box or grid to store your data before saving it in table .... then to save it in the table you must create a code to take all data in each row and save it ... good luck in your project

thank you sir @jdraw ... it's exactly what i need...

thanks for your reply ... let me check on that link ...

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.

Thanks for ur reply yes i just made something like that and worked thanks thanks

can you give me an example of grouping this syntax of mine?

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

I found it!!!! if me.released = "YES" then Cancel = True end if

I did ... but the problem is that the query comes first to display the data and it cant fetch the value YES or NO generated from detail format event of the report.

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.

Yes ... that's correct .... the real problem am facing is that I put this value i created in query which is not reading because am not pretty sure if query comes first before having the detail format event of my report

can you assist me on this sir @Beetle? I have this query SELECT * FROM assetMovementTable WHERE ((assetMovementTable.toJobCode)=Forms!ASSET_MOVEMENT_PRINT_MODULE!txtJobCode) And ((assetMovementTable.toDate Between Forms!ASSET_MOVEMENT_PRINT_MODULE!txtFromDate And...

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

yes there is .. even it's successfully exported to Excel ..

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

thank you for the reply @gemma, now am reading what sir paul gave me ... and too bad i think i need to adjust everything =(

thank you sir paul, ill read this many thanks