Search results

  1. J

    How to calculate the number of days from two dates in a table

    @Noob_2048 Like it was already advice, a Calculated field should not be store. But I ask this. You said the BedCharges get calculated based on a "constant" for the day. What happens in the case you want to generate the receipt for a patient visit 2 years ago, when the price for the bed may...
  2. J

    Calculation in a QUERY

    I am not very experience but I gave it a shot. It creates two types of files using the DoCmd.Outputto & DoCmd.TransferText Hope this helps you in any way..
  3. J

    Filter Report Using 3 ListBoxes (MultiSelect)

    Well Friends I posted the same question on another forum and I was lucky to also get help there as well. I finally got what I needed to work thanks to the help from another forum member. I was made to see that I had a problem with how I was buildind my Filter String and a Simple Parenthesis...
  4. J

    Filter Report Using 3 ListBoxes (MultiSelect)

    Hi MarkK Thank you for your reply.. I added the comparison Operators ( = ) to the filter string and It returns and error (I get error even If a Select one item from each listbox). Attached 4 images one is a msgbox showing the String that will be used as a filter, and the second is the error...
  5. J

    Png transparency!

    Interesting work-around.. Thank you for posting. This will come in handy once I start adding logos and images to my reports...
  6. J

    Filter Report Using 3 ListBoxes (MultiSelect)

    Hi everyone, Since I started using Access I have made it so far without asking too many questions but now I am stuck and need assistance.. Included in the zip. is a working version of my problem. My table "EmpTraining" will store 5 fields: ID (PK Autonumber ) EmpID (From Employees Table)...
  7. J

    Auto capitalize all fields on a form

    Old post but I had to say Thank you :)
Top Bottom