Search results

The code is firing, I put the following code in front of the search itself: MsgBox me.txtIDFind, 0 And it returned the appropriate ID that I am asking it to search for. Was that a proper breakpoint for that code or should I have done something else? KJ

Still doesnt work. I hit the 'Find' button and nothing...not even a runtime or syntax error or something like that.

Yes, I believe that is what has happened with those two forms. While we are on the subject, I have a 3rd form that instead of having a list box and a dblclick event, I have a unbound text box on the form with code behind a command button to search for the ID and thus populate the actual...

Thank you, I think I have found the issue. You had mentioned the Filter and so I looked at the entry in that line of the property and it was something like [ID] = "13" or something, well the database doesnt have that ID, once I removed it and the code in the on open that called for a new record...

Yeah, the same thing is happening, only this time I have the form with the Data Entry control as 'No'. The form has Tabs on it with different sections and the second tab is fields from a different table which is in a one to one relationship with the ID field (dont know if that makes a...

I have another similar issue with a search form for a different table, this time it is my employees form that I would like to populate the information based on a list boxes dbl click event. I have the Employee Details form Data Entry as No, and the appropriate column bound (is it the column of...

Ok, when I test the code provided I get a Compile Error stating as follows: User Defined Type Not Defined Suggestions? KJ

Thank you, I am going to try implementing that now, I will post back when I have a verdict one way or another on my abilities to follow directions...lol KJ

Awesome, just one quick question, where do I put the code you posted (2nd Option)? I imagine on the textbox itself, and possibly on the load event. I am not sure. KJ

Thanks for the quick reply. The field Names in tblUser are: UserId (primary key) - Auto Number FName - Text LName - Text Password - Text PWReset - Yes/No AccessLevel - Number Role - Text Hope this helps, let me know if you need other information. KJ

I have an unbound textbox on a form and I would like it to show the logged in user to the databases first and last name. I have a table called tblUser where all users login information is stored, and a log in screen that runs a security level check against the table. What I would like is to...

Thank you very much, this works like a charm. I knew it had to be something simple that was holding me back... KJ

Ok, so if the form needs to have DataEntry as No, is there a way to have it when it is accessed through the search to have it as No, but to have it Yes when trying to enter a new customer? KJ

Ok, I did that and a message box popped up saying '3' with an OK button. Once I clicked ok, it brought me to my Customer Details form but still a blank entry... Frustrating... KJ

I do not know how to set a breakpoint. The form that I am trying to open here is the customer details screen, which is the same screen that is used to enter a new customer as well. It would have the Data Entry option set to Yes because of its entry use. I just want a simple way to search my...

I have changed the bound column to 0, which is the column CustomerID is in the Customers table, and I have tried changing the code to include And it still comes up with a blank form...I feel liek it is something so simple, but I am at a loss here...hopefully I am missing something simple. KJ

Hello, I have a search field where the list box is populated off of a query, I want to be able to double click an item in the list box and have it bring up the details view of the record. I have the following code on the double click event based on a thread I found here, but I cannot seem to get...

Thank you so much. Now to figure out how to mark this solved.

Hi all! This is my first post here aside from my intro so go easy... I have a form where when I click the save button, I want all the fields to be reset to blank. I think I have figured out the save new code, but the catch is, I have 2 check boxes that when checked they disable some text...

Hello all! I am an average access user and programmer, and I have been dabbling a bit in developing a database for a resale clothing company my wife and I are running. I am hoping to find direction here through existing user posts as well as asking questions in hopes of some direction from...