Search results

  1. L

    Multiple Users add new row in Table

    Hi, I've got a database with multiple users. When they add a new row (using a form) it replaces another row that was just added by someone else. Very strange?? I use the following; Set db = CurrentDb() Set trs = db.OpenRecordset("FTE") ..... some code trs.AddNew trs.Fields("Source") =...
  2. L

    Import Array into Table

    Hi All, I've got an Array which I want to import into a table. How can I do that? Lenny:)
  3. L

    Button Control Class Not working

    Hi All, How can I get this to work? I've got about 15 Comboboxes which has to do a particular macro. Here's the VBA; Public Sub Form_Open(Cancel As Integer) ButtonCount = 0 For Each ctl In Me.Controls If TypeName(ctl) = "Combobox" Then ButtonCount =...
  4. L

    Filter Table Problem

    Hi All, I've been reading through previous posts on "Filter on tables", but somehow can't figure out my problem. I've got a form called "FilterForm" with a subform called "CCID subform" On After Update from ComboBox "cbFilter" it need to filter on the "CCID subform" in column "acc". Please...
  5. L

    Clear Column in Table

    Hi All, How can I clear the data from a specific Column within a Table? Lets say; Table name is "Test", Column 1 is named "A" and Column 2 is named "B". And I only want the clear the data in column "B". The record count I've got is over 130.000, so if there's a quick and easy way then I am...
Back
Top Bottom