User Profile

Collapse

Profile Sidebar

Collapse
GabyFont
GabyFont
Last Activity: Jan 29 '08, 12:05 PM
Joined: Jan 14 '08
Location: Puerto Rico
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • GabyFont
    started a topic Dealing with compatibility
    in Access

    Dealing with compatibility

    Hi,
    I have created an app in access2007 and publish it into SharePoint. What I wasn't thinking about is that only me and somepartners have installed Access2007, and since I work for a huge company (1500 employees locally) there are no plans yet to install office2007 to everybody.

    Looking for a soloution, I tried to upload the database in compatibility mode, but sharepoint doesn't support access2003. Also my boss suggested something...
    See more | Go to post
    • GabyFont
      started a topic Problems with INSERT INTO
      in Access

      Problems with INSERT INTO

      Hi,

      I'm having trouble with the INSERT INTO statement, I have this code

      Dim SQL As String

      SQL = "INSERT INTO trRecord(Ticket ID, lastModified, modelID) VALUES(" & Me.tickID & ", now(), " & Me.modID & " )"
      DoCmd.RunSQL SQL

      End Sub

      when I try to use it with only one field, it works fine, but when I have more than one field(like...
      See more | Go to post
      • GabyFont
        replied to Editing values from a bounded object
        in Access
        ok, I get you, but how can I do that, since I'm trying to edit the record choosed (by double clicking on it) by the user, in the subform of my main form
        See more | Go to post

          Leave a comment:

        • GabyFont
          replied to Editing values from a bounded object
          in Access
          All controll are bounded to the subform where the user makes it selection...
          See more | Go to post

            Leave a comment:

          • GabyFont
            replied to Editing values from a bounded object
            in Access
            I'm sorry, I didn't remember sending it twice,
            The property of the form is already set to "Edit" also each text box.
            Any other idea???...
            See more | Go to post

              Leave a comment:

            • GabyFont
              replied to Sub Query
              in Access
              I have to do something like that, and this works:
              in the criteria of each field A, B, C, D I something like this, assuming that you have list boxes in a form so the user select it rather than entering the values:

              like [forms]![yourFormName]![field A] & "%"

              NOTE: instead of "%"you can try "*", in Access 2007 the asterisk was get me some trouble

              this allow the user...
              See more | Go to post

                Leave a comment:

              • GabyFont
                started a topic Editing values from a bounded object
                in Access

                Editing values from a bounded object

                Hi,
                I'm new to Access so excuse if my question is too simple. I'm creating an app to manage spare objects in my company. So a user select from list boxes the criteria they want and hit a button that runs a query and display the results in a sub-form in the current view. The user look for the record he needs, and then double-click it. When the record is clicked, another form opens, in this form, there are bounded text boxes with the information...
                See more | Go to post
                No activity results to display
                Show More
                Working...