Recent content by Mavexe

DoCmd.RunSQL "Insert into TblASSiteRegistration (SiteID,WebsiteID) Select tblASSitesToSubmitTo.SiteID, tblWebsite.WebsiteID from tblASSitesToSubmitTo, tblWebsite where not exists " & _ "(select tblASSIteRegistration.SiteID, tblASSIteRegistration.WebsiteID from tblASSIteRegistration where...

I'm not entirely sure if Access is the same as SQL Server (I use those for all my tables) but typically queries with joins in them are not editable. What I have to do to have aggregate information in editable queries is write subqueries. So I'll have Select A,B,C,D, (Select SUM(E) from...

What are you trying to do? The current code looked fine, except you need to put a closing double quote on the end. Perhaps add a .Value to StrLOB

In the AfterUpdate event of the tables form put in code that goes like this: Assuming RegId is an autonumber If Me.Newrecord Then Docmd.RunSQL "Insert into Registration (WebsiteID, SiteID) Select " & Me.WebsiteID & " SiteID a from site where not exists (Select WebsiteID, SiteID from sites as b...

Greetings! I use an Access Data Project with a SQL Server backend. I have 50 users total, speed is a necessity. I'm working on a retrofit for this database that will incorporate form meta data into a separate portion of the application so that admins can make minute changes to control...

Greetings, I've been lurking here for years as it's a great source of information for previous problems I've had, however I'm running into one that seems to be killing me. I've been tasked with designing an Import Mechanism for some excel files we receive. Basically what I have to do...