Search results

  1. M

    VBA Loop stalling on db.openrecordset when recordcount is 0

    Hi guys A really bizarre issue I haven't walked into before. Let me try and explain; I am having issues with this small part of code here; Set rst = CurrentDb.OpenRecordset(sSql1, dbOpenSnapshot) With rst If .RecordCount > 0 Then i = i + 1 .MoveFirst...
  2. M

    Using subform to add new record to a table giving null type to variant error

    Hi all Been a while since I have posted here but this has had me at my wits end and I can not figure out why. I've searched for ages on google and here and haven't found an answer - I am rather tired and I am hoping it's something so simple I will be able to laugh at it in the morning. The...
  3. M

    Invalid argument in a query

    Hi I have a db and when I put an unbound text box with a formula in it on the 'main' form as such and it calculates all as intended, but when I put this formula into a query and go to run the query it just says 'Invalid Argument'. I've done some looking around and my db isn't over 2gb and I...
  4. M

    MonthName function

    Hi A small puzzle I am hoping someone can help with, a field in my query needs to just show the month name of the date value so I have Month: MonthName([Field Here]), False] which I believe should give me a non abbreviated month name in my field. When I view my query it returns #Func! If I use...
Top Bottom