Recent content by Whispersplus1

Hello Access world, I'm trying to figure out how I can get a particuler range of information in a table to print. The articles that I enter in the database were placed in different locations. Example 10 articles are placed in location 1 another 14 in location 2 and another 15 in location 3...

I created a form that uses a barcode to activate it. My problem is that once it's activated I still have to use "Control V" to apply the date. Does anyone know how to get a date field to AutoDate once the form has been opened?

I need alittle assistance here. The database a created has a query that uses a parameter to locate specific information. The result of the parameter is a form with a sub-form (this is a good thing) The problem is that I have to scroll through (example 1 of 4 records) to detemine the correct...

Are you using the Database on two different versions of Access? i.e. Access 2003 and Access 2007 The reason I ask is because I had the same problem, the easiest fix was to determine the system you are going to use and recreate the close buttons using that version.

I have successfully created a form with a sub-form that opens up the information I'm requesting based on the parameters set in the querry for the form. My problem is that when the results appear each person has been placed on their own form. For me this means scolling through forms until the...

In my database I have input customers names in three columns Last, First and MI. I used the phrase below..... IIf(IsNull([Last]),IIf(IsNull([First]),[First]),IIf(IsNull([First]),[Last],[Last] & ", " & [First])) to get the whole name to appear in one column...example Smith, John T. Heres where I...

Hello, and welcome to my world of problems as a novice Access user. Any assistance is greatly appreciated and utilized to PIMP my database.

I figured I'd share the end result,:D it still needs a little tweeking but, its' doing what I wanted.:) Again, thanks to all that tried or did help. P.S. If you find a way to get the parameters box to show by hitting next without having to click on the arrow, please share.

Combo boxing the Box# isn't going to really help me. (way to many boxes) I would like whatever it takes to go directly to the Box# giving me an option of the family members displayed in a combo box or list from which I can choose the person I'm really looking for,(without re-typing the box...

Thank you so much...... The version you edited is almost exactly what I'm looking for. All I need to do now is figure out why I have to enter the box # twice to get what I want it to do. If you have an idea I'm all ears? If it's too much I'll understand?

I appreciate all the assistance and a special thanx to leem888 for trying to simplify some instuctions for me but, I'm still having difficulty getting the form to do what I really want it to do. In the attachment there are to forms, the first one "ACustomers Extended" the results I'm looking...

Is true, all box numbers are 4 digits. After the information is retrieved I want to be able to select one of the family members. By selecting the family member it will automatically update the subform that is attached to reflect information about that family member.

I have attached an example of what I want the form to look like. What I want it to do is giving me alot of trouble. When you click on the form it should ask you once WHICH BOX #. After your type the box in, the family members in the box should be listed in the combo box. When you select a...

I'm trying to create a form in Access 2007 that will allow my to select a family member using a combo box. After I select the name I want the attached subform to reflect the correct information. In this case all the articles located in the building for that person. Please HELP.:eek: