User Profile

Collapse

Profile Sidebar

Collapse
lollebolle
lollebolle
Last Activity: Jun 24 '08, 10:40 AM
Joined: Jun 22 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • lollebolle
    replied to Formats: Clearing all text-, check and comboboxes except for one box
    in Access
    Hello linq,

    indeed, my excuses for the confusion, I mean form. It is indeed for clearing fields to enter a new record.
    My form is unbound and I'm using the VB funciton "Date()" as default value but after clearing this field is also blank.

    Does this help you?

    Thanks,
    Tom...
    See more | Go to post

      Leave a comment:

    • lollebolle
      started a topic Formats: Clearing all text-, check and comboboxes except for one box
      in Access

      Formats: Clearing all text-, check and comboboxes except for one box

      Hi Expert,

      I want to clear all fields in a format when I push my clear button except for the textbox ' Date ' which contains the current date as a default value.

      I'm using the following code:
      Dim ctl As Control

      For Each ctl In Me.Section(acDe tail).Controls
      Select Case ctl.ControlType
      Case acTextBox, acComboBox
      ctl.Value = Null
      ...
      See more | Go to post
      • lollebolle
        started a topic Converting a matrix to a table
        in Access

        Converting a matrix to a table

        Hi,
        I have an excel file with a large matrix which I uploaded in Access but I want to transform this to a normal table to be able to work with it in Access. Can I link the headers of this matrix table with a primary key in another table to get a new table which is not a matrix?

        Thank you,
        Tom
        See more | Go to post
        No activity results to display
        Show More
        Working...