Search results

Well, that code uses the same GoToRecord command as my code and that is the line I'm having trouble with. I think the issue is because of the fact that I'm trying to run this code from Form A to access the subform on Form B. When I have this code on Form B it works great with the subform in Form...

Tried that with no success. :( Nope, it would be in the middle of several records, like this: Row1 Row2 Row3 Row4 Row5 Row6 Where I wanted to delete Row4 and then it would move the cursor to Row 5 like this: Row1 Row2 Row3 Row5 Row6

No ideas? :(

I'm experiencing a problem that would make me pull my hair out if I had any. I have a form that displays records (FOB's) in a subform datasheet. I have code setup so when I push "ctrl-d" it runs some delete code which in turn opens another form that forces you to select a different FOB to assign...

nm, I'm stupid. It was being reset in a section of code that I ignored.

I have been running into this weird problem on a database that I have been working on where when I close the database it doesn't always release all of the variables. It doesn't make any sense to me, nor does it seem possible but it is happening. Has anyone experienced anything like this before...

Thanks to both of you! I wasn't trying to exactly the same thing but your code helped me figure out my issue. :)

I just found this article in my search to do the same thing, it might help you too. http://support.microsoft.com/default.aspx?scid=kb;en-us;210285&Product=acc2000

Okay, I have some code that will do what you want but I am about to leave work. If I remember I will try and get an example posted this weekend. I actually got the code of this website, I can't remember what I searched on though. Maybe someone else can help.

I think this is what you are trying to do. Take a look at this database, I added the search button with the corresponding code and modified the record selection buttons. I didn't know if you were going to want them to search by partial numbers or not so I have both options available. I have I...

I am unsure of what your actual question is, is there a specific part of the search process that you are having a problem with or do you not know how to do it at all?

once again AW forums comes through for me, thanks for the help

After digging around here and modifying some of the code I found, I wrote this simple little function to auto capitalize all of the fields on a form. It's pretty simple and I am sure that it has already been done but I thought it might help someone else out that is trying to do the same thing...

Wow, that is really easy. Thanks a bunch!

Thanks Jack!

Basically what I am trying to do is setup a listbox that allows multi select (done) with a button, "Select All" that would select every record in the listbox (not done). Has anyone had any experience with something like this? Thanks in advance for the help! Caleb