Search results

  1. C

    Recording Calculated field

    Sometimes it is VERY necessary to save a calculated field. For example, an invoice, where your markup and item price WILL change over time. In one DB I have I use ItemPrice and ItemMarkup in a table for "OrderDetail" and "UnitCost" and "Markup" in the table for Items. When you choose an item...
  2. C

    Show only selected values from listbox on form (listbox from a table)

    Listbox based on query?... In query..Listbox Value, chkbox = True
  3. C

    problem with gridlines

    Grids? Are you in Access or Excel? Are you talking about textbox on a form or display on a report?
  4. C

    Option Button General Use

    Did you use the "option group" to build this? If so, it would have assigned 1 for the first value and 2 for the second. (thou you can insert other values) Not "True"...... Couple of easy ways to use the value... either a "if....then" statement or a "Select case"... I use this code below to make...
  5. C

    User form not working

    Needed to see the users in a DB..... Tried this code.....only shows me.....Did it on Frontend ...backend.... am I missing something here??? Private Sub GenerateUserList() 'The User List Schema information requires this magic number. For anyone 'who may be interested, this number is...
    • CEH
    • Thread
    • Replies: 0
    • Forum: Forms
  6. C

    Date Dilemma

    The way I read it is you really want to use one field for date? Set the "Default value" in the field to Now() ..... use an input mask for short date.
  7. C

    Windows 7 ans snapshot

    Windows 7 and snapshot viewer After a quick search here I didn't see anything.... So I'll see if anyone knows.. Have a computer running Windows 7, no Access installed. I needed the person to be able to view "Snapshot" reports... Does the stand alone snapshot viewer not work with Windows 7? Or...
    • CEH
    • Thread
    • Replies: 1
    • Forum: General
  8. C

    Required Field on a Form

    Re: Requied Field on a Form Or use the "tag" property.
  9. C

    Split Database Front End User Privaledge

    simpliest way for what you are wanting is just make the users frontend a "mde" file.
  10. C

    Formatting Currency

    You can call an apple an orange... but it's still an apple...... Don't you first need to insert the calculation to change USD to BRL???
  11. C

    2 teachers 1 class

    Did you add the field to the query behind your report? If so you will need to explain what error for anyone to help.
  12. C

    Headers and Footers not showing in Print and Email

    The problem might be trying to mail or attach a Form instead of a report. Forms are not really designed for print... Reports are.
  13. C

    Access 2007 Freezes on Some Form Filters

    Look into using the "Tag" property... You can cut that code WAY down!
  14. C

    KIS please!!

    This sounds like a little of "putting the cart before the horse" Seeing how the wizard creates a form from a table or query can help you to understand how to create one from scratch. You don't have to have an extensive knowledge of "VB" or "VBA" in the case of Access to create a database. Why do...
  15. C

    Combo Box Values

    First, you don't need, or want a second table, just a second query. Take a look at this code... it should show you want you want..... This is to open a form that allows a combo to only view "Active" salesmen or all salesmen depending on what view the form is opened in.......... Private Sub...
  16. C

    Refine combo box search

    If I read it correctly your just wanting to see these fields in the combo..... Go into design... properties of the combo....under "Format" then "Column Widths" you will see something like...... 0";1";0"..... or whatever your shows... change the zero to a width suitable to view the name.... The...
  17. C

    Automated Letter

    I knew I had something half finished laying around.... :) Take a look at this... See if it does what your wanting.. Put the Word template on the root of your C drive.
  18. C

    Updating a text box as new entry

    Look into the onchange event.
  19. C

    Converting numbers back to text?

    Search the forum.... try this one..... http://www.access-programmers.co.uk/forums/showthread.php?t=94377 And on a side note...... I looked at your images... I would highly discourage using "ID" for every primary key...... Going to get you in a LOT of trouble!
  20. C

    Outlook Email list

    Check this post...... Might be what your looking for. http://www.access-programmers.co.uk/forums/showthread.php?t=96783
Back
Top Bottom