Search results for query: *

I am pretty new to the whole Access thing, here is my question: I have a form with a subform. I am trying to make a delete record button. I would like to be able to delete the main record, as well as any underlying record in the subform (not as concerned about the subform, but it would be...

Hi All!!! I am having issues with a filtered form. Here is the deal: I have a form that has five searchable controls. Once I hit the search button it filters all the records so that I get only the ones desired. I am having problems is when I try another search. At first, I had it so that it...

Hi All!!! I had posted this in the "forms" forum previously and got some help, but had some problems, and got no responses. I was hoping someone in here could help. I have a part number that in a table, it is a "text" field because I have hyphens in it. There are three...

Hi All!! I have a little problem that I can't seem to get around. I am using part numbers in my database. These part numbers have dashes in them. Because the part numbers have dashes in them, I must use a text field, however when I try to organize them in ascending order they go by the first...

Hi All!! Hopefully you can help me. I am trying to run a search based on certain criteria. I would like the user to be able to fill in as much (or as little) criteria into different fields as they desire. I have five such fields that the user can put their criteria into. I want my database...

Hi All!! I am trying to do something very similar to Thread 702-450881. I have a database with five different lookup controls. PartNumberLookup DescriptionLookup FirstUsedOnLookup Etc. I used the comments in Thread 702-450881 to come up with code used to make it possible for the user to use...

Hi All!! I am trying to do something very similar to Thread 702-450881. I have a database with five different lookup controls. PartNumberLookup DescriptionLookup FirstUsedOnLookup Etc. I used the comments in Thread 702-450881 to come up with code used to make it possible for the user to use...

Hi All!!! How do I create a Message Box that allows me to have a yes or no response from the user. "MsgBox" only allows me to have an ok response. I would like a Yes No Response and then I need to know how to have the actions after the Yes or No has been clicked. I think this is...

Hi All!! I would like to make some of my controls (and even some subforms) on my main form invisible unless they contain values. I am sort of new to VBA and not sure if there is a command like NotNull or something. The normal situation I would like them to all be is not visible and then if...

Hi all! I am trying to look up a value, if it is there the database will open that record. I am then trying to add some fields to that record based on a subform. I would like the user to go straight from the "lookup" box directly to where they should enter info into the subform...

Hi. This was working, I thought. Then I changed some stuff. I thought that I put it back to normal, and it doesn't work. This is what I am hoping to do: I want a user to type in a PartNumber in an unbound text box called Text76. I want the database to either find the part number and...

Hi! I am trying to look up a part number using a text box. If this part number is found, I would like to make a revision change (I would like to keep the old information). If it is not found, I would like to enter a new record. So, now I have this set up to pull up the record, but it...

Hello, I am pretty new to this access thing, I took a class a couple of years ago and trying to remember what I learned. I never learned vba, but thanks to this forum am starting to understand it a little. Anyway here is my dilemma: I have a form that is based on a query. The form asks the...

I had learned Access a couple years ago, told my boss that I could do something with one of the databases that we have at work. I am having trouble remembering some of the things that I have done. I am trying to do something that I thought would be simple. I want to have a user type in a part...