Search results for query: *

Anyone have any idea how to set access themes using VBA? Just switching to another default theme would be a start. I've found where they are located (ie. currentproject.resources) but can't seem to find how to switch a theme with code.

Hi everyone I used the package solution wizard to convert an access 2010 .accdb file into an .accdr file. A lot of data was changed in the runtime app and now I want to modify the design of the database without losing that data, so I need to convert it back to an accdb file. Any clue on how...

Big ups to this site. It's by far the most useful resource I've found for professionals. Just sayin' thanks everyone CN

Hi everyone I'm having a problem with automated a simple requery procedure on a list box on an access form. The problem lies in that I'm requerying this form from a VBA module in another application, not directly from the access application. The sub in that module performs an ADO recordset...

I've got a relatively simple question: how do you select an internet explorer tab using vba? for instance code: For Each appWindow in appShell.Windows If TypeName(appWindow.Document) = "HTMLDocument" Then Set appie = appWindow If appie.LocationURL =...

hi everyone I posted a thread on a weird html property called alsec that doesn't seem to respond to VB if/then like it should. Didn't get any responses so thought I'd try posting it in a more specific forum to the issue: http://www.tek-tips.com/viewthread.cfm?qid=1657520&page=1 thx for your...

hey everyone, i have an access module that identifies terms that are links on a website and loads them into my database. however, the website recently changed up the source code so i can no long find those terms in the links collection, where the identifier was just the .href property. The...

alright so here's a simpler problem that hopefully someone can answer: I have a titles to authors many to many relationship and a qry that selects as such: select ID, Title, MM.AuthorFK, Author ORDER BY title so brings up a blocks of a title in the query with a line for each author in the...

Hi everyone, I have a problem with an API I'm using. I have an access pop-up form that I want to always be on top of an internet explorer. I'm using the following API: http://msdn.microsoft.com/en-us/library/ms633545(v=VS.85).aspx but I cannot get the access pop-up to stay always above the...

hi Can't seem to figure out how to easily add an attachment to a record's attachment field using ADO. For some reason there's a lot of documentation on using DAO, but not ADO. I just want to do something very simple, automate selecting a file on a harddrive thus adding it to the recordset...

the HTML DOM says that there are two ways of accessing anchor elements in an HTML document. 1) .getElementsByID and 2) cycling through the HTMLDoc.anchors iHTML collection. Using VBA, I'm trying to write code that will click an anchor (a "a" element right?) given certain conditions and I can't...

the HTML DOM says that there are two ways of accessing anchor elements in an HTML document. 1) .getElementsByID and 2) cycling through the HTMLDoc.anchors iHTML collection. Using VBA, I'm trying to write code that will click an anchor (a "a" element right?) given certain conditions and I can't...

API's quite frankly are confusing to me and are pretty much like magic in how they work to me. Anyhow, I've managed to use one to designate an access form as the top-most window; this one is strait from microsoft: [code] Declare Function SetWindowPos Lib "user32" (ByVal hwnd As Long, _...

hi does anyone know how to instantiate an acrobat reader document that's open in internet explorer? I just want to grab it and save it with VBA. Any ideas CN

Hi everyone Here's a dilemma I've been having: I have a public VBA automation module that holds information in a bunch of temporary variables that I want to import into a master data entry form. It doesn't use recordsets directly manipulating tables because I want the user to be able to see...