Recent content by tvanstiphout

Ah, you're right. We have the page number for each category. You would know, since you wrote it, and contributed it to the NW2 team.

Check out the Northwind 2 Developer Edition template. It has exactly that, in the Product Catalog report.

One reason invalid SQL can happen is because the developer loses track of where they are with their spaces and value escape characters. A solution to this is the use of StringFormatSQL function as found in Northwind 2 Developer Edition (NW2). After you import its modStrings module, you can write...

> separate accounts for moderators I was going to suggest that as well. It also has the benefit that the mod is more consciously switching hats. We do this in my company, where I have a standard Active Directory account, as well as a separate Admin account.

That probably means some app or service has a file open in that folder. Reboot the machine and try again.

Rather than having users remember another login, simply ask Windows who is logged in (see code in link below). This is assuming that each user has their own login. If you are also on a Domain network, you can use the techniques and code I wrote about here to provide group-level security, so...

This level of indirection is not supported by VBA, it being a very simple language, comparatively. You *may* be able to do something with RtlMoveMemory API and VarPtr, but my initial tests all resulted in Access crashing.

Each category type belongs to zero or more contacts. Each contact has zero or more contact types. This is a classic M:M relation, which in many RDBMSes is expressed using a third "junction" table with the two parent tables' PKs in it as FKs, and a PK over the combination of the two fields...

But it doesn't run. You have just identified the first of what will over time be many problems, all due to incorrect database design. Your organization may have to hire the necessary talent to fix that, after which you can move it forward again. There is no shame in that. Nobody is born with...

I did not realize until now that you're working with hierarchical data. This is one area where SQL Server really shines, with elegant support for it. If SQL Server is an option, check this out. Note: Access does not support the hierarchyid data type, so you'll work with it in stored procedures...

> -- Recreate the unique index<br> > CREATE UNIQUE NONCLUSTERED INDEX IX_tblManifestDetailsFWC_NaturalKey<br> > ON dbo.tblManifestDetailsFWC (ManifestLineID ASC, FederalWasteCode ASC); What I don't see here is an index on FederalWasteCode, so your lookup "where FederalWasteCode =...

Maybe it's because the system is so busy it doesn't get control back to update the screen. In the form's Form_Load event write: DoEvents That will make all pending events execute, including screen drawing.

Another option would be "Full Text Index", but I very much doubt it will perform better. It was created to solve a different problem. There *may* also be a way to run an XPath query, but again, hard to see how that would perform better.

The performance gain is exponential, not linear. But the OP said: "When I filter for a specific waste code" And such code can be in the middle of the field value. Indexing won't help (it works from the left).

I would normalize this data after import. The new table would have a FK pointing to the parent record, and then one WasteCode. Yes, you may have 100M records in this table, but now you can index it and retrieval will be so fast your head will spin :)