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?

    Here's the whole code. I'll be back at work in an hour or so and will see what I can figure out. Option Compare Database Private Sub DeleteTable(Table_Navn As String) Dim dbs As Database, ctr As Container, doc As Document Set dbs = CurrentDb Set ctr = dbs.Containers!Tables For Each...
  4. W

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

    When I put that in it's place it throws off the rest of the code and I get runtime error 3075 syntax error (missing operator). And when I open the table, it shows info that supposed to be in CLASSINFO field in REGID field.
  5. W

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

    Ok so I've tweaked it and added a few other things I needed to and it works great up until this point.... dbs.Execute ("SELECT DISTINCT CUSTNO, FULLNAME, EMAIL, REGID, '' AS CLASSINFO INTO MCEMAIL " _ & "FROM MCTEST2") Error I get is: 3010 Table'MCEMAIL' already exists. It seems that the...
  6. W

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

    So I feel crazy dumb here....The code I have already has the delete table which is what is causing the issue. Isn't there a simple way to delete the data from the table, but not the actual table each time?
  7. W

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

    Hi again SOS, You've been great to work with BTW! Could you help me with the code? I'm REALLY new at this insanity!
  8. 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...
  9. W

    Runtime error 3075

    So I copied your code completely and am still getting the same error. Could it be an issue with the table or something else?
  10. W

    Runtime error 3075

    Whole error: Syntax error (missing operator) in query expression 'CUSTNO=1019' AND FULLNAME='JOHN SMITH'.......
  11. W

    Runtime error 3075

    Is this right? CUSTNO and REGID are numbers. And now I'm getting the syntax error 3075?
  12. W

    Runtime error 3075

    Hi SOS, I ended up just changing the name field which should have helped, but I'm still getting the error? Run-time error '3464': Data type mismatch in criteria expression. I think this is just a wrong field name, but can't for the life of me see it. I've uploaded the whole new code here...
  13. W

    Runtime error 3075

    NOW Runtime error 3464 I'm plodding through this so slowly.... I got that error cleared up, but now had another pop up. Run-time error '3464'; Data type mismatch in criteria expression. The code I'm using is attached it wouldn't let me just put it in here. Thanks for any help! :banghead:
  14. 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...
  15. W

    Query from multiples into one record?

    I think this will definitely work....we are using Access 2003. Could you save the DB in mdb format for me? Thanks so much for your help!
  16. 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