Search results

  1. A

    Need help creating query

    Hi, Please can someone help me create a query that looks up two queries and comes back with the lines that don't match. Basically I have two queries (qry1 & qry2) with both have a number field - AA_NO and a date field - AA_DATE. I want to find the records in the queries that don't have the...
  2. A

    Help with SQL code in Module

    Please help I've written the code below so that when a name is selected in a list (lstName) the code adds a line to a table (tbl_logon_history) to show when someone logged on. However I keep getting an error: "Syntax error in INSERT INTO statement" Please can someone tell me what I'm doing...
  3. A

    Trouble shooting login scrip MS Access 2007

    I have a login script but I cannot see why there is an error, here is the code: Private Sub cmdLogin_Click() 'Check to see if data is entered into the UserName combo box - works fine If IsNull(Me.cmboLogon) Or Me.cmboLogon = "" Then MsgBox "You must enter a User Name.", vbOKOnly...
  4. A

    changing subreport details

    I'm trying to change the source of a subreport. but the code I'm using doesn't work. Can anybody help me? code I'm using is: DoCmd.SetValue Reports![Main_Report]![SubReport1].SourceObject.stSRreport I've also tried DoCmd.SetValue Reports![Main_Report]![SubReport1].SourceObject =...
  5. A

    Export to Excell loses words

    When I export my database report to excel I lose any characters in cells which are over 255 characters. Please can anyone show me how to get around this? Thanks
  6. A

    How do I get the last record for an item without the rest of the history

    I have a database with a few thousand items on it. Each of these items has a history associated to it using a different table. How do I get a query to produce the last record in the history for each item, without getting all the places that item has been in the past as well as the current...
Back
Top Bottom