Search results

  1. J

    version conflict

    Thanks I will be going to the location in a couple of hours so I will see what turns up. I may have to install A97 before this is done....
  2. J

    version conflict

    An application that I made was created in Access 2000 as I was told that all users had at least this or newer. Of course a user with 97 popped up. Instead of having them purchase 2000 or newer I converted my app to 97 version. I expected troubles with references. So far this has only been a...
  3. J

    Deleting oldest file

    Yes it should :) I believe it was part of your backup and zip function, without the zip part. Never could get that to work due to having the evaluation version of winzip. Thanks for the link, I did search but didn't find that. I will check it out.
  4. J

    Deleting oldest file

    I decided to get it done with a batch and here is what I came up with: @echo off md c:\aa\now rmdir c:\aa\6daysold /s /q xcopy /e "c:\a" "C:\aa\now\" rename c:\aa\5daysold 6daysold rename c:\aa\4daysold 5daysold rename c:\aa\3daysold 4daysold rename c:\aa\2daysold 3daysold...
  5. J

    Deleting oldest file

    Greetings! I am using this in a module to copy files to a directory: ---------------------------- Public Function Backup() Dim fso As FileSystemObject Dim sSourcePath As String Dim sSourceFile As String Dim sBackupPath As String Dim sBackupFile As String sSourcePath = "c:\a\" sSourceFile =...
  6. J

    Only Allow updates after button click

    Check out this excellent solution by ghudson: http://www.access-programmers.co.uk/forums/showthread.php?t=74920&highlight=mouse+trap
  7. J

    Hyperlink to different part of same (very long) form

    I played around with this a bit and found this: I used the setfocus command. You cannot setfocus to a label from the looks but you can a text box. So, if you place a one character long text box next to the label that you want to link to, then on the top use the setfocus command in the onclick...
  8. J

    grey/disable fields

    The first thing that comes to mind is to close your form (data entry form) and open another form set to allow edits = no when they click the button.
  9. J

    protect field data from deletion

    How about something like this in the oncurrent event of your form? If IsNull(Me.YourProjectNameControl) Then Me.YourProjectNameControl.Enabled = True Else Me.YourProjectNameControl.Enabled = False End If You will have to set the enabled value of YourProjectNameControl to no If there is a...
  10. J

    Updating Front End Strategy

    I have been doing this same thing for nearly 2 years now without a hitch. My DB is split into FE and BE and they both reside on the server. It makes it easy to update the application as there is only one DB to change and as long as the name and location remain the same, you are golden with the...
  11. J

    I need a form for selecting input files

    Or maybe this: http://www.access-programmers.co.uk/forums/showthread.php?t=75790
  12. J

    Confused by 'Tag'

    I'll give it a go What is the TimeRequired control, a check box, combo, ?? If it is a check box then this should work in the after update event: If Me.TimeRequired = Yes Then ctl.Visible = False End If My point is to use the correct value. Perhaps -1 is not correct in your usage
  13. J

    Using a combo box to filter results

    No problem... just glad we got it straightened out! :D
  14. J

    Using a combo box to filter results

    What is this anyway? Look at the first post in this thread. The first post is by Neil_Pattison and he is the person that started this thread. You got me confused with him and thought I was the original poster and chewed me out for not answering you correctly. I had simply answered Neil_Pattison...
  15. J

    Using a combo box to filter results

    I didnt know there was another thread at the time!! Sorry
  16. J

    Using a combo box to filter results

    I just threw that db together quick to see if it is what Neil_Pattison was looking for. He is the original poster :D
  17. J

    Weird Error

    First thing I would do is... Reboot and try again If its still an issue.... Shut down all running applications Run defrag Run Scan Disk See what that tells you If all is well then you may have had a memory stick go bad
  18. J

    Using a combo box to filter results

    Like this??
  19. J

    Show Zero

    How about setting the default value of the forms control to 0
Back
Top Bottom