Search results

Steve, the error message is missing (or has there been none?). There might be dependencies to other fixes that are also missing. Try to update the whole access installation with the latest patches via the Windows Update web page. Thomas

There has been bug in Access 2007 that caused problems on compacting DBs on network shares. Two machines might have that hotfix installed and the other two not. That would explain the different behaviour. Here the link to the hotfix (has also some description of the error)...

Hello Phil, do I assume correcly that you only want to load Table1? If the load could result also in new entries in Table2 (Departments) it gets more complicated. Do I also assume correctly that all departments in the Excel list exist in the department table? Under the assumption above you...

There might be a smarter way, but you could replace Month(x) with Year(x)*12+Month(x) in the compares to cover periods that span a year change.

Yes, you can. The key is the INDEX function that allows you to pick a value from an array of cells by specifying row and column. The row number is the number of months and the column number the difference in months between the month to calculate and the first month (plus one as the array count...

Hello Musthu, I am a bit confused what you want to achieve. Per the demo file I would think that you just multiply the salary with the percentages that you have listed, but I assume that it cannot be that simple. What exactly do you mean with "series order"? How have you determined the...

You are welcome. Good luck with your project.

Hello Arjanvb, oWB.Sheets(1).Columns(10).EntireColumn.Hidden = True works (just one l in Columns) Set oResizeRange = oSheet.Range(oSheet.Cells(1, RowStart), oSheet.Cells(3, RowStart + NumRows)) works (you missed to specify the object .Cells refers to) In general I would suggest to develop...

Hello Mike, you cannot be sure what mail client the addressee is using, so client side VBA is off the table There are two ways Option 1) Add a link to a web page that (dynamically) handles the unsubscribtion like http://www.yoursite.com/unsubscribe.php?EMail=<Addressee's Email Address>...

Call_me_Sam: I had similar problems a while ago. To fix this I wrote a tool that identifies dependencies between DB objects. Worked pretty well to identify orphaned and broken queries (e.g. if the underlying table/query has been already deleted). It also covers links from macros and forms, what...