Search results

I'm 99.999% certain Outlook writes these values itself on AppOpen.

WOW!!! Bearing mind we don't have the luxury of working directly from the key's actual value, if it helps for any other purpose, the keys can be found at: HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Outlook\AddInLoadTimes\

It's obviously not the actual value but I'm sure you calculated it as shown correctly. Clearly there is some missing piece of the process to successfully derive the actual load time but absent some insight from Microsoft on that sequencing, I think we're out of gas. I really appreciate your...

Load time should be in seconds and decimals of seconds. For example, 3.456734

Thanks! Well, your calculated result confirms something I was afraid of. The structure sequence has to be different than shown. That value above can't possibly be an accurate add-in load time. Likely, there is some internal, proprietary Microsoft utilization going on.

I was thinking it looked like both, hex in binary. Meaning the binary values are stored in hex. Is that what you mean, and if so, would that mean I'd first need to convert each pair from Hex to binary and then convert those to decimal? If not, I'm afraid I'm off in the weeds? Can you...

HI All! Long time no see. I hope everyone has been well and fine. I find myself needed help creating a custom VBA function in Access (2016). I need to convert the add-in load time values stored as binary registry keys in the registry to decimal values. A few sample values look like this: 05 00...

Seriously? The two tables have ENTIRELY DIFFERENT DATA and an unknown number of fields to each record. While the max num of fields on one table is usually 85, it is not always so, sometime less and could at somepoint be more. AND THE FIELD HEADINGS ARE ALWAYS DIFFERENT for the two datasets and...

...And need to add a reference to the Access Object Library in Excel's VBE.

um, because that's MUCH more tedious than just using the code provided above.

From what application do you want to create this access object? If all you need is data, why don't you just create an ADODB connection to it and then run your queries or pull your recordset through that connection? I notice in the code you listed you're trying to create an ADODB recordset but...

aryanaveen, you need to run sneuberg's code from a module in ACCESS, not Excel.

I suspect the OP may be running this code from Excel...

I have two tables, both with identical structure but different contents. 153 Total fields each 710 records in one and 791 records in the other. Field 0 = RecordID = AutoNumber Field 1 = File_Date = Date/Time Fields 2 through 152 are all memo fields Field 153 is "File_Name" = text I created...

hmmm, I'm not sure installing Word vs. setting up a SQL Server are directly analogous but I assume you know more than do I. However, during the SQL Server setup process there actually is a step, before the problematic step, where the shared features locations are specified and defined: Setting...

Hi and thanks for your time! Help me cause I think I must be misunderstanding but aren't all network drives by definition "remote"? I've been reading and re-reading this page: https://msdn.microsoft.com/en-us/library/ms143506(v=sql.110).aspx#storagetypes Near the top is says: •SQL Server...

I am using Microsoft Server Manager 2012 on a VM. I am able to create a server on the VM's local C:\ However, I am now trying to create a new server on a network share. when I get to the "Instance Configuration" step, I enter the path. I receive the error: The path...

I found some code that fixed it:CommandBars("Property Sheet").Enabled = True

https://support.office.microsoft.com/en-us/article/Create-a-grouped-or-summary-report-6a58e9ab-9f74-4689-83b6-c63cddb2c7f9?CorrelationId=4eae1d0e-3f05-476d-90a7-47242ac79c36&ui=en-US&rs=en-US&ad=US http://www.brainbell.com/tutorials/ms-office/Access_2003/Understanding_Report_Sections.htm

Ok, I'm embarrased to admit this, but I am stumped. I cannot get the object properties window to appear in Access 2010 (x86) running in Windows 7 (x64). I select an object (lable, button, text box, etc), right-click and select "Properties" and nothing. In the "Design" section of the "Form...