Results 1 to 2 of 2
  1. #1
    markjkubicki's Avatar
    markjkubicki is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Jul 2010
    Location
    Fire Island Pines, NY
    Posts
    496

    form not displaying as intended

    I'm not having any luck getting this form to display as I want it to...

    the form is intended as a kind-of FYI pop-Up -just to let the user know what is going on while some code is beig executed (in this case, I'm cycling thru the currentDB set of tables, and want the user to know which table is being looked at...

    my form has only a few controls
    a label and (2) text boxes
    and I've written the below code to update the content of the text boxes

    I want to change a couple of thing about how it behaves:
    - the form frame shows, but not it's background, nor the label control, nor the textbox control [text2]. All aspects should appear as would normally be expected
    - the textbox control [text0] does diplay, and the data is updated; however, the format is that the text has "focus" (all of it is "selected")

    Maybe there's just a better way of doing it (there's always another way)...
    Any thoughts and suggestions would be greatly appreciated; thanks in advance,
    mark

    _______________
    Public Function ...
    ...
    Set dbs = CurrentDb
    Dim tdf As DAO.TableDef
    ...
    Dim stDocName As String ' Loop through all tables in the database.
    stDocName = "frmTemp"
    DoCmd.OpenForm stDocName
    For Each tdf In dbs.TableDefs


    ...
    Forms![frmTemp].Text2 = tdf.Connect
    Forms![frmTemp].Text0 = tdf.Name
    ...
    Next tdf
    ...
    DoCmd.Close acForm, "frmTemp"
    End Function

  2. #2
    DaveT is offline Access Developer
    Windows 7 Access 2010 (version 14.0)
    Join Date
    May 2010
    Location
    Texas
    Posts
    69
    I use a table to display table names as they are being linked. Here is a snippet of the code that I use:

    .....
    Dim f as Form
    Dim c as Control
    ....

    'before the loop starts

    DoCmd.OpenForm "LinksInProgress"
    Set f = Forms("LinksInProgress")
    Set c = f!TableName

    'start loop
    'something that sets tmpStrTableName to table being linked

    c = tmpStrTableName
    c.Requery
    f.Repaint

    'bottom of loop

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

Similar Threads

  1. Displaying form fields
    By sakthivels in forum Forms
    Replies: 5
    Last Post: 05-25-2009, 07:52 AM
  2. Displaying a picture on a form
    By kydbmaster in forum Forms
    Replies: 4
    Last Post: 04-04-2009, 07:54 PM
  3. Displaying records from a form
    By ceb39 in forum Access
    Replies: 5
    Last Post: 04-03-2009, 12:36 PM
  4. form not displaying fields
    By ashiers in forum Forms
    Replies: 0
    Last Post: 09-19-2008, 07:02 AM
  5. Displaying a PDF in a Form
    By Chaz in forum Forms
    Replies: 0
    Last Post: 08-07-2006, 03:26 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