Search results

Simple question, I am wanting to display in a text box or on my report the total number or records in my database. Also I have some buttons that filter the results a little, I'm wanting to display the number after I hit the button(s). Would I just add the query to the end of each button I...

Hi everyone. Here is what I am wanting to do. I initially thought an input mask could accomplish this, but after some further reading on it what I am getting is only VBA can get it done. Here is what I am trying to figure out. I have taken over a DB where the original designer had a lot of...

Sorry, I found it. Thanks ACCESS

I'm having trouble getting my form to be "blank" except for the labels upon loading. I've tried putting in some code "on load" but it doesn't clear everything. I haven't had this trouble on some of my other db's, the only difference here is it's a switchboard. I don't know if that matters...

I stumbled across what I was looking for. Sorry

I recently took over a DB that is based on switchboard form upon opening. Haven't done anythng with switchboards, my question is. On my report that I have open up I would like to filter between 4 conditions. Would it be best to setup buttons in the report after it is run, or have something...

I am having troubles on the form in design view. The text boxes I cannot get them to store the information in the correct table. I am trying to change it in the control source, however it gives me a ! in a yellow box. Like I said I am very new when it comes to multiple tables. Thanks again.

Thank you, I feel stupid now for overlooking something that simple. Thanks

I'm having another little issue. I have created another text box and would like to do the exact same thing that JHB helped me out on. The issue I am having it is not pulling up the information as it did before. This text box is named text 22 and I renamed everything in the module so it should be...

Hello everyone, I feel like I am ice skating uphill here. I have something I'm working on and I need some advice to see if I'm doing it the correct way or if there is a better way. I will attach a copy so you can see what I'm trying to explain. I have 5 tables and 2 forms. The primary form...

Thank you for that. Sorry it wasn't more challenging for you. Once again thanks.

I have an onchange event setup that filters employees by their employee numbers. It populates the text boxes in my form, howeve when I want to look up another employee by their respective employee number the old information is still in there and in order for me to look up someone else I have to...

Hello all, I have a question. Here is what I am wanting to do and have been having some trouble trying to get the ball rolling. I initially thought I could do this through a query, however I don't think that is an option. I have attached my Database, keep in mind very early stages. I have a...

Added that code and it does allow me to type in the 3 digit employee number, however it doesn't match employee number in the table. EX. I will type in the number 5 and it spits out employee number 201. It does pull the information along with that record out correctly, just the wrong record. I...

Did that, it seems to be working ok. However whenever I try to type in that employees full number it only limits me to 1 number that I can type in. Any thoughts? Thanks once again.

I'll attach my Database and let you all look at it. The form where I am trying to get the bugs worked out is the update form. And for some reason whatever number I type in, lets say I want to look up someones employee number 265, If I type in 2 first then it comes up with some wacky stuff. Also...

Thanks for the replies. I will try that here in a little bit. Let you know what I come up with.

Here is what I have in the code now, it is not giving me any errors, however it is not matching up the employee with the numbers that I am inputting in. Any thoughts? Private Sub Text6_Change() Me.Filter = "[Employee Number] Like """ & [Employee Number] & "*""" Me.FilterOn = True End Sub

This is what I have this far, just basic bareboned right now. I am kind of torn to either do a search for an employee and update his information all at the same time, or search for an employee and then update his information. I am thinking that the least amount of steps would be the more...

Hello everyone, I need a little help updating a field in a database based upon a person employee number. To me is sounds simple in theory but I have not messed around much with the find or go to record in access. I would like to punch in their employee number, have all their information...