Recent content by AndyCabbages

  1. A

    Problem Displaying Subforms On A Report

    I have form which I have converted to a report using the guide here: http://blogs.techrepublic.com.com/msoffice/?p=374 I have set it so it only opens a report with the ID of the current record the form is on. My problem is that the form the report is being generated from contains 2 subforms...
  2. A

    Sorting A Report

    Its not my database so I didnt have a say in the naming of the fields, I'm just doing work on a friend's database
  3. A

    Sorting A Report

    Basically I have a report which I need sorting. This sorting should be controlled by 3 drop down sort options on the form 'Main Reports' (Sorting1, Sorting2, Sorting3). The code for the report is: Private Sub Report_Open(Cancel As Integer) mainsql = "SELECT Quote_Number, Company_Name, Date...
  4. A

    Run Time Error 3075 Missing Operator

    I get the following: Syntax error (missing operator) in query expression 'Record_number = and defaultdates = true' It seems highlights the 'and' part of the code
  5. A

    Run-time error 3061 - Too few parameters. Expected 1

    I have actually solved this issue by creating a new report, but doing things slightly differently so this report is no longer needed
  6. A

    Run Time Error 3075 Missing Operator

    It is the primary key of the table 'Order' and is of type Autonumber (Long Integer)
  7. A

    Run-time error 3061 - Too few parameters. Expected 1

    The code is in the 'Private Sub Report_Open(Cancel As Integer)' part. OrderNo comes from a textbox in the form, which contains the value: [Order.QuoteNumber]
  8. A

    Run Time Error 3075 Missing Operator

    Basically I have a form where you select 3 types of quipment to add to a table, but when you try and add the equipment you get the following error: Run Time Error 3075 Missing Operator I have looked this up and from what I can gather its a syntax error somewhere, but my coding is not great so I...
  9. A

    Problem Importing Tables

    Alright, I will probably just use the Excel method for the one table. I was just concerned there might be some sort of consistency issue with doing it half one way and half the other way. Thanks for the help
  10. A

    Problem Importing Tables

    Thanks, this seems to work fine There are about 12 tables in the database, 11 of them import fine from the original Access file, its just this one that was causing problems. Would you reccomend I go through this process with just the one problematic table and go through the import from Access...
  11. A

    Problem Importing Tables

    How can I get all the records from the old table in to the new table without a whole load of manual entering?
  12. A

    Run-time error 3061 - Too few parameters. Expected 1

    I am working on a report and I am getting a run time error 3061 whenever I try and print off the report. The debugger says the error is in the code below but I cant figure out what is causing it Dim TableRecords As DAO.Recordset Dim consumableSQL As String consumableSQL = "SELECT...
  13. A

    Problem Importing Tables

    I am using Microsoft Access 2000 and when I try and import a table from an older version of the database I get the fllowing error: 'the decimal field's precision is too small to accept the numeric you attempted to add' I have been working on a database for a friend over the last few weeks and...
  14. A

    Sorting Problems

    I see. Would you mind drawing up a mock of what the code in the 'Private Sub Report_Open(Cancel As Integer)' would look like?
  15. A

    Sorting Problems

    I now have the following code: The report prints out fine, but still none of the sorting selections are working
See more
Back
Top Bottom