Search results

  1. G

    Choose between test and live back end files

    Hi, I have a split accdb in Access 2010 with tables/data in the back end file (stored on a network drive) and the forms, queries and code in a front end file stored on each desktop. Note the front end file is common to two back end files. Both back ends will be mirrored but I need to use one...
  2. G

    Need to add complex criteria to a query

    Hi, I've got two tables in my Access 2010 database - both are identical in structure, the difference being one (Dove) contains old data and the other (Dove Data File) contains updated data. The primary key for these tables is "TowerBase". I want to use an update query to update only the...
  3. G

    Concatenate person's name and initials

    Hi, I'm after some help to concatenate a number of fields from a table into a query please. The fields are: Prefix Firstname MiddleInitial MiddleInitial2 MiddleInitial3 Surname Note that there will be varying combinations: some people will have a Prefix, Firstname then surname (no middle...
  4. G

    Question Use Excel formula in Access

    Hi, I have a weight conversion formula in excel which looks at the values in two different cells and provides a result in a third cell. I could really do with this 'conversion' happening in a query in Access based on values within two fields which are in the same table (I have Access 2010)...
  5. G

    Display value from query on sub form

    Hi, How can I display the count value from a query on a subform for the related/selected record? I've tried a DLookUp without success (the text box remains empty): =DLookUp("[CountOfMethodID]","Methods count","[MethodsRungVisitID] = Form![Form4b]") Here's my table/query/form info: Query is...
  6. G

    Return records from one table based on date in another

    Hi, Not sure if this might come under Forms or Queries, so I'll try here first. When I add a record to table A (using a form) the first field I enter is a date. That date will then determine which records I see in my drop down list from table B (via a query). Some records in table B have...
  7. G

    Copy value from field in subform to field in mainform during data entry

    Hi all, Firstly, I apologise in advance for being an Access 2010 novice, but there is something I really need help with. How can I get the value from a field in one table (in the sub form) to copy/insert into a field in another table (in the main form) when adding a new record? The main...
Back
Top Bottom