Search results

Update and progress. Courtesy of a lot of help from "Daniel Pinnault" on "UtterAccess" and the correct way to use the "Lebans" tools ... Relationship window now accessible via the Lebans "Relationship Views Add Modify" and associated table [tblRelationshipViews]. By saving the 'wrong'...

Micron .... Have been doing the "wipe/rebuild" method for a couple of years now ... and have got used to ignoring the relationship window. The window can be cleared in two ways ... one is just use the ribbon command and the whole lot goes ... or the other is to click on any table field that is...

Thank you "isladogs". Changed to overlapping but same result. And have looked at the Allen Browne link and that 'seems' to display additional information based on a correctly functioning relationship display ... And note that "Stephen Lebans" is mentioned again .... will try both versions of...

In reply to "Micron" ... that answer (wipe and rebuild) is the one suggested by most and the one I have used ... to date.

Thank you "isladogs" Image attached from yesterdays version. Did not know about the cross posting reference ... Current copy has window wiped and about to be rebuilt. i have just opened the Lebans version for scrolling instead of restoring and will try that ... but might well be beyond my...

Thank you "theDBguy" and "Micron". I have checked(used search) through posts and it seem there are others with this problem and replies from a number of people stating the best method to be "wipe and start again". Some have suggested/guessed that the window could be corrupted in some way if...

Hello to the forum: Currently using 2010 and have the (apparently) well known issue of the relationship window clipping the top section and so making many tables inaccessible. Does any user of a more modern version experience this issue ? If this is stable and reliable in newer versions I will...

Righty ho then. Will make a loading form for the sequence and just restart every time. When any old web browser can move pages it seems odd that the "flagship" MS thing cannot. EDIT = second thoughts. Will add command buttons to the principle and just show/hide so the sequence matters not...

Google - so that someone would not say "have you google this first?" And have searched on this forum before asking. No, not just copied. Tyuped by fingers. Single forms have a tab at the top with form caption. Editable via Properties/Caption. So multiple single forms display as a sequence of...

Hello to the forum from an occasional user of 2010 to display historical records. Minor irritation only ...but.... With a number of single forms open to edit data I have a preferred sequence of form tabs showing caption. As this is all a work in progress I still need to make design changes. But...

Thank you again Dave. Will have a go at that. I 'should' not get the null / no rank issue as all have a default rank or an "unknown".

Apparent success with nested queries. First query selects against the text control with EventDate. This used within second query with Totals of Max on PN and ED. Is this the correct method or will it bite back later ?

So far unable to get this to work. I offer this simplified/renamed example to explain what I am trying to achieve. New table created [tblpromotions] with 3 fields [personnumber] PN, [ranklevel] RL, [effectivedate] ED. PN: RL: ED: 1: 6: 1948 1: 7: 1950 1: 8...

Thank you Dave. Help much appreciated - I will now try this method. Regards - Paul

Thank you Dave. I was indeed hoping to use a date beyond the range of my records to provide a default against which I could compare - and that would allow all calculations to be in the same direction (negative). So if I read this correctly - I just have a date against each current rank in the...

Thank you jdraw. Atteched relationships and query from subform showing [tblpersons] and [tblranks] - all have enforced referential integrity. I would like to keep the existing ranks as currently selected by [tblpersons.id0rank] linked to [tblranks.id] but be able to display the correct...

Hello from an occasional amateur user of 2010. I have a functioning accdb for the display of historical military information. One part of this is the display of a persons rank by using [tblpersons.id0rank] passed to [tblranks.id] via a query on a subform. This works as expected. ([tblranks]...

Update after some tests: Now working in original fashion .......having tried variations in filename including underscore after the fixed prefix. Also working with PDF application running. So good news is that mine is working. Bad news is that this is now functioning correctly with no...

Thank you sneuberg. Am using Foxit for PDFs and this was open. So closed and checked for task ended. No Adobe tasks running. Changed record on calling form and hit the button for the report. Opened as expected and tried "Save PDF" button. This worked ............just as it used to. This with...

Oops - sorry - thanks to sneuberg. The code given by sneuberg generates a correct PDF version of the report in the normal folder - exactly as per my previous versions - except of course that the filename is now "Test1.pdf". Incidently - I tested the first version from Markk and right clicked...