Using Forms - Page 1006 - OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Thread / Thread Starter	Last Post	Replies	Views
Setting focus to a control on a subform on opening by John S. Ford, MD In Access 97, have a form with a subform on it. Upon opening the main form, I'd like the focus to be immediately set to a textbox on the subform. The name of...	July 14th, 2004 06:36 AM by Allen Browne	3	459
Problem with closing a form using a command button by John S. Ford, MD I've created a frmMainForm with an embedded sbfSubForm. I have set the fields for the underlying tables as "Required". Therefore, if frmMainForm is closed...	May 3rd, 2006 02:09 PM by John S. Ford, MD	2	106
Formatting numbers in a TextBox by John S. Ford, MD I have a form with several subforms. Some of the subforms have TextBoxes for which numeric data will be entered. I'd like to format the way such data shows...	July 23rd, 2007 05:18 AM by JK[_2_]	3	135
Opening a report from a button on a subform by John S. Ford, MD I have a main form frmPatients with a subform sbfPatientAppointment. The main form contains general information about a patient and the subform contains...	August 7th, 2007 09:15 AM by John S. Ford, MD	4	58
Filtering a report's underlying table from a form by John S. Ford, MD I have a form with several command buttons each of which will open the same report but with a different filter. What kind of code can I put in each button's...	August 25th, 2007 10:57 PM by John S. Ford, MD	2	71
Converting an IDNum of a Combo or ListBox to its corresponding text for a TextBox by John S. Ford, MD I have a form (frmSearch) for entering search criteria which is then used to filter a second form (frmData) prior to opening it. The criteria of frmSearch is...	March 27th, 2009 03:47 PM by A Marano	4	86
Controlling a label's appearance by John S. Ford, MD If a control's Enabled and Locked properties are both set to no, the font of the attached label takes on an etched appearance (and the control is greyed...	April 5th, 2009 06:10 PM by Ken Snell MVP	3	126
Can't get Me.AllowAdditions to work with command button by John S. Ford, MD I have a form which has its AllowAddtions property set to False. I have a command button with the following code: Private Sub cmdNewAdmit_Click() ... ( 1 2)	April 9th, 2009 04:49 AM by Stuart McCall	10	153
Form doesn't sort records per the underlying query by John S. Ford, MD I have a form, frmMain that uses a query as its underlying datasource. The query sorts the records in a certain way. How come the records aren't sorted the... ( 1 2 3 ... Last Page)	April 10th, 2009 02:33 AM by John S. Ford, MD	46	1,634
Using DoCmd.OpenForm with form AND subform by John S. Ford, MD I'm using DoCmd.OpenForm to open a mainform and its subform using a WHERE statement from a command button on another form: DoCmd.OpenForm "frmMainForm", , ,...	March 28th, 2006 02:30 PM by K Dales	3	147
"Auto Repeat" feature on command buttons by John S. Ford, MD I'm coding in Access 97. Because I needed to customize the way a particular form navigates through records, I created and coded my own record...	January 15th, 2005 10:15 PM by John S. Ford, MD	6	564
Form closes after instead of going to next field by John S. Ford, MD I'm using Access 97 and have a form with a bound table set up so that if the user opens it, it automatically defaults to display a new record. The focus goes...	August 23rd, 2004 11:49 PM by Fabiano Eyer Silva	4	131
Substituting my own MsgBox for the standard delete confirm MsgBox by John S. Ford, MD I have a form with some code that allows the user to hit a command button that deletes the current record. Access routinely asks the user to confirm that they...	August 20th, 2004 12:05 AM by Arvin Meyer	8	306
Using DAO to move to the new record by John S. Ford, MD I'm trying to write some code that will move the cursor to the new record. I've tried the following: Dim rst As Recordset Set rst =...	August 22nd, 2004 10:29 PM by Albert D. Kallal	3	118
Problem with ComboBoxes by John S. Ford, MD I am working with Access 97 and have a form with a ComboBox (cboFirst), a TabControl and a ComboBox (cboSecond) on the first tab. I also have a "Sentinel...	August 25th, 2004 04:03 AM by Graham Mandeno	1	82
Blocking users from changing records by John S. Ford, MD I've written an application in Access 97 and have been trying to bulletproof it. Part of an entry form has users entering information and I don't want him to...	November 2nd, 2004 11:40 PM by Ted	9	293
by John S. Ford, MD I can't seem to see responses to this question...	October 15th, 2004 09:58 AM by Brett Collings [429338]	1	68
Disabling "Confirm Record Changes" programmatically by John S. Ford, MD I have an application running in Access 2000 with a form that enables the user to delete records through my own code. I'd like to be able to turn off the...	October 27th, 2004 05:48 PM by Douglas J. Steele	2	110
Suggestion for input mask for TextBox by John S. Ford, MD What would the simplest input mask be if I want the user to type in a last name the first letter of which is capitalized with the rest in lower case ie. I...	October 31st, 2004 03:36 AM by John S. Ford, MD	2	128
Function to test if TextBox entry is a 4-digit number. by John S. Ford, MD I need to write a function to test whether a text box contains an entry of a 4-digit number? The text box in question is bound to a "text" field. In other...	April 19th, 2009 02:40 AM by John S. Ford, MD	6	125

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed