Search results

I looked at the attached file and it worked alright to me. It may look to be jumping around but that same record is still highlighted. The reason why it looks like jumping is because your listbox can only show that many records at once. After you scroll the listbox up or down to hide the...

Utilize the Search feature, it's very helpful. Try search under Shift.

You said this: Now I know what you meant, the last edited record, not the last record of the list. That's can be easily changed. More mods added to your cmdOk_Click and EnableAll subs.

Agree 100% with Ken. Reading this gave me a headache, it's like going thru a maze.

Solution Found Glad I found a solution. I modified your EnableAll function. See attached zip file.

Greetings to all the experts out there, Here is something I wonder if it has already existed or been asked before, a program or an add-in feature that can compile an Access database (including forms, reports, tables...) to a stand-alone .exe application, just like Visual Basic does. The reason...

That is because if the user doesn't type anything in the textbox and continues on to the next control, the second sub (txtCheckedBy_AfterUpdate) will not be called. To fix this, move your "if - then" statement in the second sub to the next control's AfterUpdate sub, like, let's say the user...

You will have to explain more. What are being stored in your Fields, just numbers? It sounds like Field4 has many 1s and 7s and you want a total count of 1s + 7s in Field4 to be stored in Field1. Where do the Field2 and 3 come in?

I don't know about others but I'm confused of your description. You have one listbox and one textbox. Will the listbox have more than "1" date? If it has "only" 1 date then you don't need it. One textbox should be enough. If it has more than "1" date, the date that you want calculated will...

Thanks to those who responded. Here is another challenge that's in addition to the original request. Now that I can see whether a certain database is in use by another user, is it possible to tell remotely the machine name or username of that machine? I can retrieve my machine and username...

I already know that it will create a locking file but how would I go about checking for the existing of that file? Everybody can benefit from this. How about when you want to open an Access database then later fnd out that somebody is using it? If you know ahead of time (status), you won't...

Hello all, I've already run searches on this but found nothing exactly matched. Here is the situation that hopefully you guys, experts, can help. I have several databases and on the main one (master one), I want to be able to show status of other databases, whether they are in use (meaning...

More info please... What kind of connection are you using (i.e. data source, link table, import...)?

Example please... Can you post your example database for us to see?

No queries needed - Should use something like this. Hope this'll help. Assuming you named your country choice list box and postal code text box as lstCountry and txtZipCode respectively. Here is the code that I'd use: Public Sub lstCountry_AfterUpdate() If lstCountry = "Canada" Then...