Search results

  1. C

    Too Many ElseIfs?

    Some of my code is working but the bottom several ElseIfs are not. Is there a limit to the number of ElseIfs you can use? Here is the code. Thanks in advance for any advice. I'm not a pro as you can see. Function mcr_Produce_Issue_Escalation_Template_Templates1() On Error GoTo...
  2. C

    Select report from array using query as criteria

    I feel like my brain is just going in circles and I can't figure this one out.:banghead: I have one form, Issue Escalation Screen, which has some data pulled from a previous table and some new data input. A key input field is RESOLVER. When a button (TEMPLATE) is pushed on this screen, a query...
  3. C

    Automate Emailing a Query in Excel Format without Truncating Memo Fields

    I am working with a database that's been in use for years (pre-dates me). This is a multi-user database in which the user updates (among other things) a "Comments" field on an invoice in question, which is a memo field to allow for as much room as possible, and for multiple comments over time...
  4. C

    Why is my form adding records on its own

    Hi. I am perplexed. :banghead: I start with a table of UserIDs, names and roles (tblUserIDList). I have a simple query off that which lists them in alpha order by UserID. Next I have a simple form with a combo box which uses that query to select the User and binds the UserID field to use...
  5. C

    Allow multiple lines in continuous form but hide New Record line?

    Hi there! I have a form which, upon selection of one answer from a combo box, may open a second form, bringing with it the File Number from the record of the first form. So, upon selection of the specified item, an append query is put into action in order to add that file number to the...
  6. C

    Question Suggestions for learning VBA for Access 2007

    Does anyone have any good (inexpensive hopefully) suggestions for learning VBA for Access 2007? I'm looking for classes, online learning, books, etc. I've been working in Access for years but am a total VBA novice. Thank you! :D
  7. C

    Form not reflecting Query's sort order

    Hi there. I have a form built on a query that has a 2-level sort, ascending on one field (numeric) and descending on another field (numeric). My expectation was that the form would show the data in the order of the query's sorting, but it does not appear to be doing that consistently. Any...
  8. C

    Hi! New to Forum!

    Hi there! I've been using Access for a number of years, but am mostly self-taught. I'm now developing databases and am rapidly discovering the many holes in my knowledge base. I am also trying to teach myself - in a bit of a hurry - VBA. Exciting and nerve-wracking! So I look forward to...
Back
Top Bottom