Search results

Thanks but no, Eval doesn't work for this. Eval only returns strings or numbers, not objects. To clarify (sometimes I suck at explaining) I have several recordsets declared as public: rs_Char1, rs_Char2, rsChar3, etc. I have a counter that runs 1 through 12. I obviously can easily build the...

Is there I can use a built string to refer to an existing recordset object? For example, I build a string "rs_Char4" I need to be able to associate that string with an existing recordset object (.OpenRecordset, .MoveNext, .Close, etc) I've built a function which has a parameter "rsToManage as...

The reason I ask is it really is NOT recommended to store attachments in the database. Get's REALLY big REALLY fast.

Please define what you mean by "upload" and "download." Upload from where and to where? Download from where and to where? Are these download attachments contained in the database or do they live as files on a share? When you want attachments to be uploaded, are you inserting them in the...

I have an Access 2013 database I’ve built to assist managing membership for our club. Currently, all tables (not large) are contained in the same database as the front-end forms. Ultimately, this database will need to function on multiple laptops and/or tables so I’ve always known and planned...

In your code, a great quick test BTW, I'm thinking the formatting changes are applied to an object in memory and then the object is closed before it is saved thus losing the changes?

I wonder if you're losing it when the frm object is closed? Maybe try this? Private Sub test() DoCmd.OpenForm FormName:="yourFormName", view:=acDesign Call AddFormats("yourFormName"!yourFormattedTextboxName, "yourFormName") DoCmd.Close acForm, "yourFormName", acSaveYes End Sub

Are you opening your form in acDesign view? I don't think formatting changes initiated during runtime can be saved unless the form is opened in acDesign and then saved. If I get a chance later today I'll do some testing on this.

In your screen shot, there is no reference check for the Microsoft Outlook (16.0) Object Library.

Ok, there is clearly something we're not seeing in other code somewhere. I just pasted that EXACT code (directly copy pasted from your last post) in a blank sub in a clean Access Module and set the proper Outlook reference and it runs perfectly. NO ERRORS Try this. Create a blank, clean, fresh...

Can you please post the full current code you have?

That error means it isn't seeing the Outlook Library. Check your project's references. Tools > References Look first to see if there is a listing for: Microsoft Office (version) Object Library (MISSING) If there is, it'll be near t the top. If there is, make note of the version number 12.0 =...

Just an idea, but check your project's references and see if the Outlook reference is missing. Running Access code in a mixed environment can be problematic as the libraries will generally (but not always) update forward but will not update backwards. Also, just curious why you're not being...

COOL! So, I need a function then that would calculate the load times based on quads 2 through 6. Either concatenating them in one string or with a second parameter to designate the quad to be calculated. If anybody has a sample function to work on even a single quad, I could easily take it from...

I appreciate your interest here, but would you mind elaborating on your guess? Incidentally, the keys are all "REG_BINARY"

A HUGE "E" FOR EFFORT AND I SUPER APPRECAITE YOUR TIME AND INTEREST! I'm in an extremely large enterprise. I can't say where but as the Office SME I track >345,000 Office clients globally. We're migrating to Office 2016 from Office 2010 and some very vocal groups are complaining about Outlook...

Thanks! I tried searching twice and didn't find anything that seemed applicable to this. Do you have any specific links to a thread?

ROFLAMO! That was my first impression of my first calculated result: Unless this add-in has been loading since the Big Bang, it can't possibly be correct! However, as I look at the parsing data from all the records, it seems possible, if not highly likely, the 1st pair is some sort of...

Initially, I thought I noticed the quads as well (initial single pair followed by 3 sets of 00). However, I did find (initially) at least one key value with at least one non-00 second pair. This morning, pursuant to your interest along this track, I went into the data (I have 985,635 records)...

I don't have handy any actual custom Outlook add-ins, but I have a crap load of various Excel custom add-ins which I wrote and for which I am 100% certain I didn't write any code to track load time and/or add/update any key values. So, I confirmed a specific Excel add-in was NOT shown in the...