Search results

  1. N

    Double Click subform dataview record to add to second subform

    Hi all. I have a parent form with two sub-forms on it. The first sub-form is filtered by selection on parent form. However what I want to do is double click the record in the first sub-form which will then populate an entry in the second sub-form. If I double click again on the first sub-form I...
  2. N

    Nz Function for Access VBA DATES

    Hi, having sorted my previous issue with nz, I am now stuck trying a similar approach to dates. I have my mainform, and a subform is updated with a button onclick event. My mainform contains two textboxes which are formatted for dates and has datepickers etc. My query runs ok using NZ but as...
  3. N

    SQL with NZ in VBA

    Hi, i'm struggling with using Nz with SQL in VBA, I believe it's the use of " that might be the issue. Would one of you kind fellows be helpful enough to show me where I might be going wrong? The idea is that there is some data in a single table which isn't relational, but the user wants to be...
  4. N

    Split() function and searching with the results

    Hi all, I am trying to gather a bit more knowledge and am working towards a search form which will help me through my day a bit more efficiently. I have a mainform, and a subform. The main form is unbound and has several textboxes which when not null or empty, are used as query criteria to...
  5. N

    SQL command

    Hi, I am running a form with a subform, the main form has several search boxes but I want the query to work primarily from two. i.e. OD and ID What i'm after is typing a number in the OD textbox, same for the ID textbox and the query return any record where the OD is between = OD-1 and OD+1...
  6. N

    Between on two fields

    Good morning all I have a query which populates a subform based on values as below: main form txtOD, txtID textboxes with an afterupdate event on each set to requery the subform I want the query to be able to show all records if nothing is entered in any of the 2 search boxes. I would have...
  7. N

    Pass Through Query

    Good afternoon Gents and Gentesses I am looking at Access 2010, and am in the process of creating a small database that will look at Sage 200c data directly on the server and hopefully not lock any tables and records while I run queries on it. I have a form (frmMainForm) On frmMainForm there...
  8. N

    Dlookup Failure

    Good afternoon peeps A question from someone only just walking into SQL, so please forgive that the question I am asking, might not actually be the right question. I will explain what I have done previously and am attempting to do now: Access 2010, ODBC connection to Sage 50, worked very...
  9. N

    ODBC Data into Access Query/Subform

    Good afternoon, many thanks for taking the time to read my post. I'm sorry if this seems like an obvious thing to know, but because I don't quite know how to ask the question it makes things more difficult. I have a database, which I have attached Access to via ODBC, the tables are linked, not...
Top Bottom