User Profile

Collapse

Profile Sidebar

Collapse
vspsdca
vspsdca
Last Activity: Dec 5 '08, 02:31 PM
Joined: Aug 8 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • vspsdca
    replied to Underlying table not updated
    in Access
    Thank you soooooooooooooo ooooo much!!!!! It's works!!!!!
    See more | Go to post

      Leave a comment:

    • vspsdca
      started a topic Underlying table not updated
      in Access

      Underlying table not updated

      Hello,
      I've seen a few topics regarding the abovementioned subject, however, I still couldn't get my form to work.

      Here's my scenario, I have a form linked to a single table. There are 2 date fields that need to be populated.

      1. Date Request Raised
      2. Date Allocated

      Date Allocated should be defaulted to Date Request Raised. I was able to make it work by setting Default Value to =[Date...
      See more | Go to post
      • vspsdca
        started a topic Computing number of days between 2 dates not counting the weekends.
        in Access

        Computing number of days between 2 dates not counting the weekends.

        Hi,
        I'm quite new to the world of VBA so any help you could extend will help me a lot with my project.

        I have a database of Change Requests from our users. I have two date boxes, one is Date Request Raised and Deadline for Entry. What I'd like to happen is when I enter the date on the Date Request Raised the Deadline for Entry would automatically be filled based on the Asset type that was selected.

        For example:...
        See more | Go to post
        • vspsdca
          replied to Hyperlink Not Working, Run-time error 7971
          in Access
          Thanks so much!!!! It finally worked!
          See more | Go to post

            Leave a comment:

          • vspsdca
            replied to Hyperlink Not Working, Run-time error 7971
            in Access
            Thank you for your reply. Being a newbie I hope you wouldn't mind me asking you a few more questions regarding the code you have provided.

            1. Do I replace my module code with the the code below or do i leave the module code as is? Do I put on this the On Click event of my browse button?

            Execute the following code whereever appropriate:

            Code: ( text )
            Dim strFolderName As String
            Dim result...
            See more | Go to post

              Leave a comment:

            • vspsdca
              started a topic Hyperlink Not Working, Run-time error 7971
              in Access

              Hyperlink Not Working, Run-time error 7971

              Hi,
              I'm a newbie here and does not really have any formal training on VBA. I just need help to get my hyperlink to work. I have a form in MS Access with a browse button where a user can select a folder from a specified directory from our network. I was able to get the browse button working where it saves a path that is selected onto the textbox that is set as hyperlink. The problem appears when you click on the hyperlink... it will work a...
              See more | Go to post
              Last edited by Stewart Ross; Aug 22 '08, 12:16 PM. Reason: Please use the code tags provided around your code extracts
              No activity results to display
              Show More
              Working...