Move to first record

[hoofit]

I'm having a problem moving to the first record, or the next record for that matter. I'm not able to get the record selector to function nor a command button. Then form properties appear normal. I realize that this is sight unseen but does anyone have any thoughts about this problem

thanx
hoof

 

[hoofit]

Also note that the record counter at the bottom left of the screen shows one record while I have over 20 in the table.

 

[TheAceMan1]

How are ya hoofit . . .

Your post is quite vague. For example:
[ol][li]Does the record counter read [blue]1 of 1[/blue] or perhaps [blue]1 of 20[/blue]?[/li]
[li]Are you talking a table, query or form?[/li]
[li]If a form, does the [blue]Record Source[/blue] return more than one record?[/li][/ol]

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[hoofit]

TheAceMan1

This will be on a form. Record counter is 1 of 1.

Record Source:

SELECT TblSigns.SignID, TblSigns.Ref_Description, TblSigns.Ref_RoadName, TblSigns.Ref_PostType, TblSigns.Ref_SignSize, TblSigns.NearestLocation, TblSigns.InstallDate, TblRoads.RoadName, TblSize.SignSize, TblPostType.PostType, TblDescription.Description, TblSigns.Ref_PostType, TblSigns.ref_folderPath
FROM TblSize INNER JOIN (TblRoads INNER JOIN (TblPostType INNER JOIN (TblDescription INNER JOIN TblSigns ON TblDescription.Description = TblSigns.Ref_Description) ON TblPostType.PostType = TblSigns.Ref_PostType) ON TblRoads.RoadName = TblSigns.Ref_RoadName) ON TblSize.SignSize = TblSigns.Ref_SignSize;

hoof

 

[hoofit]

I can run the record source for the form and get all of the fields. I know this is vague. Uploading a copy may help

 

[TheAceMan1]

hoofit . . .

I'm not feeling good about the 5 tables.
[ol][li]For the navigation buttons on the bottom left, is the AddNew button grayed out?[/li]
[li]What happens if you transfer the [blue]record source[/blue] to that of a new form?[/li]
[li]Which of the tables are lookups?[/li]
[li]Whats the primarykey of TblSigns?[/li][/ol]

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[hoofit]

TheAceMan1,
I found 2 controls with the same name on the same form - seems to be a conflict. Let me work on this more before you spend too much time.

1. no
2. ?? have not tried
3. 5 tables are lookups, tblSigns is not (main table)
4. tblSigns PK = SignID

hoof

 

[TheAceMan1]

hoofit . . .

If you decide to upload, I'm using 2003.

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[PHV]

Do you have more rows with this SQL ?

SELECT TblSigns.SignID, TblSigns.Ref_Description, TblSigns.Ref_RoadName, TblSigns.Ref_PostType, TblSigns.Ref_SignSize, TblSigns.NearestLocation, TblSigns.InstallDate, TblRoads.RoadName, TblSize.SignSize, TblPostType.PostType, TblDescription.Description, TblSigns.Ref_PostType, TblSigns.ref_folderPath
FROM (((TblSigns
LEFT JOIN TblRoads ON TblRoads.RoadName = TblSigns.Ref_RoadName)
LEFT JOIN TblPostType ON TblPostType.PostType = TblSigns.Ref_PostType)
LEFT JOIN TblDescription ON TblDescription.Description = TblSigns.Ref_Description)
LEFT JOIN TblSize ON TblSize.SignSize = TblSigns.Ref_SignSize

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886