Form

DLookup returns same name
In an Access 2003 database, I have a form, Contacts, based on a Contacts table that includes potential donors and the Solicitor ID of their assigned solicitor. I also have a Contacts form for displaying the contact information. On the form, I would like to display the solicitor's name from the table called S... 26 May 2010 16:58

Need a button to print 5 copies
I need to put a button on my form that, when clicked, will print out 5 copies of the current form. I know that it's not wise to print forms, but there's not much way around this. I currently have a button that prints out a single copy of the form. Here's the code behind the button: DoCmd.DoMenuItem acForm... 12 May 2010 11:23

Combo Box Filter
i have a form that is used for data entry. employees use the form to bring up records. there are 2 combo boxes on the form to filter for specific records in a Time Zone and particular Segment. The underlying table as records - but 2 groups. Current and New. I have a button on the form that can bring up the cu... 17 May 2010 13:33

Quick Filters Issue
Do I assume that cascading two queries is the basis of the issue of my quick filters no longer working? The quick filters worked fine previously; but quit working on my split form after I cascaded two queries and made the 2nd query the source of my form. The first query has a logical IIf that is based off o... 11 May 2010 17:56

Add consecutive dates w/ command button & parameter boxes
=?Utf-8?B?RmxvcGJvdA==?= wrote: Hi, I have an unbound form [Frm Volunteer Opportunities] with a sub form [SubFrm Vol Opportunities]. The subform has the fields [Event ID] and [Event Date]. My unbound form has a command button on it. Basically, what I'm trying to do is have Access automatic... 13 May 2010 07:11

Add consecutive dates w/ command button & parameter boxes
Hi, I have an unbound form [Frm Volunteer Opportunities] with a sub form [SubFrm Vol Opportunities]. The subform has the fields [Event ID] and [Event Date]. My unbound form has a command button on it. Basically, what I'm trying to do is have Access automatically create 31 new records in [SubFrm Vol Oppor... 12 May 2010 19:14

Creating a Form Desktop Shortcut to ACCDE
I can simply drag and drop the form from the ACCDB and get a .maf file on my desktop that works fine, but this appears to not be allowed from an ACCDE file. I can do this with any of the queries in the ACCDE file. Is there a way around this? I simply want my users to be able to double-click the form shortcut t... 11 May 2010 15:41

Field Form
Well, I believe Option Groups always store numeric values like that, so there are 2 choices that come to mind. In your query (or report), use nested if statements like: if([gender] = 1, "Male", if([gender] = 2 "female", "trans")) Or you could create a table with 2 fields that has the relationship of Numeri... 12 May 2010 10:16

MouseDown event does not always fire
My form contains a box control and some label controls on top of the box. The labels' mouse move events contain code to emphasize the labels caption (increase font weight and underline) and the box's mousemove event resets the label to normal. And it works ... some of the time. But if I move the mouse quick... 11 May 2010 13:25

Sizing Access 2007 Forms
I'm wondering if I'm the only one having problems saving the size of access 2007 overlapping forms. I decided to play around with a copy of my db and changed it from a tabbed to overlapping interface. I posted a question about this some time ago and the following is a response that I had saved to a text file:... 11 May 2010 11:11