Form

Overriding constraint violation message
Hi I'm at my first try to use SQL Server as back-end database for Access front-end. On SQL Server, I created constraints (additionally to primary key) for my tables: a) foreign key constraints to control data integrity (deleting entries linked to other tables isn't allowed); b) check constraints (ce... 22 Apr 2010 04:07

Tabular Form - Move Cursor Down
I've created a tabular form in Access 2007. I would like the cursor to move down the column I'm currently in when I either click on the enter key or down arrow; similiar to what you can do in datasheet form. Is there a way to do this? ... 21 Apr 2010 12:35

Automatic control names
I feel stupid asking this question, but I can't find any previous posts about it. Is it possibe to set Access 2007 so that the forms wizard will name the controls properly? The default is to name the control with the field name of the data source, but it ignores the proper naming conventions (or at least what I ... 21 Apr 2010 15:42

Data Refresh
I have a table with several fields, but in particular Student Number (test) Last Name (text) First Name(test) Grade(text) These fields show on my form called Parking form. These fields are locked. I wish to allow the users to add/edit fields. So I have a cmd button that opens a new form called add/edit new s... 20 Apr 2010 18:34

Filter Frustration
I have two forms. Both have a button that call the same subform. This is the information for the first call. It works just fine. ________________________________________ stLinkCriteria = "[SEASONS]='" & Me!Season & "' And [DevCodeA]='" & Me!DEVCODE & "'" stDocName = "MilestoneDates" DoCmd.OpenFor... 20 Apr 2010 19:42

IIf statement sometimes works
I have the following IIf statement on an unbound field on a form: =IIf([Loaned/Out]="0"," ","Out of Service - Please Exit and select another Vehicle") Sometimes it comes back with the correct "Out of Service..." or nothing if the vehicle is not designated as loaned/out, but other times it comes back with ... 21 Apr 2010 11:33

Picture Property
I have a pdf form that I want to fill out using my database information. I copied the form into paintbrush using printscreen and created a bmp file. I use this file as a background for a form in the Picture Property. when displaing the form I get a very poor picture Is there a way to get a sharp looking pictur... 20 Apr 2010 06:13

SendKeys & Windows 7 Problem
On Tue, 20 Apr 2010 08:54:33 +0300, "Anatoly Kurilin" <akurilin(a)msn.com> wrote: Is there any way to overcome that? Yes. Don't use Sendkeys, ever, for anything. It's not needed; there is always another (better) way to do what you are trying to accomplish. -- John W. Vinson [MVP] ... 20 Apr 2010 02:05

Sorting empty fields
My form has the following fields: ID, DueDate, DatePaid,HowPaid,Check#, AmtPaid, FeePaid, Gift, PastDue, Notes. A DatePaid entry can be made for a Gift or Fee leaving the duedate field empty. I would like to sort by the due date with the empty fields sorted by datepaid. Right now the empty fields are on t... 19 Apr 2010 22:58

Yes/No Format Issue
Hi Groupies I have been building databases for years and have not run into this problem before. This 2007 database I am working in has a few yes/no fields. When I add these fields to a Form, they are show up as textboxes instead of the yes/no check box I am expecting. They respond correctly in queries, aut... 20 Apr 2010 14:30