Search results

ya AccessBlaster but he required to fill up the data twice per page So I think well, in all textboxes there's a property "Hide Dups.." If we turn to yes, then will it create duplicate set of formatted reports

pls. clarify again u may send screenshot of excel and access workspace

why don't u use Append queries in ACCESS There are also Delete queries in ACCESS Just make any query thru Wizard. You can change it in design mode, by right-click Query Type->...bla options There's many lot automated ways you can easily do tasks ACCESS is not a Heavy You shud know, how to use...

you can use SQL Len function to detect and act thru IIF function by adding critieria i havent tried yet !

Mines worked successfully dialog box appeared with same.

pls. attach screen print of : 1. References library 2. Debug mode yellow line in your next message as if i am unable to assist you any of AWF Members and Exp. will assist you. thanks K. sumox

Hi Experts Please help me reg. this problem I've downloaded a script for exporting to excel the access data for evaluation by our other Purchase Deptt. All things go fine. But when i close access and try to check the excel file it ends with following nature : 1> Excel software opens 2>...

forget the control/field name in vba and you missed 1 comma i think

tried this ? Private Sub lstBookData_DblClick(Cancel As Integer) DoCmd.OpenForm "FrmBookInfo", acNormal, , , , , lstBookData.Column(0, lstBookData.ListIndex + 1) End Sub

WHAT U wish vba to do?

WHY \\double slashes ?? in FilePAthname?

right-click on created button thru Microsoft wizard mode goto Event tab--->Onclick -- on rightmost side of [event procedure] text click [...] button you will be taken to vba script!

if you wish to open a form Just use Form Design-View--->Control Box--->create command button If you cannot see, then goto View-->Toolbar--->control box Just simple, ACC2003/2010 ask you thru wizard for which form to open If u insist on VBA, then try "VBA Form Open Add" on AWF

sorry to forget Don't Copy Data with Column names ! ever! As itwill give error

i think you shud do easy task. goto excel. take backup of all Tables/DBs which u want to merge copy table data one by one into excel sheet insert a column row name columns as per Db's table field names delete both New & Old Table (not backup) create new table, with same name as of was the...

i know following shud work Dim Kero As String Kero= Date ... now insert you code bla bla for table update this will set Kero as Today's Date

THERE IS PROBLEM WITH ME TOO reg. same I've copied the Access 2 Excel code written in this thread's first post's reply But Error is in form of Bug : 1> The Script Executes thrice if inserted in Reports OnFormat event 2> The Access connection/data trf. agents or whatever language system Open...

store first number in a table called StartAN then use query to filter dept code and expr. to increase by 1 Google vba for this if req. thru vba only .

I have a report and in rpt-footer ,some values/txtboxes haf to be fetched to vba for calculating or External Excel file writing now I've activated OnFormat Event , which executes the script thrice per Preview !:banghead: how to stop dat dammn thing, and execute only once i am using...

hey svetslogan if you require online tutorial, just visit www . google.com and type access basic tutorial and visit any site. It's free