Search results

That's just the problem, there is no error. The code just hangs as the 'Microsoft Office Activation Wizard' dialog box is open but invisible and needs to be closed. Hence the only way I know something is wrong is when the code effectively stops and hangs and I then need to go to the TM to...

OK, no worries, I'm looking at the link that The_Doc_Man has given to see whether there is something there I can glean.

So for example, if I want to alter an Excel file and keep the Excel object invisible, this will work on a legit copy. However if the copy isn't legit, then the Microsoft Office Activation Wizard dialog box appears and since the Excel object is invisible, this tops the code from working. So if at...

theDBGuy, surely the end user would simply copy over the BE as well. The_Doc_Man, I didn't think on those lines. I will have a look at the link.

I want to sell a run-time version of an Access db and I want, on opening the db, whether the user has a legit copy or activated copy as certain routines will not work.

If someone has a copy of my MS Access db but does not have an activated version of MS Access, is there any VBA code that would be able to 'read' the 'Activation Required' value on the Files|Account page?

But if the end user copies the db to say 3 different machines from the first copy of the db, he\she would effectively have a Dcount value of 1 i.e. the first MB serial number and therefore end up potentially having more than 3 copies of the db, if you see what I mean?

I want to give an MS Access db to someone who can use the db in no more than 3 machines. How can I achieve this? I have created a table in which the motherboard serial number is inputed when the db is used in a new machine.

I'm guesssing that I need to enumerate the workbooks within the VBS file and to use the additional code to do what I want all in the VBS file. Utimately I am trying to transfer a worksheet from 1 Excel file into a new Excel file. However the end user may not have a fully activated MS Office, so...

Public Sub Close_Microsoft_Office_Activation_Wizard_And_Open_Excel_File(strExcelPath As String, strExcelFile As String, Optional strPassword As String) 'The purpose of this function is to close the Microsoft Office Activation Wizard dialog box if it exists and open strExcelFile. Const...

Is there a way of transferring the thread over?

I am using a vbs file to open two MS Excel files (it's a long story as to why). The two Excel files open OK and I can see them. However when I enumerate through the workbooks, they don't exist. Is this because the Excel files were opened using a VB script? If I open the two MS Excel files in MS...

Thanks Guus2005, I will try that.

I have written the following code:- Dim cmd As New ADODB.Command Set cmd = New ADODB.Command cmd.ActiveConnection = "Provider=sqloledb;Data Source=SQL2008CLS\LEW;Initial Catalog=MedicalLeave;Trusted_Connection=Yes;" cmd.CommandType = adCmdStoredProc cmd.CommandText =...

I am trying to replicate the stored procedure in the adp into the accdb file i.e. in MS Access 2016. I assume that you can still create stored procedures in MS Access 2016?

I am trying to convert a MS access 2002 adp file to a accdb MS Access 2016 file. In the adp file I have a stored procedure, which when opened has the following:- -- ============================================= -- Author: XXXXX XXX -- Create date: 17th August 2011 -- Description: Gets the...

I tried to link the SQL server queries using a dsn (which enabled me to link the SQL server tables). However when I tried this exercise of linking the SQL server queries, I got the error mentioned above.

I did try that, but I got an error message which essentially said that I did not have permission to use CREATE TABLE permission denied.

I have a adp file in ms access 2010. I want to obtain the names of the SQL server queries within the ms access database and then to obtain the sql statements of the queries so that I can create them in a accdb ms access db. In essence I want to convert the adp ms access db to a accdb ms access...

Many thanks