Search results

  1. O

    Question Multiple Values from Listbox in Textbox on a Report

    Hi, I'm banging my head up against a wall for this one :banghead:, I'm sure the answer is easy but it's not coming to me. Basically what I have is a form where a user has a drop down combo box that he can pick more than one value. I then want to take what he has inputed e.g. Option1, Option2...
  2. O

    DMax Expression in a Form

    I'm afraid I can't, it's for a government organisation. I'll keep working on it, thanks for your time.
  3. O

    DMax Expression in a Form

    Not having much luck on this Bob, could I send you my database in an email? It's perfectly alright if you prefer not to, we are all busy people.
  4. O

    DMax Expression in a Form

    Am I right in that I put that expression in the "Control Source" of the textbox I want it displayed in?
  5. O

    DMax Expression in a Form

    Hi Bob, Thanks for the reply. I tried doing what you suggested but no luck. It's giving me a #Name error now. You have the right idea on what I want to be able to do. I've been stuck on this for a good few hours now and it's really grinding my gears.
  6. O

    DMax Expression in a Form

    Hi all, I have an unbounded text box where I want to be able to display the highest number of a certain field in a certain record. I've tried using DMax but all I am getting is #Errors and it's getting frustrating. =DMax("Issue_Number","Issue_Tracker","StaffID=" & Forms!Manager!StaffID)...
  7. O

    Hiding Record in Report based on checkbox value - Access 2003

    I feel like an idiot now, but sure I'm only starting out. I used a query instead of basing the report on a table. And in that query I put criteria for the checkbox as -1. Thanks for your help anyway.
  8. O

    Hiding Record in Report based on checkbox value - Access 2003

    Hi everyone, I'm new enough at Access 2003 but I have been tasked at work with making a licensing database. I have a main form, and on that form is a subform called "Remarks". I have a report to print off a licence for that particular person. What I want to be able to do is check a checkbox in...
Back
Top Bottom