Recent content by Preka

Ah... sorted it out. The form referencing the relations table is doing so via a query that links the relations table with the company table (for the purpose of displaying the miscellaneous company information on the form). A SQL view would flat out not allow the deletion because it attempts to...

Doesn't Referential integrity usually work in the other direction? I could understand deleting a field in the parent causing associated deletions in the child table to prevent orphaned entries, but why would deleting a record where a value is used as a foreign key cascade backwards and delete...

Erm... that should read, "Only when the deletion is performed from Access". My kingdom for an edit button.

So, this is driving me up a wall. This is a SQL Server 2005 database using Access via ODBC as a front end for some very simple data entry forms for an extremely short term project of limited scope. The relevant tables (or, really, an abstraction of them) are: TblRelations: RelID (PK...

Well, yes, I was planning on just using the SQL as generated, but as I said before, I'm really just curious about the "why" of it.

I've never really had cause to use SQL queries in Excel before. Having made my first, I noticed that when I viewed the SQL, instead of the inner joins I'm used to seeing, there is a series of "where" statements that perform that function instead. If I edit the SQL to use inner joins, the query...

Apologies for the crosspost, but I was informed that this would be a more appropriate locale for this topic: Not entirely certain this is the best topic for this, but it seemed close enough. I'm fairly new to SQL Server, and I'm trying to migrate an Access (2000, though I doubt it matters for...

Not entirely certain this is the best topic for this, but it seemed close enough. I'm fairly new to SQL Server, and I'm trying to migrate an Access (2000, though I doubt it matters for this particular question) database. For the most part, I haven't had many issues thus far, but one fairly big...

It's not SFS - they both have simple file sharing off. They both have identical settings in both the share permissions and the security tab of the shared folders in question. I'm thinking there might be some obscure policy or network setting that might be set differently, but I wouldn't know...

Gah, my kingdom for an edit function: "...since my laptops login credentials do match..." Should read, "...do NOT match...

I've tried Googling this, and I have seen several other people ask the same question, but I've yet to see a worthwhile answer (most people go, "hurf durf it doesn't work that way!" and they're demonstrably wrong, as I will explain in a moment). I have 3 PCs - Two desktops running XP Pro, and a...

Just wondering if there is a modulus function available for use in a basic select query in Access. For instance, if I wanted to pull out only my employee IDs that are evenly divisible by 4, would there be a quick way to do that?

No dice with repairing the office installation. I found a second computer in the office that is having the same problem. Both are newer (and the same make/model), but have the same version of office (2k pro) as everything else.

I have a fairly simple script that prints some paperwork to pdf and then attaches it to an email to whatever address is on file for our customer. For the most part, it works quite while, except on one machine in our office. That machine returns a "library not registered" error on the first...

I'm using cutePDF already, actually. The problem isn't getting the file into PDF format - that's easy enough. I just want to do it by way of VBA script without any human interaction (entering a file name, save location, hitting save, etc.) beyond "click the button".