Recent content by jkokkelmans

  1. J

    Date/Time control

    Use the default property of the dtpicker and use hidden textboxes or variables to work with the values datetimepickerFrom = Date datetimepickerTill = Date - 8 txtFrom = Format(datetimepickerFrom, "mm/dd/yy") txtTill = Format(datetimepickerTill, "mm/dd/yy")
  2. J

    Forms won't launch

    It seems your database is slightly corrupted; use the backup file. Access can't find the module of the form. If you didn't put any code behind the form you can set the Had Module property of the form to False. Watch out; A button made with a wizard makes code to!!!
  3. J

    Very very light security

    How bout this; Me.AllowEdits = False
  4. J

    Refering to subform control from main

    Use Form_frmTM0002_Subform.txtTaskOwner = Me.cmbOwner to call an item on a subform To update the subform use Form_frmTM0002_Subform.requery
  5. J

    Create/Delete Set of Records

    To copy the child records use 2 recordsets, rsOldChilds and rsNewChilds, loop through rsOldChilds while adding a record to rsNewChilds, set the fiels of rsNewChilds to rsOldChilds accept the MasterID, this has to be set to the new MasterID of your new Invoice. After looping through rsIldChilds...
  6. J

    Change Background apperance

    People, I want to change the background of the MDI Window, is there a way to change the color without changing the Windows settings? I am using frmBack for displaying info on the back of my app. but I want it to be maximised. If I maximise the form all other forms are maximised to. I can...
  7. J

    Setfocus

    <Name textbox>.Setfocus instead of DoCmd <Name textbox>.text = "0"
  8. J

    Count the midday between two date

    dim intMidDays as integer intMidDays = DateEnd - DateStart IF (DateStart > 14:00) AND (DateEnd < 13:00) THEN intMidDays = intMidDays - 1 ElseIf (DateStart < 14:00) AND (DateEnd > 13:00) THEN intMidDays = intMidDays + 1 End If
  9. J

    Problem with delete Record

    Using the Delete method marks the current record or a group of records in a Recordset object for deletion. If the Recordset object doesn't allow record deletion, an error occurs. If you are in immediate update mode, deletions occur in the database immediately. Otherwise, the records are marked...
  10. J

    Network Load between local DB en Network DB

    Can anyone tell me how access 2000 handels the data streams between local and network database if there is no file handler installed on the network location? I have a >1Gb DB on the network but still is works pretty fast to get data from the network to the local DB. Is it because OLE DB (ADO)...
See more
Back
Top Bottom