Search results

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 :)

You are correct. I wasn't trying to say the app was flawless, but that the db design with respect to the two tables is correct, and the form/subform setup as well.

I think you did this correctly, both in table design and in parent form / child form. Just set Data Entry = No in the parent form.

My suggestion would be to think about this some more, before you spend a lot of time and money without the ROI. I think most professional developers have such library, some better organized than others. I doubt they are your customers. So you'll have to find customers among the up-and-coming...

The big advantage I see in SSIS vs BCP is that it can do transformations. The import file has dates such as "20211119", and without transformation that is not a valid date for a SQL Server date or datetime field.

This is the same OP who has trouble with adding Option Explicit and compiling his chess program.