User Profile

Collapse

Profile Sidebar

Collapse
smiler2505
smiler2505
Last Activity: Apr 12 '08, 11:50 PM
Joined: Apr 25 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • For reference sake:
    frmCLOSE:
    Code:
     Sub Form_Open(Cancel As Integer)
    DoCmd.Close acForm, "frmOrd", acSaveYes
    End Sub
    Sub Form_Timer()
    On Error GoTo ErrorsoExit
     
    NewData = Left(OpenArgs, InStr(OpenArgs, ";") - 2)
    Store = Mid(OpenArgs, InStr(OpenArgs, ";") + 2)
    CurrentDb().TableDefs("tblOrd").Fields("Ent").ValidationRule = CurrentDb().TableDefs("tblOrd").Fields("Ent").ValidationRule
    ...
    See more | Go to post

    Leave a comment:


  • Its fixed! I just have to find the right name for the row source property, but thanks for your help!
    See more | Go to post

    Leave a comment:


  • How do I delete messages lol?! This comment is no longer applicable
    See more | Go to post

    Leave a comment:


  • When you say put the close event in another event, do you mean call it from timer?

    Also, the rowsource has the newdata (from NotInList event) added to it. How can I pass this onto the timer event?
    See more | Go to post

    Leave a comment:


  • Code:
     ...  
    Loop
    MsgBox (SysCmd(acSysCmdGetObjectState, acTable, "tblOrd"))
      CurrentDb().TableDefs("tblOrd").Fields("Ent").ValidationRule = CurrentDb().TableDefs("tblOrd").Fields("Ent").ValidationRule & """ & NewData & """
    ...
    Gives 0, ie, the table is closed. So I assume it's something to do with the code (it gives...
    See more | Go to post

    Leave a comment:


  • Code:
    Sub cmbEnt_NotInList(NewData As String, Response As Integer)
     DoCmd.OpenForm "frmClo"
    End Sub
    Code:
     Sub Form_Open(Cancel As Integer) 
    
     Answer = MsgBox("That data inputter is not currently listed.  Would you like to add them now?", vbYesNo, "New data inputter?")
     
     If Answer = vbYes Then
     
      Dim daodb As DAO.Database
      Dim daotdfOrd As DAO.TableDef
    ...
    See more | Go to post

    Leave a comment:


  • It's obvious now you say it! Ill try that now, thanks
    See more | Go to post

    Leave a comment:


  • have you removed the virus? that would be a start...and would probably fix your problem
    See more | Go to post

    Leave a comment:


  • smiler2505
    started a topic 3422 error when modifying table from form

    3422 error when modifying table from form

    Code:
    Sub cmbEnt_NotInList(NewData As String, Response As Integer)
    
     Answer = MsgBox("add?", vbYesNo, "add?")
     
     If Answer = vbYes Then
     
      DoCmd.Close acForm, "frmOrd"
      CurrentDb().TableDefs("tblOrd").Fields("Ent").RowSource = CurrentDb().TableDefs("tblOrd").Fields("Ent").RowSource & ";" & NewData
     
     Else
    ...
    See more | Go to post

  • smiler2505
    replied to FILEMON won't work; MSCONFIG issues
    you can't block stuff being added to the msconfig startup items, unless you disabled your user permissions to that key. It's under HKLM, and is called run, runonce, run-, and runonce-. Think it is HKLM, software, microsoft, currentversion, run
    See more | Go to post

    Leave a comment:


  • the way you've done should be sufficient...is the computer slower when LAN is enabled, or is it when you open a browser? If its when you open a browser, open up IE, and see if the number of processes increases by more than 1...

    look to see if the percentage processor used increases when lan is enabled/disabled or a browser is open/closed.

    Check that the show processes from all users box is ticked, and that show 16-bit...
    See more | Go to post

    Leave a comment:


  • hmmm...there must be some software running when the internet is on to make this happen...scan for spyware, malware, adware, viruses. Then try a different browser, see if that makes a difference.
    See more | Go to post

    Leave a comment:


  • smiler2505
    replied to Opening form after error
    I figured it out!
    DoEvents wasn't working, but it had something to do with time; I had to wait for the error code to finish.

    So...

    Code:
    Sub Form_Error(DataErr As Integer, Response As Integer)
     If DataErr = "2580" Then
      
      Response = acDataErrContinue
      DoCmd.OpenForm "FormFix"
      
     End If
     
    End Sub
    Code:
    Sub Form_Load()
    	Me.Visible
    ...
    See more | Go to post

    Leave a comment:


  • smiler2505
    replied to Opening form after error
    will do.
    does anyone know if there is a timer function in vba?...
    See more | Go to post

    Leave a comment:


  • smiler2505
    replied to Opening form after error
    I have tried:

    1. Building the table, and reopening the form after this has been done.
    This built the table, but did not reopen the form.
    2. Building the table, closing the form, and reopening it after.
    This caused Access to crash, but if the form was closed after the table was built, the table existed.
    3. Building the table, refreshing the form.
    Table is built, but no form appears.
    4. Building the...
    See more | Go to post

    Leave a comment:


  • smiler2505
    replied to Opening form after error
    I did the compiling thing, that's how I found out what was causing the crash.

    On the form_error event, I included the code to build the table, and then put 'Me.Requery', 'Me.Repaint', and 'Me.Refresh', all to no effect; the table could not refresh when the form was opening.
    See more | Go to post

    Leave a comment:


  • smiler2505
    replied to Shut Down Problem
    Uninstall Logon screen.

    There isn't another solution. If, after installing software, you start having a problem, then you get rid of the software...I'm assuming you mean windows takes a long time to shut down? unless you exit this program before shutdown you'll have the problem. It doesn't sound terribly useful anyway, what does it do?
    See more | Go to post

    Leave a comment:


  • smiler2505
    replied to Opening form after error
    Tried it!

    Basically, I can't open a form using DoCmd.OpenForm, because no form opens, and if I close the form then open it, using DoCmd.Close, access crashes, even if it is in a seperate sub, form, or module.

    So, I think I'll just put an MsgBox at the end of the script and ask the user to reopen the form because an error has occured and has now been fixed.

    That works at least! It doesn't solve the problem,...
    See more | Go to post

    Leave a comment:


  • smiler2505
    replied to Opening form after error
    Form open, form load etc do not work. The error of there being no record source for the form comes up first.

    With the 'checking on database load'; is there anyway to loop it, so it always checks for the presence of the tables; if they don't exist, build them? Or to make a preliminary check before forms are opened?
    See more | Go to post

    Leave a comment:


  • smiler2505
    replied to Opening form after error
    Code:
    Sub Form_Load()
     On Error GoTo Notable
    
    Notable:
    Select Case Err
     Case 0
      Resume Next
     Case 2580   ' catch the specific error
      Call FormFIX
     Case Else   ' All other errors will trap
      Beep
      MsgBox Err.Description
      Exit Sub
     End Select
     Resume 0
    End Sub

    Error still comes up, and the table is not built. FormFIX is a...
    See more | Go to post
    Last edited by NeoPa; May 3 '07, 12:07 PM. Reason: Tags

    Leave a comment:

No activity results to display
Show More
Working...