Search results

That's good to know for the future. Thanks for letting me know! Always good to learn something new.

Adding those two to the Windows Registry did the trick. Thanks a bunch, @Gasman!!! For anyone needing to do the same there steps are: Run Regedit from windows search Look for "Access\Menu Add-Ins\&Dependency Checker". Just searching for "Menu Add-Ins"; From the menu bar Edit >> Find. From the...

@Gasman, thanks for the quick response! Looks like that "=startAddIn()" expression was the thing that the error message was referring to. And other 'parts' are missing too on my end. Will post back on how it goes once I figure out how to add those to the registry.

@Gasman, would you mind sharing what's in the Windows Registry for you for the two Menu Add-In keys (not sure of the terminology): - @Add-In Manager - @Dependency Checker I don't have much under 'Dependency Checker', which might be part of the issue. I did email the creator but I suspect it...

The_Doc_Man, thanks for the suggestion. Not sure that's an option since this is a work laptop and they like us to keep it updated. But I'll see if that's something that I could do. I'm guessing not due to our IT security policy. IT took a look at it but ultimately said it's not something that...

Haha, guess I should have said expensive. For me it's worth it. I've thrown out my back twice in the past few years. Last year, I had to take almost 2 months off from work and several weeks of physical therapy. Considering the amount of spend more time in my office chair, it makes it worth...

Gasman, thanks for giving it a try. I'm still stumped as to why it's not working on my laptop after the Windows update. I may have to try to figure out what's going on with the Windows registry. I'll be sure to post back if I manage to fix this.

I'm partial to Steelcase chairs like the Leap or Amia. However, they are pricey. I plan to get one because I have had back issues, so a good chair makes a big difference for me.

I've been using an Access Dependency Checker Add-In (http://www.accessdependencychecker.com/index.php?page=download) and it's worked fine for me. But after I updated Windows earlier this week, I can't get it to run/install. Previously, I needed to select "Run as Administrator" when...

Wow, someone remembers me! :D Yeah, I've been poking my head in a few times recently. Started working on stuff using Access. I just decided it might be nice to learn some magic. Always wanted to know how card stuff was done. Though it's maddening frustrating trying to learn the moves. Still...

Anyone here do magic? I recently decided to try to learn some card tricks. Still haven't learned how to the beginner moves, but I'm familiar with some of them. Would love to learn some cardistry but don't know if I have the determination for that. Just curious if anyone else here knows or is...

Well, the best thing I could think of so far is to add code to set the starting autonumber for all tables in each copy via code and use the following DDL SQL: ALTER TABLE [Main_Parent] ALTER COLUMN [M_P_ID] COUNTER (100000,1) Each copy isn't going to have too many records so setting the...

Thank you for the reply! That could workable for the issue for appending autonumber data, but I don't think that will work since the M_P_ID is used as a foreign key within the main database copy and I'd still need to maintain those relationships between the 'source' file which mirrors the...

Thank you for your reply! I'll have to look into that. Never used TranserText before.

Yes, you're correct. It's not the WITH/END WITH block since other code within it is working. I still haven't had time to test changing .EntireRow.Delete to .Delete yet. The entire code takes about a long time to run so I just fixed the data manually for now since I needed to have it quick, and...

What I'm trying to accomplish is to append data from another file into a file with the same table structure. There are some problems that I can see at the moment: Autonumber fields as primary keys/unique indexes could cause problems with duplicates Data must be appended on 'one-side' (parent)...

Mark, Thanks for the reply! That was going to be my next move if I can't figure out why I get the error. Someone else told me to try changing it to this. .Rows(i & ":" & iEnd).Delete I'll test that as post back in case it helps someone else too.

I have a simple delete code line that gives me a 1004 error (Delete method of Range class failed), BUT the rows are deleted! The error causes the remaining code not to execute because of the error handling code I have which give a msgbox explaining that an error code occurred the exits. Any...

Gemma/Dave, Wish I could tell you more but I've never dealt with XML before so I don't know exactly what is is going on. Other that what I posted there's no other usage of the oDoc object. I have been adding othter code to the vile, and it wouldn't compile because of that eDoc declaration. And...

I think I managed to fix it by changing Dim wrt As MXXMLWriter40 Dim atrs As New SAXAttributes30 to Dim wrt As MSXML2.MXXMLWriter60 Dim atrs As New MSXML2.SAXAttributes60 And commenting out 'Dim oDoc As DOMDocument ... 'Set oDoc = Nothing