Results 1 to 6 of 6
  1. #1
    amerifax is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Location
    Wisconsin
    Posts
    29

    Tubular Records.

    Sorry for some reason it became active. Good thing I can edit. Bad thing I can't delete this message.
    I guess I'm still in a fix. It said I can't have a report in a report. I'm tiring to add a display of the records in a row, 10 or 20 rows of records.

    I have a form with a few fields from my data base. I would like to drag the tubular structure onto my form but the tubular button is grayed out. My forum is in Design View. I thought I should be able to drag it to the form but...


    Bob

    Access 2010

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    Is this a current problem I can't tell based on the first line in bold.

  3. #3
    amerifax is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Location
    Wisconsin
    Posts
    29
    Text in brown, second paragraph was added after I created my original message. At first I thought I had fixed my issue, stated in bold, but then I found I have not. I'm still trying to fix my problem and that is being able to have a window displaying 15 or 25 records reflected by the search box. Top of the form shows several fields of the record I'm currently on and I would like to have displayed under this data the next 15 or 25 records in a horizontal display.

    Bob

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,848
    Want to paste a screen shot of your input and output so we get some feel for the situation?

  5. #5
    amerifax is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Location
    Wisconsin
    Posts
    29

    The lower image is what I'm trying to add to form

    Here is the image. the top part is done. The bottom Is pasted to give you an idea.
    Click image for larger version. 

Name:	access tubular.png 
Views:	8 
Size:	61.1 KB 
ID:	9553

  6. #6
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    if that's a datasheet or a subform you would add a criteria to the query driving the subform/datasheet that was something like [Forms]![FormName]![SEAL] where FORMNAME would be the name of your form and SEAL would be the name of the field containing the seal number.

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

Similar Threads

  1. Replies: 10
    Last Post: 10-10-2012, 11:15 PM
  2. Replies: 4
    Last Post: 08-02-2012, 10:59 AM
  3. Access 2007 - Creating New Records Based on Existing Records
    By GeorgeAugustinePhillips in forum Forms
    Replies: 9
    Last Post: 10-05-2011, 05:58 PM
  4. Replies: 12
    Last Post: 08-30-2011, 03:36 PM
  5. Date function to query records and Sum records
    By sullynivek in forum Queries
    Replies: 0
    Last Post: 04-05-2011, 08:37 AM

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