Search results

  1. I

    Using Combo Boxes as Filters

    Greetings, I'm using Access 97. I've searched on Combo AND Filter, but have not seen what I need. I have a table called BUDGET. On a form I would like to have 3 Combo boxes that are used as a filter. I need to filter on three fields; CAC, ObjCls, Output. So far there are over 5000 records...
  2. I

    Counting alpha-numerics in a text field

    Alex and Al, Thank you both for your replies. I apologize for not explaining the problem correctly. Here is what's happening. A text file is imported into Access 97. One of the fields (DOCNO) must contain 14 valid alpha-numeric characters -- no spaces allowed! BTW, the info in the DOCNO...
  3. I

    Counting alpha-numerics in a text field

    Greetings, I need to get an actual count of real alph-numeric characters in a TEXT field. The field I'm checking is called DOCNO, and holds a Document Number. The size of this field is 14, and it is a TEXT-type field. 1. Here is an example of a valid DOCNO with 14 actual alpha-numeric...
  4. I

    An elegant text-to-number conversion ?

    Hmmm....well, I doubt I'll ever get the programmers to change anything. I'm working with the Dept of Defense...ergo, any suggestions I make now might be considered by 2025 or so. Besides, why enhance the mainframe when management can have us jump through hoops for workarounds. Many thanks to...
  5. I

    An elegant text-to-number conversion ?

    Greetings, Wondering if there is a more "elegant" way to perform a task than the one I'm using. I'm working with text numbers. The field size [Amount] is 10. But, here's the catch; These text numbers use a letter or special character for the last place in the field. This letter or...
  6. I

    If-Then Conditional Formatting

    Rich, That was right on the money !! I don't think I would have ever thought of the ABS answer. Thank you very much, and thank God for this website! Sincerely, Bob Indianapolis, Indiana, USA
  7. I

    If-Then Conditional Formatting

    Rich, Thank you for your reply. However, what I'm trying to do is arrive at a number greater-than or less-than a $500 variance. Example 1: Estmated Travel Amount: $700.00 minus Actual Voucher Amount: $975.00 Variance: $-275.00 In this example, the...
  8. I

    If-Then Conditional Formatting

    Greetings, I am using Access 97. I have a calculated field in a query called Variance. This field does not exist in the main table. I have placed this field on a form, and am attempting to perform some conditional formatting. What I'm trying to do is get a label called...
  9. I

    Form Subform Conditions

    Greetings, I have a form (parent) called frm_DNO_Developmental Assignments I have a subform called sbfrmDevelopmentalAssignments On the parent form is a field called DevAssgn (Developmental Assignment). This textbox is Y or N. On the subform is a field called End_Date. What I would like to...
  10. I

    Mail Merge to Word

    Mail Merge to Word Here is my dilemma… I have a MS Word form called Civilian Performance Plan, and I have a database in Access 97 that I wish to export into this Word form. There is employee information and Performance Plan information in the Word form. In Access I am using two tables...
  11. I

    Flagging when certain criteria are met???

    Adrianna, Here are a couple of ideas for you. The first one take a field called CE (Critical Element) and reformats it if the value is "Y" Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer) ' Make CRITIAL ELEMENT Bold, 12 point and Red if CE is Y (Yes). Const conNormal...
  12. I

    Automate the Calendar Control ??

    Greetings, I am working on a simple Access 97 app to track leave usage by employees. There is a Form (f_Employees) and a SubForm (sbfrm_Leave). The Main Form has employee info, and an Unbound Calendar Control (MSCAL.Calendar.7). The SubForm has the dates leave was taken (DFrom and DTo). I...
  13. I

    Calculated Field Problem

    Ally, It appears that your referencing the same field twice. I use something like this to count the number of employees in a certain job series: =DCount("[EmployeeID]","0_All CURRENT Employees","[Series] = '303'") Without knowing the properties of your tables, I would guess the following...
  14. I

    Placing User-selected Date onto Form

    Thank you Jim! I'll give it a try.
  15. I

    Date problem

    In a textbox on your form, put this: =Date()+30
  16. I

    Placing User-selected Date onto Form

    Greetings, I want the User to be able to either input or select a Month for a Form. I have an unbound Form that displays a lot of data using DCount. I also have a report that is based on a parameter query. I've been able to take the dates from the parameter, and place them in text boxes on...
  17. I

    Date fields in queries

    Greetings All, I received the below reply from mztaib on the ezboard users group; http://pub59.ezboard.com/fmsaccesshelpguidefrm1.showMessage?topicID=460.topic Anyway, this is exactly what I needed, and it works great. Thought I would post his answer here in case it can help anyone else...
  18. I

    Dates again!!!

    Hmmmmm.......I know that this question is old, but I was going thru looking for an answer to a query question, and thought I would reply. Perhaps it will help someone else. In the Query Grid, in a blank column, enter this in the Field Row of the blank column; Days: [End_Date]-[Start_Date]+1...
  19. I

    Show years service

    In the query grid, you can enter the below on the Field Line of a blank column: Year5: [StartDate]+365*5-10 This will yield a date 5 years minus 10 days from the Start Date. You can do 10 years in another field on the query grid thus; Year10: [StartDate]+365*10-10 ...and so forth. I've...
  20. I

    Date fields in queries

    Rich, thank you for your reply. Here is the SQL from the query. I've tried placing what you provided into this, but it returns errors. Am I to place the SQL you provided into my SQL, or into the query grid someplace? Thanks in advance !!! SELECT tbl_DNO_Employees.EmployeeID...
Back
Top Bottom