Search results

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?

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 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...

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 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...

I have a field where I want to replace specific values to a different value as part of an Encryption process. I then want to Decrypt the data back to what it was. Hence if I have say the following data which forms a part number of a product yEr456 I want to Encrypt this so that I end up with...

Does anyone have any VBA code to be used in Excel that loops through say 5 open Access db's and enables me to close a specific one?

I have the following snippet of code which works if strAccumulateHazards does not contain any apostrophe's. However if it does then I get an error in strSQL below. How do I amend the code to prevent such an error? Set rstAccumulateHazards = CurrentDb.OpenRecordset("tblTemp4"...

How would I change the code below if I created a function where I had to pass the value of C:\Test.pdf? varShell = Shell("C:\Program Files (x86)\Adobe\Acrobat Reader DC\Reader\AcroRd32.exe /A page=3 ""C:\Test.pdf""", vbNormalFocus)

Does anyone have any code that will allow 2 pdf files to be merged using either Shell or ShellExecute?

Does anyone have any VBA code that will print specific number of pages to a pdf printer. I have tried the following to print page 1 only, but it doesn't work. Application.PrintOut Range:=wdPrintFromTo, From:="1", To:="1"

Does anyone have any code that will merges 2 pdf files creating using WIN2PDF? I have the following 2 files:- SaveSetting "Dane Prairie Systems", "Win2PDF", "PDFFileName", "L:\Renewals workbook\ABC Limited - Renewal - 2018.05.18.pdf" SaveSetting "Dane Prairie Systems", "Win2PDF"...

Assalaamu Aleykum Insha-allaah I will post random verses of the Qur'an as and when time permits. And whoever turns away from My remembrance - indeed, he will have a depressed life, and We will gather him on the Day of Resurrection blind." He will say, "My Lord, why have you raised me blind...

At the company I work for I can't change the registry or download any third party software. In sending an email using outlook VBA code I want to add code that will disable or press the button on the outlook warning message. I don't it's possible but thought I would ask.

How do I create a numeric field in a make table query where the default value is 0.00?

I have never used or run a stored procedure before so hence I'm really stuck. All I have is an ORACLE expert who has given me the following cryptic clue Can anyone give a simple step by step guide what to do? Thanks in advance.

Using DoCmd.TransferText acExportDelim, "tbl001 MRHDATA Export Specification", "qryTemp", strFolder & strFilename, False I have the following header record. H,PRODMASTFULL,4,2017-04-19 15:16:00,PRODUCT MASTER FULL,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, How do I get rid of the...

I have the following snippet of code objExcelAppOriginal.ActiveWorkbook.Sheets(strWorksheet).Protect Password:=strPassword, DrawingObjects:=True, Contents:=True, Scenarios:=True, AllowFormattingCells:=True, AllowFormattingColumns:=True, AllowFiltering:=True and With objExcelAppOriginal...

Using VBA, how do I dynamically find the filepath and filename of a picture on a command button. I want to change the picture when cmdGo is pressed. The pictures are the ones that appear on the list when you create the button and can be accessed by the Picture property. Note each user may have...

I have two email addresses in Outlook and I am trying to write code that will tell what these two email addresses are. However when I use the following code it only recognizes one email address. Public Function OutlookAccounts() As Integer Dim OutApp As Outlook.Application Dim i As...