Search results

EA's reliable and easy to setup for mail in & out including Gmail. Unlimited free use for "testing/demo/evaluation" purposes.

Here's a simple analog clock I put together, to see if I could. Access doesn't make it easy to do anything "drawing-like" on forms so we have to get a little sneaky -- but this is drawn without ActiveX or API's. There's one lil' API call to add the mandatory "Tick" sound... which isn't...

Nonactive as in disabled? or empty?

Bizarre, someone just told me the same thing a couple hours ago... like, word for word as your post. Uh oh, you're behind it all then, aren't you??

"Honest, I didn't just spend an hour on this..." Either I'm a fan of a certain site and a certain show, or else I've been single for waaay too long... or both. (The zip has all the fixin's in case someone else also has apparent excess time, and a better image editor than mine, MSPaint)...

Am I mistaken or wouldn't the problem be the placement of the with/end? Because this: With dictA dictA.compare = vbTextCompare do while not rstMeta.EOF "some code that searches for the matching column in xlSht...." .add rstMeta!MetaValue, Split(xlSht.Cells(x, y).ADDRESS...

...or [ISSUE DATE]A quick way to see if that's the problem is, repmove the whole expression and replace it with only [Programme], and run the query. After that try running it with only [ISSUE DATE]+364 and see if that gives an error. And, perhaps a screen shot or two would help, showind both...

You say "linked with another table" -- is this expression in a table/query/form?

What a great starter database! -- it could be as simple or as complex as you would like, and is almost guaranteed to be a continuing work-in-progress! Indeed your question can be interpreted a few ways; my first thought was programmatically listing connected/network printers like this, that's a...

You could use a Public variable to pass information between different forms. You're close with your 2nd example. In a module, at the top, enter: Public datDateAuto as Datethen in Form B use: datDateAuto = workdays.....(like you are), and in Form A (or anywhere else) you can retrieve the value...

Sorry, it was me getting off-topic, not you! I've started a different thread re: listing/comparing controls. So the combo box is not finished updating because you haven't left the control yet? Without seeing it myself, perhaps you may need to use an onchange event? ...Or, how are you...

[I was getting off topic on another thread so I'll finish 'er up here.] I tried, but I guess listing "all available ActiveX controls" isn't easily possible. I hoped there was a hidden collection I could enumerate, but closest I found are in C, or else there are limited registry calls one...

I had assumed this was for a standalone DB, but if not, surely there is an alternative video player that's a standard part of Office? I've also got a Windows Media Player control... is that not on yours either? I know I've never intentionally installed anything specifically related to WMP...

[Sry if it's not the correct forum -- Just recommending a utility I use constantly that other frequent Firefox users might find useful too.] I use Firefox on multiple computers & devices... When coding, shopping, streaming, forum'ing, etc etc, I'll want to "put this on that device"; maybe...

Good question... You don't have to. I quickly slapped that example together and shared it as "something that functions". I spent some time since then looking for documentation on the plugin and there's amazingly little, and anything from 'official' sources is labelled "out of date and...

It's a wonder that code played at all! ;) Once I took out the duplicates and commented-out lines (and C++ //comments?), there's about five lines of code; Maybe you mis-pasted? Anyhow you did peak my curiosity, and there's limited documentation from VideoLAN on plugins (other than for web...

One problem with learning-by-Googling is that the more time passes, the more out-of-date so much coding-related posts are. Often I can work around it, but often I've given up. Access doesn't like to open "old" MDB's anymore. In this case I'd like to open this oldie from ChrisO (man, that guy...

The database can't be lying. ;) The path it's returning for for any of these should be the same, and is exactly where the .accdb file is sitting: ?CurrentProject.Path ?Left(CurrentDb.Name, InStrRev(CurrentDb.Name, "\")) ?CurrentProject.AccessConnectionPaste those lines into the [CTRL+G]...

Lifetime limit? I see only a couple references to a limit on "reputable" sites: ...but that's just not true! Yesterday I was specifically testing how far I could push it and got a "too many controls" error at around 850 on the form at once, so I set my "max" to 800 and added & deleted...

I was actually just looking at that post of ChrisO's last night but I guess I got sidetracked by other posts about him before I made it to the attachment. Brilliant! - great suggestions thanks, those will keep me busy for a while!