Forms
in [Access]
|
Combo box filter before form opens frmSearchType with cboType and cmdOpenForm which opens frmEntryEdit. frmEntryEdit uses cboEntryNum to allow user to select from the filtered records. This is working correctly, however if no records fit the filter, I get an open frmEntryEdit, with no records in the cboEntryNum. I would rather have a message ... 16 Feb 2010 18:23
Sorting Problem I have a text field in one of my tables that includes alpha-numeric values such as "A1", "A2", "A3", etc. Currently, when I sort them in a report, they sort alpha-numerically (as they should.) However, this means that "A11" comes before "A2". Is there anyway (programatically) I can get the output to display ... 17 Feb 2010 00:34
Quit Database Hi I have a close button which when pressed I want to give the user the option to close the database and leave Access open, or close the database and quit Access IS this possible please - I can get the Application quit bit but not the syntax to close the Database and leave Access open Tks ... 16 Feb 2010 12:56
Setfocus on subform on tabbed form Hi Access Gurus, I have a tabbed main form which has 2 subforms on one of the tabs where the subforms have been made to look like one form. My problem is that the user needs to be able to tab through the first subform into the next seemlessly but I can't get the setfocus syntax for that right in this setup. ... 16 Feb 2010 02:58
Maintaining the aspect ratio for photos Hi I have a table in a 2007 access database where each record has a link to a photo. The photos vary in size and aspect ratio. At the moment I am displaying then in the one frame so that some look good and others squashed up. Is there a way to read the information on each photo and display in an optimum... 14 Feb 2010 20:46
Combo Box problem Hi I have 3 tables and 3 associated forms in an 2007 access database. On each form is a combo box "Name Search" so that one can input 2 or 3 letters of a surname and get a drop down list of names matching the input. All three Combo Boxes were set up in an identical manner using the wizard. The Main Menu h... 14 Feb 2010 19:40
Report based on field criteria I have a form (frmJobs) with a field called ClientName. If ClientName is similar to certain criteria, I need one report to display. If ClientName is not similar to the criteria, a different report should display. This is the code I currently have: Private Sub PrelimRpt_Click() If Me.ClientName = "Apache*... 13 Feb 2010 17:12
looking for a way to unlock a back end mdb file Is there any way to unlock a back end database file? I understand that one answer is to get all the users that are linked to it to close down. However, we're tried that and the file will sometimes remain locked for a few days. We're using Access 2003 in a multi-user environment, and every night we import d... 16 Feb 2010 00:27
On Click Event Hi, I am new to Access and can't figure out why this is not working. I have a form that opens a subform when certain criteria is selected. Once the list of records are displayed in the subform, I want the user to be able to click on one of the records and it will open a new form. I created a On Click Event ... 14 Feb 2010 08:28 |