Search results

I appreciate the comments! I also like to discuss and understand the pros and cons of the different methods. And, who knows, when i present it to the user tomorrow (this change is mostly for just one user right now), things might go wrong, and i might end up using your solution instead. :)...

Because i'm quite the newb here, and beginning to work on someone else's project. I'm asking to make sure i'm not doing something stupid. Also, even solutions i don't take still teach me useful things!

@CJ_London, i'm sure your solution works, but i feel that my solution is easier. There's just so many steps in your solution. @isladogs solution seems more elegant, but, as i said, it seems confusing, and i already have something working. If i revisit this, i would likely try his solution again...

I'm way too tired to appreciate that comment right now. :) Especially while working on someone else's project right now. But i do have to ask. Do you think this is easier than the solution i posted originally?

I indeed did skim the article. I logged out of work for the day, so i didn't feel like going to in depth right now. By "confusing" i did not mean it was hard to understand, rather, that it is backwards, in that the forecolor refers to the default, and the color specified by the default is the...

Then i'm doing something wrong, but i do not know what. Missed that, oops! That's backwards and confusing, but if it works, it works. Thank you. Nope. I wasn't sure what it was addressing because it spoke of color. I see the part you were referring to now though. I may try this later, but...

Well, that became .0007, and the default text did show up! However, now after the name of the doctor is chosen from the list part, the top shows the id instead of the name. Also, can this show gray instead of black?

This does not work for me. What am i missing?

Don't be sorry. If i'm wrong, i'm wrong, and i want to be corrected. How else will i learn? I tried it simple by connecting it to a query and it did not work. If there are rules, so be it, but it does not seem to work in my case. I'm happy to change things if it is easier than what i did and...

From searching and trying i saw that comboboxes do not support the format field in that way. That was the first thing i tried. Okay, so trying again. I created a combobox and added that format property and it worked. I changed rowsource type to value list, and added "a" as a value, and it still...

My mistake. I apologize, and thank you for correcting me. I meant they get their data from a query. That's why i used the word "bound" without thinking it through. I'll correct the first post right now.

The comboboxes are used as parameters in the form query which gets refreshed when they lose focus. So, no saving here.

It's in its own unbound combobox.

It seems to be working. The default is not in the list. It is a text, "Search Facility", for example.

I didn't realize that would be an issue. I just set a second combobox to act the same way, and it worked on testing as well. However, clicking both causes the second one to give me an error about it having focus. Good catch! I just changed the code to put the Visible line second and the issue...

Just thought i'd share and perhaps even ask for comment. I am beginning to work on someone else's Access program and have a lot to learn. Anyway, the request was to remove the label from a couple comboboxes and place default text in them instead. After some searching it seems this cannot be...

Okay, that did not actually work for the async sub. As soon as await was hit, vba exited, and the vb.net thread died. So, i put a doevents/sleep and looped on a flag set in the event handler. Here's an example vb.net dll: Imports System.Runtime.InteropServices...

I found the answer elsewhere. Instead of awaiting the reply, the dll can raise an event that vba can handle. It just requires declaring IDEventInterface/_IDEventInterface so vba can see it.

Iiuc, the thread returns. But with nothing waiting for it. it drops the return into the nether. Perhaps that isn't the best method then. :)

I never touched it in the first place. Not interested at all. Only place that ever got me was GeoCities, but the chatrooms were fun back then. :)