Search results

I've been developing with Access on my iMac for last 3 years. Mind, I use VMWare Fusion, but fortunately, the competition between Parallels and VMWare has been pretty hot so both are pretty well-featured. I'm loving the convenience of having several virtual machines with different combination of...

Hmm, that's very interesting observation. That would actually suck if that's something true of any ActiveX control and not just FlexGrid. I guess it makes sense since ActiveX control have to be persisted but to think that copying then changing properties would create that amount of bloat is...

I see. Did you use the code as it is? On the form or on the query? I can't say I've gotten two files, a XLS and a XML. I've found it more convenient for the users to just open it in Excel and let them handle the save operation, which is why I omit the filename parameter and use...

Why not simply export directly from pivottable itself? (assuming code is in the module behind the form) Me.PivotTable.Export , plExportActionOpenInExcel Reference

Here's what I did to "trace" the bloating. Create a new form, put one textbox and set Popup=yes. Clear out all other properties (Record Selector, Navigator etc etc) so it's more like a dialog. Set an timer interval of 1 and add an timer event: Me.Text0 = FileLen(CurrentDb.Name) When you open...

I've traced it to simply opening the frmParts. However, I had problem with tinkering with the frmParts. For starters, I got an error: 438 Object doesn't support this property or method on this line: Forms!frmParts!LstFlxGrd.Redraw = False for the procedure FillLstGrid. Furthermore, if I...

I don't see a link? Have you tried zipping it up?

The real problem is that a business that is running a deficit is also risking insolvency. The business can opt to make a short-term loan to cover the deficit and thus increase the debt but that is not actually a better financial position. This depends on whether deficit ends and there's positive...

One thing to consider is that if you are on a 64-bit OS, you need to be sure you're using 32-bit regasm and not 64-bit regasm. 32-bit regasm: C:\Windows\Microsoft.NET\Framework\v2.0.5727\regasm.exe 64-bit regasm: (the only time you would use this is with 64-bit Access 2010. Otherwise, don't...

I would much strongly recommend that you do not open database on a network share. Instead, split the database and give users their copies of the front-end. This is considered a best practice since Access' inception. I don't know why it's now an issue with 2010 when it wasn't with 2003, but...

While physical violence may not be present, I still think it's a violation of one's humanity. We instinctively understand that a brute taking a purse from elderly woman at knifepoint is violent even if the woman obligated and gave up her purse. We still instinctively understand when a gang of...

You'll need to provide an example of what you're describing because AFAIK the behavior of Database.Execute & Database.OpenRecordset and DoCmd.RunSQL & DoCmd.OpenQuery is pretty much consistent once you take in the differences of how they resolves the references to Access objects.

So you feel it's OK to take by violence the billionaire's money and give it to other people? Once you open that door, you have to carry down to the logical consequence that ultimately, it's the might that makes right and today's might happens to be by a majority vote rather than a fiat of a...

There's this e-book.

I see that you've commented out the CreateQueryDef & QueryDefs.Delete. That would have definitely created bloating. If there's still other like that, you'll want to comment that, too. It's OK to change SQL property of an existing QueryDef, but generally avoid CreateQueryDef. DAO does have a qry...

I do not believe using dynamic SQL, whether via Database.Execute or DoCmd.RunSQL method create the bloat. It's mainly related to creating objects because by design, when Access needs more storage to hold data (whether temporary or not), it allocate the extra space on drive but when it's done...

Morality is the basis for our justifications of actions we take so it's hard to avoid morality, especially in this discussion. We're appealing to some kind of morality -- "everyone should pay their fair share", " it's fair that rich helps poor", "nobody should be held responsible for others'...

Are you creating any temp tables? Creating any controls/forms/reports at runtime?

I would think that because you're referencing DAO 3.6, it is not able to recognize the newer ACCDB file format. Either use a MDB file format or reference instead "Access database engine object nn.n object library", where nn.n would be 14.0 for Access 2010 or 12 for 2007. Note that this is still...

Indeed it isn't. Doesn't mean it's any more moral. The only difference between a government and a mob (or mafia if you will) is that one is "legitimate" and other isn't. But beyond that, there's no difference. Surely you're not denying that rich people are less human than poor people? Two...