Search results

Check this out - see if this does the trick: http://support.microsoft.com/default.aspx?scid=kb;en-us;199963 HTH E

Here is an A97 dbase that contains a table and a form. The form randomly picks a record from the table and displays it. The form opens at startup and closes after 5 seconds. Let me know if this is what you had in mind. E

I must apologize, but I don't have time right now to work with you on this. My goal in directing you to the MS site was that you could look at the code they supplied and adapt it to your specific situation. It seems to me that placing the suggested (modified) code on the BeforeUpdate event of...

Since I haven't seen your app, I'm not sure what it is you're asking me. The MS Knowledge Base instructions are just a guideline to give you the understanding of how to accomplish what you need to accomplish. You tailor their instructions to fit your particular application (form names, etc.) HTH

To set the focus on the field in the main form, you place this code in the form's onCurrent event: me.yourfieldname.setfocus To tab to the fields on the subform, you need to place the subform name in your Tab Order - it should work without special coding. If you want to jump back to the main...

Check out this article in the MS Knowledge base - I think it will do what you need: http://support.microsoft.com/default.aspx?scid=kb;en-us;252813

I suppose I would search for duplicate values. If a duplicate value is found, then (perform an action), if no duplicate, then open the form. Check this MS Knowledge base article out for using code to check for duplicate values. http://support.microsoft.com/default.aspx?scid=kb;en-us;209479 HTH

Check out this MS Knowledge Base article. Might get you started in the right direction: http://support.microsoft.com/default.aspx?scid=kb;en-us;231797

Hold down the SHIFT key as you are opening the database. Then once you're in the database window, re-link the tables using the Linked Table Manager.

If you want to loop through the controls - here's some code you can try: Dim MyForm As Form, C As Control Set MyForm = Screen.ActiveForm On Err GoTo TryNextC ' Check each data entry for visible status For Each C In MyForm.Controls...

I'm thinking this might work - give it a try: Private Sub Document_Number_Text__Box_DblClick(Cancel As Integer) On Error go to HandleError Application.FollowHyperlink "\\NTSRVCA\ENG\DOCSYS\ELK_DWGS\" & Document_Number_Text__Box HandleError_Exit: exit sub HandleError: select case...

I know you set it in code, but have you set it in the actual field's visible property?

Set the Visible property of the field itself to False. Then it won't ever display.

What is the error number that occurs when the file is not found?

Look at the TOP values property of the query (check out MS Access help). Have your date field be the first field in the query grid - have the date field sorted in descending order...then select the Top 2 values. HTH E

You have compacted it ? Just winzip it and then post it on this site. No need to send it through email. E

sorry, but I have no experience with that, so I can't recommend anything...maybe some other experts out there can give you advice here...

I could try to give it a go. Post it and I'll look at it.

Check out this MS Knowledge base article on how to deal with that error: http://support.microsoft.com/default.aspx?scid=kb;en-us;209203

Did you set the database object: set db = currentdb