Search results

  1. T

    Highlighting a duplicated entry in a continuous form

    Hi all. Hope this makes sense. I have a master table (tblJobs) and sub table (tblPlant). tblJobs contains the primary data about a job. tblPlant is linked so that plant costs can be added to the job. Data is entered using a single form for tblJobs (i.e. the job) and then a sub form linking...
  2. T

    Database Size, Table Back End, Compact and Repair

    Hi everyone. Sorry for the ramble, hope it makes sense. I'm using Access for data source back end tables as well as front end windows (objects - forms, reports etc). Back end and front end are split due to multi user front end requirements. All on on a local area network. We had a minor...
  3. T

    Incremental Numbering on a Continuous Form

    Hi all I have a 'to do' list (on a continuous form) where I want to change the order of things periodically. I am using an incremental numbering system using 10, e.g. item 1 = 10, item 2 = 20 and so on. If I need to squeeze something in I can use e.g. 22 or I can manually renumber everything...
  4. T

    Question Looping Records to Create Directories

    Hi all, usual apology in case this has been done before (I'm sure it has!). I have a recordset (the table is called tblJobTitle) and I want to loop through all the records and create a windows folder (MkDir) in my P directory with the name of the field/control [JobTitle]. This is what I...
  5. T

    Recordset.AddNew or acCmdRecordsGoToNew

    Hi all Please can you advise on following. When I add a new linked invoice to a customer record for the first time it only works if I use - Recordset.AddNew If there are already linked records then this works fine - DoCmd.RunCommand acCmdRecordsGoToNew BUT If I use Recordset.AddNew the...
  6. T

    Using SelTop on a continuous form

    Hi all I have a main form and a sub form. The sub form is continuous. I want to add a button in the main form that sets focus on the sub form, goes to the last record in the sub form but shows the last 'x' number of records (can get about 20 in the main form space allocated to the sub form...
  7. T

    Copy and Pate Using SelStart

    Hi all Got myself a bit stuck and possibly not starting in the right place to begin with ! Using Access 16 I want to use code to automate a copy and paste process. Copy from 2 controls/fields/Text Boxes on 1 form (frmEmail [Details] and [Body]) and paste into a single control in...
  8. T

    IsNull or Less Than

    Hi all May just be wrong end of day but can you help with this one please. I'm trying to make sure that an end user can not enter a value which is either Null or less than the existing value. This code brings up a message box if null or less than 19500 but rather than specify a number, i.e...
  9. T

    Allow Form Editing

    Hi all. Just getting into coding but been using Access for a while. Could use some help on allowing editing please. I have a form which I've locked 'OnCurrent' using : Me.AllowEdits = False Me.AllowDeletions = False Me.AllowAdditions = True I then have btnedit button to change...
  10. T

    Hi from Tim in Norwich England

    Using Access more with increased use of code insted of wizards and macros so need a little help here and there please thanks.
Top Bottom