Search results for query: *

just to not be ambiguous, I mean the theme in the access ribbon. I want to have the user be able to set their own theme in runtime mode, but it appears that the ribbon is disabled in the runtime so was hoping that i could code the operation myself. Any ideas?

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.

I found a solution for anyone in the future with the same problem. Just renaming the .accdr file in windows will yeild a .accdb.accdr file. Renaming from a command prompt allows you to change the extension. This is good if you want to be able to modify the database design, but if you don't...

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

Hey I tried that and it appeared to work at first try, but not afterwards. I also tried to do: list.rowsource = list.rowsource list.requery and forms.setfocus list.setfocus list.rowsource = "" list.requery list.rowsource = "qryDestination" list.requery I kept the "qryDestination" open in...

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

where's the recorder for internet explorer?

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

sorry, there's an error above, the comma between links.innertext and links.alsec should be concatenate (&)

it's just weird that for each link in htmldoc.links if link.alsec = "identifier" then msgbox link.innertext, link.alsec end if next produces the correct information while for each link in htmldoc.links if link.alsec = "identifier" then msgbox link.innertext end if next...

i can garantee the text i want is there. If it's not, there are no 'alsec' values of the text i want. you'd think a simple if/then construct would work, but it doesn't. i don't know why it would dispay in a msgbox all the correct text if the '.alsec' property is displayed with it for each...

the text I'm scraping is public domain and not copyrighted, so no worries

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

.. to be complete.. the link object above is an HTMLAnchorElement in the MSHTML library and i got this to work completely fine using the .href property until the ws changed up the format

for instance.. if i use: For Each link In HTMLDoc.links If link.alsec = "identifier" Then msgbox link.innertext End If Next it will msgbox a huge number of links without the alsec property listed at all. But if i use: For Each link In HTMLDoc.links If...

work with the alsec property say this is the format for the link I'm looking for <a href="#" outLink="yes" alsec="identifier" alterm="word i want to get">word i want to get</a> I used to identify this link in code by looping through the links collection, using if/then statement to find the...

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

yea I'm pretty good with vba and am working on using the setwindowpos() api to try and keep an access pop-up form always on top of an ie if you want to check out my other threads :). I'm good with code and actually developed an algorithm using recordsets that will solve this problem. But when...

there are 3 comboboxes and the user can use as many as them as they want. The resulting titles must have all authors in comboboxes that aren't null. so if the user chooses one author he'll get a list of all titles by that one. if the user chooses 3 authors he/she gets a list of all titles by...