Search results

I have it on form load that it goes through all records and move the caret to the end of string in that textbox. But the problem is that when you leave the textbox / lost focus, it resets the scrollbar to the top. I hope you know what I mean now.

Hello I have a request from a client, which wants to have one textbox on a continuous form always on the last line, which is the most important. I got it to go to last line when it gets focus, but I don't know how could I do it so on form load, that textbox on all records go to last line, if...

Yeah I got it sorted out, I just place a "!" in the calculated field, and then format it on the form, simple but it works :P

Yeah I got that, but that would enable the icon on every record on a continuous form, wouldn't it?

Yeah I got that already, i guess you can't do what I wanted. Anyway thanks will use this.

Hello I'm currently building a database and one of the things that I must make is a "warning", more like a symbol on a continuous form, that is there, if the task is wanted by a costumer. I have a Yes/No field in database, which decides that. Now I need to figure out how to make it appear on...

So there is no way you can choose either file or dir in the same dialog?

Yeah, I think you understood me wrong. I have a button that adds or opens, depends if link is already added, link. I have the command button, but from how I understand that code, I would have to ask the user if he wants to add a file or directory. That would mean that when he would click that...

Thanks for the reply. If I understand this correctly, I would need to ask the user via form, if he wants to pick files or folders. I kinda don't like that idea, but if there is no other way, I guess it will have to do. Thanks anyway

Yeah I know about that, but I want the user to be able to pick a dir in the dialog. Sometimes he will add a file, sometimes a whole dir, if you get what I'm trying to say. I don't know when I have to use the dir and when the whole path.

Hello, me again :P In my task database, coworker wants to be able to link a file (report,...) to a task, when its completed. I already got it all set up for adding, also got it working to add a link to one file. Here is the catch, right now I am using this: Public Function FileSelection() As...

Never mind, the solution below worked fine, without anything else needed.

One question, kinda off-topic, kinda not If I have a string "11/8/2015" and I put it in the format(here,"long date"), will it work? And the other thing, I have dates in my table saved by the UK standard, will searching using US standard actually work? Anyway, for now I'll just google the...

The problem is, that I have start and end of week declared as strings, if you can see in the code how i get them. Unless if VBA automaticly changes from string to date when you have format "dd/mm/yyyy", then this wont work :/

Okay, I'll try that, Thanks

I just did it by hand; where I calculate start and end of week i just switched the day and month. But it's really wierd becouse it does it for only one date. If I switch them around, the one that was working before now doesnt and vice versa.

Update: So I tried to switch the dates (position in the sentence) around to see if the problem goes away for some reason, only to find out that it's still affecting the date, altho now StartOfWeek displays properly, EndOfWeek gets the date switched. I thought that I would just switch the...

Hello A while ago I made a search in Access form, that works on changing the recordsource. Don't ask me why I did it that way, but now I just want to stick with it. The solution worked great, but now, it doesn't anymore. After some debugging, I figured out the problem. Let's say we have...

I think this may work. Thank you very much, I'll post if i succeed.

Hmm, can you kinda point me into the right direction about the various groups in a report?