Recent content by FootballGuy

I have setup a query which is used as a basis for a report. I can then limit the records showing in the report by adding conditions in the query, which is fine. My dilema is how can I do this when everything is run from a custom Switchboard. When you build the Switchboard the opportunity to...

Entry level questions contd. - restricting DB access RESTRICT ACCESS TO ANYTHING OUTSIDE OF THE SWITCHBOARD I see I can put a password on the DB and/or setup user accounts each with passwords and retrictions (including "Administration"). Still, how do I stop them from accessing anything outside...

Entry Level questions contd. - positioning screens I am trying to position my Switchboard and all subsequent screens to start in the top left hand corner verus middle of the screen. Even though I turn the "Center" option off for both they still stay cenetered. If I call up the screen directly...

Entry level questions contd. - reading from files READING FROM FILES OTHER THAN THAT FROM THE FORM OK, I am embarassed to ask this, but how do I do read from a file that is not the file used for data entry on the form. Sample scenario: Form (file: MovieRental) - Movie Checkout processing - a...

Entry level question - Current Year I am trying to figure out what function will return the current year so that I can assign it automatically to a field as a default on an add. I see the YEAR and NOW functions, but I dont know what parameters to use. Thanks in advance