Access/Excel Automation Error?
543882
#1.  You are assuming that the active worksheet is the first one in the book .. if it's not, it will bomb ... see ActiveSheet property\n\n#2.  You are assuming that the macro/VBA is running in this book, but if the user has multiple workbooks open, this may not be the case ... see ActiveWorkbook object.  Better?  Select Workbooks by name (see Tag values independent of filenames)\n\n#3.  Font, color, bold are meaningless for a programming problem.  Omit them for future clarity in asking a question.  Less meaningless stuff we have to wade through.\n\n#4.  Cells(1,1) depends on where the active cell is, the user or your macro may be jumping to a different place than you think it is.  Has someone inserted a row or column ?\n\nI've been doing VBA for 15 years and I have no clue what you mean by "The server threw an exception" ... you mean what ?\n\nClues as to how to fix ... use named ranges and offsets.  Name a range (always relative to the range).  Offset from there.  Always select the correct window, workbook and sheet by name, not index value.  Omit needless code from your recorded macros such as "Transpose=False" ...\n\nStop recording macros and trying to make them work.  Recording is good to get you started, not for real code.\n\nAll in all, it's a very nice semi-adjusted recorded macro.\n\nI'm not dissin' on ya Partner !   ;-)\n\nThere are good habbits and there are bad.  Learn the good habbits and life will be a cake-walk.\n\nAlways define a marker cell ... typically the top/right corner of your range or table or whatever.\n\nAlways reference everything from that point.\n\nLock the worksheet to prevent users from inserting/deleting rows/columns.\n\nUsed named sheets ... not index values.  All one has to do is insert a sheet and you're hosed.\n\nSuspenders and a belt ... this is Visual Basic here ... anything can happen.\n\nHere's a useful link for you ... just understand that here, you're pretty much expected to know your stuff or be very, very concise and specific in your inquiries and responses ...\n\nhttp://www.tek-tips.com\n\nI would encourage you to look through the forums and judge for yourself before you post.\n\nGood luck.  If I can help you out, my contact info is in the Bio.  There is always more than one way to do things ... collect the best, chuck the rest !   ;-)
988361
Depending on what version of IE you're using, click [Tools], Internet Options, "Advanced" tab, then un-check the box next to "Display a notification about every script error".\n\nWhat you're seeing is not a problem with your machine or browser, but an issue with the page you are viewing.
372789
If you have restarted your spreadsheet program, and it has prompted you with options to restore previously opened work, then you can restore it...Otherwise no.... Sorry.\nIf you wish to avoid this in the future, (and assuming you are using Excel) go to tools -> Options -> Save Toolbar...Set you auto recovery destination and time frequency  to a higher number. It also  by default tells you where you may have a saved copy still residing that you might be able to start at least part of your recovery with...\nGood Luck! :)
283150
Here's a code snippet that you should be able to paste into a form module and give it a try ... there are obviously many ways to tackle the issue ... this is just one of them.  To use this code you'll need a reference in your VB6 project to a Microsoft ActiveX Data Access Library (like 2.6).  Good luck!\n\nDim rs As Recordset\nDim cn As Connection\n\nDim DBPath As String\nDBPath = App.Path & "&#92;customer.mdb"\nSet cn = New Connection\ncn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & DBPath\n\nSet rs = New Recordset\nrs.CursorLocation = adUseClient\nrs.Open "SELECT * FROM tblCustomers WHERE CustomerID=" & 1, _\n    cn, adOpenStatic, adLockOptimistic
603124
This should be a good start:\nhttp://www.fgcu.edu/support/office2000/access/
505781
Sub ChooseLastRow()\n\nRange("A1").Activate\nDo until activecell.value = ""\nActivecell.offset(1, 0).activate\nLoop\nactivecell.offset(-1, 0).EntireRow.select\n\nEnd Sub\n\n\nDo what ivpjennings suggested. MUCH more elegant. Completely forgot about that!\n\nBe careful with the xlLastCell. There's a bug in Excel. If you are working with your data and you delete a few rows, the xlLastCell will still be the last row of the original data set, not the updated last row after the deletions. Only after saving the file, will xlLastCell return the true correct last row.
275571
sure you downloaded for the correct version of office you are using? Also, copying it to C: might make a difference perhaps.
696118
Go to Tools>Options. Under save, check compatability options for Excel 2000
54911
to make the batch file you would start a new page in Notepad.  Then the command you would use is START.  You have to know the location on your computer where the MS Access program is at (not the shortcut).  So it would be START <location of file>
585189
can you be more specific as to what the error is or what it says exactly ?\n\nFrom what you have said all I can say is that it is self explanatory ie its scripts that have errors, which doesnt really help much.
162053
What's your OS ?\nin what application does the runtime error occur ?\nhow often does it occur ? (give a rough time between errors)
532786
if you mean acclink.xls, then no, that is an Excel spreadsheet and you would need excel to open it.\n\nCheers :)
315742
Actually, there is a way, sort of.\n\nIn the Office Resource kit, there is a tool that will allow you to share an Access database (mdb) with other users, basically making your access db into an executable.\n\nCourse, you need the office Developer edition (or was it really in a resource kit?).  I'd suggest you do a search on microsoft.com's knowledge base.
249529
May be your Ms-Office package is currupted. Try to install it again and hopefully it will sovle yr problem.
377329
Try the support page at http://support.microsoft.com I did a quick search there on the text access denied and it brought up several responses. Hope that helps.
256294
Sometimes, JavaScript / VBScript used by an application has errors in it. That's what this message is telling you.\n\nSomewhere, in your system tray, is a widget -- a printer utility, or some gizmo of some sort -- that is causing the problem. Your best bet: start turning them off one at a time until you find the offender.
93524
You can import the Excel spreadsheet into an Access table using the DoCmd.TransferSpreadsheet function.  Once the spreadsheet is in an Access Table, you can either run an update query (using DoCmd.RunSQL) or if you need something more complicated you'll have to open the table and process it row by row.