Search results

Drink up ;)

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=48557&highlight=hidden+form+exit Includes a link to another method also.

St3ev, The method I suggested will solve your problem. Having looked at your demo, you will need to alter the structure of your second combo box. As previously stated: I have altered your demo to suit. Take particular notice of the new structure of the second combo box. Add the "combo1 =...

st3ve, not knowing the full details of your form, I would suggest: - The use of a combo for finding a record (as constructed by the combo wizard) would indicate that the combo is not "bound" to the record. - Thus combo1 is unaware of what combo2 and the record itself is doing (and vice...

Search here (or Access help) for information on "splitting" a database. Other key words: - Frontend - Backend Plenty of info out there. Brad

IF I have understood you correctly: You could use the On Double Click event of the subform (form) to achieve your task. Add the following code to your subform. The user can then double click the record selector to view more details. Private Sub Form_DblClick(Cancel As Integer)...

Handling NULL can be achieved by adding the following lines the start of your code. If IsNull(Me.List8.Column(0)) Then MsgBox "Please make selection prior to attempting to delete record.", vbOKOnly, "Selection Required" Exit Sub End If You will know if you need another solution for...

Open your query up directly (not via the form) and see if you can delete a row manually. (ie: select row and then delete) If the recordset is not updateable, then you will be unable to delete records via sql or any other means. I use the query/listbox to obtain the required ID and then delete...

I would try structuring you SQL string as a Delete Query. I know you are very close to achieving this, but I have attached a "mini demo" for others (that may or may not find it useful). You will need to add handling for List Box selection being NULL. You will also need another requery...

If you have a listing of the font names in the db then you can use On Format of the detail section: Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Me.FontNameStored.FontName = Me.FontNameStored End Sub Where FontNameStored is the name of the text box on the report...

Tools / Options / View / Hidden Objects Phew.

Application.CurrentProject.Path & "\CTS IT.mdb"

In the AfterUpdate event of your first combo include: Me.SecondComboName.Requery Note: If your second combo already has a selection, it will remain, but may not display. ie: the value remains, but is not part of the new rowsource, and thus appears blank. If you consider the "old" selection...

They say that a little bit of knowledge is dangerous, but I am afraid that is all I have - So be warned ;) If you are using NT/2000 etc, and the file is located on your computer (not a network server etc) then you can check for open files in the "Computer Management" applet in Control Panel...

Microsoft quote: Taken from: http://office.microsoft.com/assistance/preview.aspx?AssetID=HP052817081033&CTT=4&Origin=CH062526001033

Using "On Got Focus" for the field in question, try: Me.TextBoxName.SelStart = 0 To select the end of the field you can use: Me.TextBoxName.SelStart = Me.TextBoxName.SelLength Note: If you want this feature for all fields, You can set this as a default option in Tools / Options / Keyboard...

TJ, How much of this task have you already completed? Are you at step 1 or do you have your search working and just want to display as mentioned?

teiben, You will run into further issues with this code. As the "responsibility" text box has focus, you will not be able to set enabled to false. (Or if the text box is enabled = false by default, it will not be able to receive focus, and thus you code will not initiate) You could however...

Your message box line is incorrect. Try: MsgBox "The following have not been entered. Is this correct?"& vbNewLine & strNullFields, vbYesNo You will still need to add actions for the Yes / No input from the user. Cheers Brad.

Hi Rachael, I like your "upgrade strategy" ;) (Which reminds me, I haven't drank that pinot grigio yet) I followed you original post on this topic with interest, and have not ran into the same issues that you describe. However, I have only been using this on test db's, and as we all know...