Recent content by Dennisk

  1. Dennisk

    Date Difference

    why did you remove the year, once you did that technically speaking you dont have a date. DateDiff requires a full date dd mm yyyy.
  2. Dennisk

    Adding a margin to a combo box...

    create an empty first column, and set the width to a mm or so. this will give you a margin on the left, do the same for a final column and you have a margin on the right.
  3. Dennisk

    cell value change

    you may be better off posting this in the Excel forum and not the Access forum.
  4. Dennisk

    [Access] How to create tables in emails using VBA in access?

    wht not output the data to a spreadsheet and attach that?
  5. Dennisk

    Question Relink tables in access 2007 runtime mode.

    use relinking in a module. Here is the code I use, just set the path in the variable. Private Sub RefreshLinks() ' DAO Data Library Dim tblDefs As TableDefs Dim tblDef As TableDef Dim strConnection As String Set tblDefs = CurrentDb.TableDefs ' LIVE Production Database...
  6. Dennisk

    The auto-incrementing ID field becomes radom number

    that is what it is supposed to do when replicating. The auto number is generated using a randomizing algorith, so that any other databases in the replication group do not generate the same number. It's really irrelevant what the number is so long as its unique.
  7. Dennisk

    Showing "sub" expandable related tables in form

    you require a main form and subform. Although it will not look like the expanded tables it will work the same. Create two forms and drag the subform onto the mainform. A wizard may run to set up the primary and foreign keys, but I would check it yourself.
  8. Dennisk

    Too Few Parameters Expected 3 Error 3061

    do you have the lines of code in the correct order Assign SQL_String then your open statement
  9. Dennisk

    Hide Textboxes on Reports

    set the can grow and can shrink property of the text box to yes
  10. Dennisk

    Auto Increment Default Value

    only use the dmax function if the the db is single user only, otherwise you will need to embed the dmax function in a locking function, otherwise 2 users WILL return the SAME number.
  11. Dennisk

    help with delimiter

    use the INSTR function. This will give you the position of any character in a string. The use the Left$ function and Right$ function to get the two fields
  12. Dennisk

    What do you do in your spare time?

    Spare time is taken up by, growing cacti and succulents, reading (esp. science books on quantum theory), photography and jazz guitar. I also am interested in recreational programming, but .net is far, far to slow and all my programming projects have grounded to a halt. I may start again but on a...
  13. Dennisk

    Login form

    use Access workgroup security. search the forum as countless pages have been written about this subject
  14. Dennisk

    Filter all DB records by one combo selection on DB entry

    I would pass the filter information to each form as an argument in the open statement. Each form would then check (in the on open event) if an argument was present, if so then use that argument in an apply filter statement.
  15. Dennisk

    Multiple Text Boxes linked to ComboBox

    we need to see which event the code you have posted is run from.
Top Bottom