Recent content by qrk10000

I am working on a different macro that sets a relationship between two tables: Footprint and Pre-Deletes. Here is my code: ALTER TABLE [Footprint] ADD CONSTRAINT FK_Geo FOREIGN KEY (Geo) REFERENCES [Pre-Deletes](Geo); I get an error stating that it cannot set relationships to enfore...

Nevermind, I was able to figure it out using the DROP INDEX statement. Thanks again for your help.

Am I able to remove a Primary Key be switching out CREATE for DELETE or is there additional syntax needed?

Awesome! Thanks very much, Peter. I appreciate it. It worked great!

I am looking to create a primary key in a macro using RunSql but am having problems with the syntax. The name of my field is "Geo" and the name of my table is "Pre-Deletes". Here is what I came up with so far: CREATE UNIQUE INDEX PrimaryKey ON Pre-Deletes (Geo) Am I missing something?

Is there a place I could get some sample code for this?

Is this relatively simple to do? I am not very proficient in VB.

Hello, I have set up a Macro that automates the file import process for my users. As part of this Macro, it deletes the old file and replaces it with the new imported file. I would like to set something up that warns them before proceeding, such as "Clicking 'Yes' will delete the existing file."...

Sorry, didn't see your reply. Thanks for all your help. Can you recommend a book or something that I can reference when working with advanced queries? I have had to learn this on the fly and it has been tough, to say the least.

Thanks for your help. I am confused as to how I go about setting this up, though. Essentially I need to come out with 7 values in this field. Will the SWITCH function allow me to do this or will it only output one true value and one false value?

Hello, I have been working on a query for a few hours now to create a new field based on data in other fields in my table. Here is the code I am using: MBkt...