Page 2 of 2 FirstFirst 12
Results 16 to 24 of 24
  1. #16
    weekend00 is offline I may not be right
    Windows XP Access 2003
    Join Date
    Aug 2010

    I am looking for code to convert number to words.
    for example:
    number: 102
    words: one hundred and 2

  2. #17
    TheShabz is offline Court Jester
    Windows XP Access 2003
    Join Date
    Feb 2010
    I found this for excel. I'm sure itll work in Access as well.

  3. #18
    Join Date
    Nov 2010
    I am trying to create a form that finds the record when the student types in their id number, then populates the rest of the fields on the form with the information in the table. Additionally there needs to be a few fields that the student must complete the first time around since we don't have all the information.

  4. #19
    TheShabz is offline Court Jester
    Windows XP Access 2003
    Join Date
    Feb 2010
    You might want to create a new thread for this Queen. It really isn't something generic that can be provided. We would need more info.

  5. #20
    sYn is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jan 2011

    AfterUpdate code for a text box

    (Acess 2000) I am trying to create an AfterUpdate code for a text box. Basicly on the form the user selects a number from the combo box. They then type in the name of a person in a text box. What i want Access to do is search a database for records of people who have the number (selected in the combobox) with their name. If they do, i want the form to set the background of the textbox to green and display a label underneath. And if it dosent then it sets the background of the textbox to red and also displays a label underneath.

    If this is possible please reply. (Also apologies if this has been posted somewhere before on the forum)

  6. #21
    Novice88 is offline Novice
    Windows XP Access 2007
    Join Date
    Feb 2011

    Log In Tracking

    I am looking for a way to record who and when a user logs into my database, i use a log in screen with a user table for access to specific menus depending on an assigned level, I just want to be able to see when and who logs in (the database, not the computer login)


  7. #22
    FrankRoss is offline Novice
    Windows XP Access 2007
    Join Date
    Dec 2010
    Conditional SQL UPDATE statement. I have a problem where this code is updating every record, not just the records in the IF statement.

    intRecord for my test was "1"

    intPickCount is correctly established in earlier code. In my test runs, intPickCount is 18 and that is what shows up in the PickCount field for ALL records, not just the records having CompareField "1".

    I would like to see some examples of comparable SQL UPDATE statements just to see if I am on the right track here. Many thanks for having this thread (yes, the SEARCH feature can be needle in a haystack sometimes).

    Do Until SiteRecord.EOF
      If (SiteRecord!CompareField) = intRecord Then
            strSQL = "UPDATE SitesTable SET SitesTable!PickCount = " & intPickCount & ";"
            DoCmd.RunSQL strSQL
       End If

  8. #23
    Shambler2 is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jun 2011
    Perris, CA
    Help with a code on the report linked to a unbound textbox. The code would display GREEN text "PASS" or RED text "FAIL".

    The code would need to verify that 10 sensors(Temperature sensors) reach 170 or more over the coarse of an hour. There is a timestamp for readings every 15 minutes.

    Timestamp________ Sensor 1 __ Sensor 2 ...........Sensor 10
    05/26/2011 12:00 PM 176.23___ 172.26__________ 180.00
    05/26/2011 12:15 PM 176.55 __ 177.25 _________ 182.25

    The data is set via a parameter on a form page and can be any range from hours to days. I just want the code to see if at ANY point all sensors reach 170 for at least an hour. Then display PASS in green text......
    THANKS in advance.

  9. #24
    compooper is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Jun 2011
    Looking for an import specfication code:
    runs delete & append queries then merges imported table to its respective table

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Type Mismatch - HELP!
    By jgelpi in forum Programming
    Replies: 3
    Last Post: 07-17-2009, 03:53 PM
  2. Replies: 4
    Last Post: 05-16-2009, 09:17 PM
  3. Replies: 0
    Last Post: 02-27-2009, 01:27 PM
  4. fields of type text
    By ashiers in forum Forms
    Replies: 0
    Last Post: 11-28-2008, 10:52 AM
  5. Number data type
    By BernardKane in forum Access
    Replies: 1
    Last Post: 11-11-2006, 08:19 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums - Senior Forums