Search results

Depending on the situation, I'll sometimes go with something similar (but easier to work with than the built-in bars), a small square popup form, unsizable, always on top, no Min/Max/Close buttons.As the user moves around the application, relevant icons are shown or hidden, to give a...

Welcome George! I just joined a day ago but this site is kind of addictive and I'm learning (and re-learning) so much. I credit Google (and forums like this site) with 100% of my Access/VBA/SQL Server training. Pretty much any question I have, a hundred people have asked it somewhere before...

Since you already have a list of image locations, you could quickly produce a nice and customizable result by writing directly to Web Browser Control, sized as large as your form: Private Sub Form_Load() wb1.Navigate "about:blank" End Sub Private Sub btnShowAlbum() dim rs as...

If you already have a list of picture locations (local or URL would do), then a web browser control could do a nice job of it. Just loop through the list and write directly to the window: Private Sub Form_Load() wb1.Navigate "about:blank" End Sub Private Sub btnShowAlbum() dim rs...

Hi again, So, maybe I've been staring at the screen way too much this week on my marathon-Access&VBA-refresher, but I can't find anywhere on this site to set options like default fonts, signature, etc, for my posts, nor can I find any option to privately contact other members. I've been to...

Hi liddlem, Is there a reason you need to create the form programmatically? Controls can only be added to a form in Design View, which might be easiest manually: Right-click the forms' background for options to display the header or footer sections. Then on the ribbon at the top of the...

Oh oh, I might be the reason for your crashing earlier - You should probably at this to the very end of that sub: Set oXL = nothingYou might wanna hit your CTRL+ALT+DEL and kill all the extra copies of Excel running in the background... Sorry about that! I was just about to say that it's no...

Some older versions will throw that error as an (annoying) general "something went wrong", like if the Excel file isn't closed properly when you run the TransferSpreadsheet, or an improper OLEDB installation, or silly connection string problems, and it was a known issue with TransferSpreadsheet...

This clears the contents from a range of cells (or a whole worksheet) and leaves formatting intact: Sub ClearValuesFromWorksheet() Dim oXL As Object, wb As Object, ws As Object Set oXL = CreateObject("Excel.Application") Set wb = oXL.Workbooks.Open("yourfilename.xls") Set ws =...

[Edit: Woah, that was a HUGE font... It's my first reply here; still kinda gettin' used to the place,lol] Access gets finicky when exporting to the same Excel sheet more than once, especially if someone's messed with it since the last time. There are more reliable ways of getting data into...

Can you share some more details? "Update" is a pretty vague term around here. ;) You're trying to update what from what? Are you trying to get data from an Access table into an Excel worksheet? Is this something that needs to run automatically, or one time, or have a constant link?

@ridders I created an account just because it was imperative for me to thank you for this post. I've been researching & experimenting for a week, trying to get some control over the Access window and such, and you have so much good stuff summed up in one place! (I know not all the code is...

Posts on this site come up often when I'm searching for a way to "do something", some things simple, some not so simple -- like today's. Actually I've a week searching and experimenting with way to control the Access Window and other system functions with VBA, and I found a crapload of awesome...