Search results

  1. J

    VBA User Permissions

    I have done this before: On a form I have a textbox that gets the users logon name. Set the visible property of the command button to no. In the onload event of the form is this: If Me.textbox = "whateveruseryouchoose" Then YourButton.Visible = True End If
  2. J

    Sending and recieving email through access

    I think you would be better off using the auto respond feature in Outlook. Set up a rule that looks for a specific subject such as an ID number for a rep. If that ID number is found in the incoming mail then Outlook sends a preformatted response to this person that contains the update. You...
  3. J

    fixing access file?

    Actually, the only functionality with these is data storage. The DB acts as the BE with only tables included. The FE is done with ASP. Try what mtairhead said if you have another PC available, or else download a clean 2002 DB from snitz or SH and see if you can open that.
  4. J

    fixing access file?

    So, the DB is 2002 AND you have Access 2002 installed on your machine - correct? Have you ever been able to open this .mdb? Do you have any other versions of Access also installed? Even if the runtime of an older version is installed it may be confusing things for the machine. It could be...
  5. J

    fixing access file?

    What version of Access do you have? If the DB was created with Access XP (2002) or Access 2003 and you are using Access 2000 or earlier then this is what will happen when you try to open the file. It has nothing to do with the Snitz forum, I have used them for years. Check your version of...
  6. J

    Disabling Mouse Wheel & Subforms

    Check out GHudsons excellent answer to this problem: http://www.access-programmers.co.uk/forums/showthread.php?t=38364
  7. J

    Blank Screen (No Switchboard)

    It sounds to me as if all of the startup options are turned off in tools/startup. If you turn them all off, quit Access, and restart you will get the exact same situation as described in the first post. If holding the shift key down when starting the program helps, then go into Tools/Startup...
  8. J

    Blank Screen (No Switchboard)

    Try holding down the shift key when you open the program and see if that helps
  9. J

    Disabling a Combobox

    Did you set the enabled property of Left_Innominate_Vein to false in the property sheet?
  10. J

    Disabling a Combobox

    Try this: if IsNull (Date_of_Neck_USS.Value ) = true
  11. J

    How can i pack my access application

    Tools/Database Utilities/Make Mde File
  12. J

    Dynamic Hyperlink Base

    You would not have to add the shell function for every new document. What I could visualize is your users dropping any new documents into the corresponding folder. Then in your DB you could have a list of documents that are available. Your user would add their new document to the list and not...
  13. J

    Application Diagram

    He went back to 1. A wood-encased manual chipping device powered by a heavy blunt striking instrument and a tip renewal tool which may have been broken off from the cave's superstructure. 2. A not so rectangular tablet made of granite, marble, slate or similar substance placed upon any handy...
  14. J

    Dynamic Hyperlink Base

    http://support.microsoft.com/?kbid=829072 This might warm you up to clicking that warning box :eek:
  15. J

    No Tools menu...?

    If you are doing this manually, this may help. It should be possible to run this with scheduled tasks and pop up automatically each day... http://www.access-programmers.co.uk/forums/showthread.php?t=85490&highlight=backup
  16. J

    No Tools menu...?

    If you have not done so, make a backup :)
  17. J

    Dynamic Hyperlink Base

    Actually I was just playing around with this. I found that if you place your doc in a subfolder of the DB folder then you can still reference it locally. For instance... Sub folder of the DB folder.... name it subfol (or whatever you want) In the hyperlink address place...
  18. J

    Dynamic Hyperlink Base

    Maybe this will help, If you store all of your documents in the same folder as your database, then just put the file name in for the hyperlink. Eg. Word doc..... file name is - something.doc In the hyperlink criteria simply put - something.doc When clicked it will look in the current folder...
  19. J

    Reducing Network Traffic

    The processing is done at the server and just a web page is sent to the requestor as a result so the size of transfered data will be relatively small. Your server will have to be asp enabled. This is a simple matter for windows servers and can be included when the server OS is installed, or...
  20. J

    Reducing Network Traffic

    1) Yes that is correct 2) You could use a serverside code such as ASP. This is opened with an internet browser but all of the processing is essentially done at the server. This will work with either Access or SQL 3) I am sure there are some apps out there that will measure this but I havent...
Back
Top Bottom