Results 1 to 8 of 8
  1. #1
    Casper2012 is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    18

    ^^^Pulling out my hair with a form!!!


    I have a database that I have been battling with for a few weeks. The task seems easy but, I need some help.

    I have a database that I need to be able to search by customers phone numbers. Which a can do now by setting my criteria.

    So now, I have my data on the screen, filtered by the phone numbers... but now I need to be able to click the customer I choose to be able to open their record to enter data in the form.

    Sounds easy enough, but i am stumped....

    Oh yea, here is the kicker.... after I query my data by phone number, I really would only like to open that record with the name, number, and company fields already populated for me.

    I am really hoping that someone on here can help me with this task. If anyone has a working database that has an example of this, please let me know.

    Any help is appreciated !!

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    have you got a sample database to work with. it's easier to point you in the right direction if you've got something to start with.

  3. #3
    Casper2012 is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    18
    Yes, I have a database that I have started.....

    here is the post.

    thanks for any help you could give!

  4. #4
    recon2011 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jul 2011
    Posts
    28
    One of the easiest ways is to use a macro to open a form you have created to contain the controls you need. Create a macro and select OpenForm. Set the Action Arguments to
    Form Name: YourFormName
    View: Form
    Filter Name: leave blank
    Condition: [YourControl]=[Forms]![YourFormName]![AssociatedControl]
    Data Mode: Whichever you prefer - set to read only if you don't want the data to be edited from here
    Window Mode: Normal

    Name the macro and then select the form. Open the properties window and select the property of the control you wish to use, such as phonenumber, Scroll down to OnDoubleClick or OnClick and click tohe down arrow. Select the macro you just created and save the form. It should now open the new form when you double click or click the control on your form and open the new form. I would also highlight the control so you know it is a link.

    Good luck.

  5. #5
    NoellaG's Avatar
    NoellaG is offline VIP
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Jun 2010
    Location
    Belgium
    Posts
    1,035
    Hi Casper,

    took a look at your database table, and if you really want to continue with this database, I strongly advise to normalize your database (there's a lot of cool stuff on the net concerning this subject) and split the one table in several related tables before building your forms.
    Otherwise you might run into a lot of problems later on.

    succes
    NG

  6. #6
    Casper2012 is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    18
    Thanks NoellaG-

    I have heard about normalization but I am fairly new to access. Could this be giving me my problem with having duplicates in my data?

    I will do some search on the web this weekend for normalization....

    any pointer to look for while I am checking it out?

    Thanks for your reply, I really appreciate your help!

  7. #7
    NoellaG's Avatar
    NoellaG is offline VIP
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Jun 2010
    Location
    Belgium
    Posts
    1,035
    Hi,

    normalization will surely help you to avoid doubles 'that's one of the main purposes). You can start at http://www.databasedev.co.uk/databas...on_basics.html, but there's a lot of other stuff about normalization on the net.

    grNG

  8. #8
    Casper2012 is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    18
    ok, so I understand that I need to break my table up some to show better relationships. I hope this can be done with the database that I already have. The ID numbers are already linked to my customers names, and it is very improtant I keep them that way. Once I change the layout of my tables, would I be able to change my database to lookup my customer by phone number and allow me to choose the one I want from the filtered list? As you can probably see, I have more than one person with the same phone number...

    Your help is greatly appreciated!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. access newbie pulling his hair out
    By merchantguy in forum Forms
    Replies: 3
    Last Post: 12-30-2010, 05:57 PM
  2. Query not pulling at all
    By ricardo9211 in forum Queries
    Replies: 3
    Last Post: 02-20-2010, 04:13 AM
  3. Pulling value
    By Overdive in forum Forms
    Replies: 3
    Last Post: 11-08-2009, 03:07 PM
  4. Pulling Record Info From Sub Form
    By redlich23 in forum Forms
    Replies: 1
    Last Post: 09-02-2009, 02:10 PM
  5. Pulling out duplicates
    By FREEEEEEDOM in forum Access
    Replies: 1
    Last Post: 04-21-2009, 10:37 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums