Search results

  1. W

    sub form issues

    Our database is being used a registration system. It was built over 20 years ago and we've moved to 2013 now, but it's having some issues. Our subform is attached. We think it's getting hung up on some of the expression. I've checked them and they all seem okay, but they are the only things...
  2. W

    Subform moving tab stop?

    I have a form that that the subform is not adhering to the tab stops when going to the next record. So for instance, enter through form, which then feeds into subregform, which then goes to macro for new record. Problem is that in the new record when you get down to the subregform again it's...
  3. W

    Error 3163 field too small....needs memo field?

    I'm getting that error 3163 when running my script. I know it's because the table needs to have a memo field instead. However, every time I run the script it's changing my field from memo back to text and therefore giving the error! Debug pulls this piece- rstInsert![CLASSINFO] = RememberNames...
  4. W

    Runtime error 3075

    I'm getting this error.... Run-time error '3075'; Syntax error (missing operator) in query expression 'REGIS ID'. When I run the Debug it highlights this piece of code. dbs.Execute ("SELECT DISTINCT CUSTNO, NAME, EMAIL, REGIS ID, '' AS CLASS NOS INTO MC EMAIL " _ & "FROM MC Test2") Any...
  5. W

    Query from multiples into one record?

    We have a query that pulls information from four tables. What we need to do is do a query or something else to pull the data from the existing query into a table/excel file. The problem we are having is that we want just one record for each person with all of their class selections in one...
Back
Top Bottom