Page 2 of 2 FirstFirst 12
Results 16 to 24 of 24
  1. #16
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862

    Please read post 14 and lets make sure the DB is working before we proceed. Put it back to how it was and test it. Then, we can switch things around.

  2. #17
    whistler is offline Novice
    Windows XP Access 2007
    Join Date
    Dec 2011
    Posts
    26
    That didn't work to be able to type in Last name into the search box. That statement allows me to search by ID number.

  3. #18
    whistler is offline Novice
    Windows XP Access 2007
    Join Date
    Dec 2011
    Posts
    26
    OK, let me read post 14 and make sure it is working again. I will test it and let you know. You are very kind to help me.

  4. #19
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    Made a mistake....

  5. #20
    whistler is offline Novice
    Windows XP Access 2007
    Join Date
    Dec 2011
    Posts
    26
    OK, it works again. I put it back to the original.

  6. #21
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    OK, it looks like the SQL you posted will work to get the last name first. Here it is

    SELECT [qry Clients].[tbl Clients].[Last Name], [qry Clients].[tbl Clients].[First Name], [qry Clients].[Middle Name], [qry Clients].[ID Clients] FROM [qry Clients];

    Now when you place this in there, you will need to adjust the Bound Column. It was originally 1. With the new SQL. Id Clients is at the end. We will need to change the Bound Column value to 4.

    Test that and if it works you can hide the ID column in column widths using the last value listed. There should be 4 measurements. Changing the last measurement to 0" will hide the ID column.

  7. #22
    whistler is offline Novice
    Windows 8 Access 2007
    Join Date
    Dec 2011
    Posts
    26
    Awesome! I understand what you are saying. I will try it and will report back soon.

  8. #23
    whistler is offline Novice
    Windows 8 Access 2007
    Join Date
    Dec 2011
    Posts
    26
    ItsMe, you did it! THANK YOU!!!!!

  9. #24
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    Glad to hear.

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 08-06-2014, 06:06 PM
  2. Replies: 7
    Last Post: 12-11-2013, 03:43 PM
  3. Replies: 1
    Last Post: 02-29-2012, 04:46 PM
  4. Replies: 1
    Last Post: 08-18-2011, 08:35 AM
  5. Replies: 3
    Last Post: 08-08-2010, 12:21 PM

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