Recent content by Cosmoman

  1. C

    check if file already exists

    Hi Dave, Here is a question on this. Is it possible to get access to check for a predetermined file on the internet and if it is there let the database open and if it isn't return a message like above? So say this is where the file is ( called load.flag) Http:\mysite.com\project\load.flag I...
  2. C

    check if file already exists

    Thanks Dave, I was able to muddle through it ang get it working without pulling any more hair out lol..
  3. C

    Closing and Access DB after a certain date has been reached

    Your more confusing me than helping....
  4. C

    If Then Statement Referencing Table Columns

    I'm having a bit of the same issue here. I have a table called Expire with a field called Date. Now I was trying to get my splash page to open the main form if the current date has not reached the date in the Expired table. If it has then it gives a message and closed the database. So far I...
  5. C

    check if file already exists

    Dave I have another tricky one if your upto it lol
  6. C

    Closing and Access DB after a certain date has been reached

    This is the code that closes my splash form and #Private Sub Form_Close() #DoCmd.OpenForm "Main Menu" #End Sub #Private Sub Form_Timer() #DoCmd.Close acForm, Me.Name, acSaveNo #End Sub Right now there is no message that is what I am trying to do if the date has reached the expiry date in...
  7. C

    Closing and Access DB after a certain date has been reached

    Im using access 2007. I have a form called splash2 which comes up when the database is double clicked on when tells them when the project will close then that closes after 10 seconds and brings up the main page. I'm just trying to figure the code to put into the spash2 form that will prevent...
  8. C

    Closing and Access DB after a certain date has been reached

    Thanks PNGBill, That's what i'm trying to figure out how to write out.
  9. C

    Closing and Access DB after a certain date has been reached

    I was wondering and have been racking my brains for this. I have a table called Expire and a field called Date. Now I want my Access DB to not open after that date has been reached but to display a message saying project time has expired then close when they press ok. Is this possible?
  10. C

    check if file already exists

    Hi Dave, Thanks this worked out perfectly. Didn't come up with any errors that had to be trapped. Cheers, Rob
  11. C

    check if file already exists

    Hello, I was reading these posts as it was the closest to the issue I am having. I have an access application that is only to be used on certain PC's. Now every ime they open it up and import from a PC that isn't to be used they crash the database. Is there a way I can have the database...
See more
Back
Top Bottom