Search results for query: *

Hi, Have a major headache at hand, completed an Access2000 DBMS after a few months work and jus before my final presentation, my supervisor wants it to be Access97 capable. Presentation is coming very soon n need some help.... Is there a way i can convert the Access2k to Access97 at the same...

Hi, Is it possible to disable an Access Startup form using VBA?? Been searching for possible solutions around but to no avail. Anyone? Thanks.

Hi Elise, Jus as simple as that, the 'Now()' function has solved my problem. To think I spent 3 hours trying to get the 'Date' function to work correctly. A star to show my apprecieation. Thanks. Cheers

Hi, Need some help as i'm stuck with this niggling prob... I wish to assign the the current day, month and year to 3 seperate variables using: CurrDay = Day(Date) CurrMth = Month(Date) CurrYear = Year(Date) Looks simple n straightfoward but it returns garbage, after a few inspections, i...

Hi, I need some help with this. The code is supposed to paste an image from c:\map\map.png into a word doc bookmark 'b1'. However i jus cant seem to find the right coding for it to work. .ActiveDocument.Bookmarks(&quot;b1&quot;).Select .Selection.??? <-- how do i continue from here? Help is...

Hi, Thanks 4 the reply. I had that reference enabled prior to posting but it still returns the same error.

Hi, I am trying to run an Excel Macro &quot;Plot_OnAirDate&quot;. However i keep getting the error message of: Error 440 Automation Error Below is my code, can anyone point out where i've gone wrong? Thanks for any advice rendered. Dim xlApp1 As Object Dim xlWrkBook1 As Workbook Set xlApp1...

WIll give that a try. Thanks.

Thanks for the offer. Please check your mail. Hope to get the reply soon. Will get back once i'm back in office.

Hi dwlerwill, Thanks for the reply. Tried that but still i get the same error msg and result. runtime error 3011: &quot;Object tblChartData not found&quot;. All i get in the Excel workbook is a blank worksheet but with the headers on. Strange... No data only headers. I'm sure that i've not...

Thanks 4 the reply. ODBC, I'm not good with this so is there some thing i can refer to or better still find a template for me to work on. Thanks.

Hi, I need to automate the transfer of data stored in a table 'tblChartData' into an Excel spreadsheet 'table' for chart plotting purposes. I've tried using DoCmd.TransferSpreadsheet acExport, , &quot;tblChartData&quot;, &quot;L:\TCH Traffic Chart.xls&quot;, False and...

Hi Is it possible to dynamically link the contents of the Excel2k spreadsheet(destination) to the contents of a table in Access2k(source)? Cos its possible from Excel to Access but not the other way around it seems. Can anyone help?

Thanks for the suggestions. Currently i'm trying but in the line: For Each ctl In Me.Controls I keep getting this error Error:2645 Cant find the field 'control'refered to in your expression. Is there a reference that i need to add in for this to work?

Oops, missed that out. :) Anyway Stalo's suggestion should work. Experienced that error before too. Good Luck.

Hi, Try this since u are updating your table!main of the database. Set rst = dbs.Openrecordset(&quot;Main&quot;,dbOpentable) rest looks ok Hope it works.

Hi, I've got alot of textbox fields to enable/disable according to what value a user keys in. eg: Me!Text1.enabled= True (previously False) Is there a way to make the nunber component a general one like Me!ScnXX.enabled = True/False where XX is the number which increments till it hits...

Hi, There was a similar code in here. Anyway i adapted that into mine. Hope this can help. in the OnCurrent event Me.RecordsetClone.Bookmark = Me.Bookmark CurrRec.Value = Me.RecordsetClone.AbsolutePosition + 1 'to get current record no AllRec.Value = Me.Recordset.Clone.RecordCount 'to get...

Hi, After some help, managed to find that small error highlighted in bold. Always helpful to have someone else to help check for errors. Thanks KC. End If rst.Close Set rst = Nothing db.Close Set db = Nothing Exit Function(Instead of END)...

Hi, After some help, managed to find that small error highlighted in bold. Always helpful to have someone else to help check for errors. Thanks KC. End If rst.Close Set rst = Nothing db.Close Set db = Nothing Exit Function(Instead of END)...