Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ianbar

    one command, two events

    Yes. You can. Create a Private Sub, like this: Private Sub HelloWorld MsgBox "Hello World!", VbOkOnly, "Hello" End Sub Then under the on and after update subs: Call HelloWorld Hope that helps.
  2. ianbar

    if item has focus

    When a button is clicked. Hope that's suffiecient.
  3. ianbar

    if item has focus

    I need to write a large if statement checking which items have focus. How do i check if an item has focus? If Me!Page4.?????? Then blah blah Thanks.
  4. ianbar

    Complicated Timer

    Thanks very much!
  5. ianbar

    Complicated Timer

    I have built my wizard interface (using the tab control)for completing a form. The wizard form is called when a new record is created, the wizard guides users through test proceedures and provides fields for the results to be entered. These results are then transferred into a results form (once...
  6. ianbar

    Wizard Interface

    Sorry I should have made myself clearer. I was using a tab control. I have sorted it out now. Thanks for the reply anyway.
  7. ianbar

    Wizard Interface

    I am creating a wizard interface for completing a form, does anyone know the vb code to show the next tab when clicking on a cmd button? So I can have Next and Prev buttons. Thanks.
  8. ianbar

    Access 2k Vs XP problem.

    I checked all the references and none were missing except in the ones I have ticked: Visual basic for applications Microsoft Access 9.0 Object library OLE Automation Microsoft ActiveX data objects 2.1 library Microsoft script runtime MISSING: Microsoft Common Dialog Control 6.0 (SP3) Microsoft...
  9. ianbar

    Access 2k Vs XP problem.

    The error is: Compile Error: Can't find project or library. So it's obvious that a library is missing. Habve I referenced the wrong thing above?
  10. ianbar

    Access 2k Vs XP problem.

    I have referenced the Microsfot DAO 3.6 Object Library as this was the only thing with DAO in it in the reference list. But it still fails to work!
  11. ianbar

    Access 2k Vs XP problem.

    Access 2000 has error with the following code: Private Sub Form_Open(Cancel As Integer) Forms!hyperlink_builder!txtname = Left(Forms!AddRecord!RaisedBy, 3) Me!txtname = UCase(Me!txtname) Forms!hyperlink_builder!txtdate = Format(Forms!AddRecord!DateRaised, "ddmmyy") End Sub I'm sure...
  12. ianbar

    Check if new record added to DB

    I'll have to think this one over! Think I have an answer though! Thanks for the advice.
  13. ianbar

    Check if new record added to DB

    I would like a reminder to appear when a new record has been added to the database. The reminder needs to prompt the user if they wish transfer some files (a seperate form performs this function). Any ideas?
  14. ianbar

    File Selection

    That's what I did. I called the module BrowseFolder. With the code I put up behind a button to call the module.
  15. ianbar

    File Selection

    I get an error: 'Compile Error: Expected Variable Proceedure, not module.' I have this code behind the on_click action of a button: Me!OFT_Temp_Folder = BrowseFolder("Find Path to folder")
  16. ianbar

    File Selection

    I have a parameters table (which holds the paths of several folders on a server). I have added text boxes to the form and I can edit the folder paths. I would like a user to be able to click a button and launch a save/save as style wizard that the user could use to find the folder and then the...
  17. ianbar

    Copy files using access

    I see! I thought that unloaded the current function, in this case CopyFile and then I was loading in the next function. Oh well, it's sorted now. Thanks very much for all your help.
  18. ianbar

    Copy files using access

    Your right, how dumb am I? It didn't work with the old code! Could you help me with the removal of the original file in the temp folder? Here's the code I tried: ------------------------------------------- Private Sub cmdtransfer_Click() Dim objFSO As FileSystemObject Dim Msg, title, Response...
  19. ianbar

    Copy files using access

    Private Sub cmdtransfer_Click() Dim objFSO As FileSystemObject Dim Msg, title, Response, Style As String Msg = "This option will overwrite older files, do you wish to proceed?" title = "Warning!" Style = vbYesNo + vbCritcal + vbDefaultButton2 Response = MsgBox(Msg, Style...
  20. ianbar

    Copy files using access

    I'll post it monday. I'll have to recode it!

Part and Inventory Search

Back
Top