User Profile

Collapse

Profile Sidebar

Collapse
johnnyc
johnnyc
Last Activity: Nov 3 '11, 07:41 PM
Joined: Oct 17 '11
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • Does Share Point have the ability to be used as a full CMS?

    We have a share point environment here and we use it as a CMS to edit text and add images to our site. Can share point (perhaps 2010) be used as a full CMS where it can create and delete pages, and once it does have the navigation reflect those changes?

    Meaning give the user the ability to do all these things along with the WYSIWYG editor.

    Any help is greatly appreciated!

    John
    See more | Go to post

  • Learning is great. I have followed your instructions from the post about variable declaration.I will debug all weekend and come back to this post once I debug. Thank you both
    See more | Go to post

    Leave a comment:


  • Pat,

    I just found out that I needed to compile. The compile button was never added to my VBA layout and I had no idea I needed to compile each time. So after a few too many compile errors and getting around them it seems that some of my code was lost when I opened the ".accdr" file. I am re writing all my updates and will put in the above code, compile and see if it works. Thank you for that btw!
    See more | Go to post

    Leave a comment:


  • Pat,

    Nothing happened, here is my code:

    Code:
    Private Sub substatus_AfterUpdate()
            MsgBox Me.SubStatus
            If Me.SubStatus = 3 Then
            
            Me.ContractDeliverd = -1
            Me.DeliveredDate = Now()
            
             DoCmd.Requery "substatus"
    Exit_substatus_AfterUpdate
          
    End Sub
    Is there a way to check another way...
    See more | Go to post

    Leave a comment:


  • Pat,

    Here's my latest code, I feel like were getting closer but it does not work:

    Code:
    Private Sub substatus_AfterUpdate()
            
            If Me.SubStatus = 3 Then
            
            Me.ContractDeliverd = -1
            Me.DeliveredDate = Now()
          
    End Sub
    See more | Go to post

    Leave a comment:


  • Pat,

    You're right, the check box only works if it is clicked then the date shows up. I want to see if I can have the program check it and then fill in the date once the third option from the dropdown menu Substatus has been selected.

    And you just pointed out a flaw, Status is another drop down menu above Substatus drop down menu. Status has no relevance. So should my code be
    Code:
    If Substatus = 3 Then
    It does not...
    See more | Go to post

    Leave a comment:


  • Pat,

    Thank you so much for the help. So you're saying that even if the code worked and the check box was clicked it will not set off the date.. I was not aware. Also thank you for your advice I will make sure to get better names on the controls and labels.

    I've tried the code above but it does not seems to work. Would I be better placing this code in a different event such as On Change or On Click or is this the right event?...
    See more | Go to post

    Leave a comment:


  • I can only see inserting an image link not an attachment on this reply box. Is there a way to place an attachment here? I have only seen that when I started my post.
    See more | Go to post

    Leave a comment:


  • If item selected from dropdown activate check box ?

    Hello,

    I have a drop down menu with four items. Then below that I have a check box and a date field. Currently if you are to click on the checkbox the date field updates with today's date.

    However I would like it if a user checks the third option down "Contract Delivered" to then update the checkbox. Check itself which then will also update the date field.

    Here is my logic and I'm new to VBA Access,...
    See more | Go to post

  • Great stuff Seth, it worked. Thank you sir!
    See more | Go to post

    Leave a comment:


  • Hello Knight,

    If it's not possible for you to switch to Windows servers then try this:

    http://www.mono-project.com/Main_Page

    Here is a quick overview of it:

    http://www.cyberciti.biz/faq/how-to-...laris-freebsd/...
    See more | Go to post

    Leave a comment:


  • My date field displays pound signs instead of numbers

    I have a field that is supposed to display the date but it only does that once I click on it. When I first load my form it only displays pound signs (######), if I click on it I can see my date.

    Unfortunately it is built in Macros, I have attached two screen shots.

    The only event is the On Click and that brings up the Macros menu which is in an image below.

    Any help is greatly appreciated.

    Thank-you....
    See more | Go to post
    Last edited by NeoPa; Oct 20 '11, 02:45 PM. Reason: Made pics viewable

  • Neo,

    I know, when I run a test from scratch and build a new button I get the same thing it should have an Onlick. None of the buttons do, which is strange to me. I scrolled down on the "all" tab as well as the "Event" tab. All my other buttons on the application do have an on-click only these in this sub form do not.

    No events in "After Update" either. There are two after update events but...
    See more | Go to post

    Leave a comment:


  • johnnyc
    replied to VBA Access display label
    You're right. It worked. Thank you!
    See more | Go to post

    Leave a comment:


  • johnnyc
    replied to combining two scripts on one page
    I've had this problem before use "jquery noconflict" I've used it on one of my sites and it solved the problem, I was also using two different versions of Jquery. I can't remember which site it was but if you can't get it working let me know and I'll further assist you.
    See more | Go to post

    Leave a comment:


  • johnnyc
    started a topic VBA Access display label

    VBA Access display label

    Hello,

    I have a form that is locked by default, if a user wants to make an edit they have to hit the unlock button. I want to display a label to let them know the form is locked at the top, so new users don't assume it doesn't work.

    My logic is: The unlock button has a method where it enable edits to the form once clicked. My code based on that is as follows;

    Code:
    Private Sub lbl_unlock_MouseMove(Button
    ...
    See more | Go to post

  • Neo,

    You are most likely right in regards to the macros, there is no On Click property for Toggle28, no other events either for Toggle 28.

    I found the Macros builds but did not see anything in them in regards to the Toggle or any other reference to the fields. I might have to just skip this problem one as it looks like it will need an expert hand to edit this particular issue.

    Thank you for your time! Should...
    See more | Go to post

    Leave a comment:


  • Neo,

    There are no event procedures for any of the events on any buttons unfortunately.

    Not sure if this is right - if not please let me know where else it is located:

    There is a folder called "Modules" that I see from VBA. Under it there are nine macros files:

    basaddalltolist
    basAutomateOutl ook
    basCommonFile
    basCRLF
    basNotinList
    basUtilites
    modGlobals...
    See more | Go to post

    Leave a comment:


  • Neo,

    You have great patience.. Thank you.

    ButtonX is called "Toggle28".
    TextBoxY is called "Word Requested"

    ** Snip **
    See more | Go to post
    Last edited by NeoPa; Oct 19 '11, 03:17 PM. Reason: Removed off-topic comment

    Leave a comment:


  • Neo,

    I don't know much about Access so please bear with me. When I click on the textbox "Type of work Being Requested" under the Properties, then data, it tells me the Control Source is Type of Work Being Requested. Where would/and how would I edit that or find that is it in a module?

    Also all the button on the form are labeled Toggle 23 through Toggle30.
    See more | Go to post

    Leave a comment:

No activity results to display
Show More
Working...