Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. HerickP

    USER IMPUT

    I have an ASP page that queries a database to returns POs issued based on criteria &quot;date()&quot;, so only Entered today will be returned. Here is the SQL part of it:<br><br>&lt;%<br>If IsObject(Session(&quot;ASNDatabase_conn&quot;)) Then<br>&nbsp;&nbsp;&nbsp;&nbsp;Set conn =...
  2. HerickP

    ACCESS DATABASE AND WEB SERVER HELP

    hi,<br><br>I have used access2000 to build a database that contains info about orders. Every order has a particular PO number, and I would like to build some ASP that I can for instance, access this database by having the user to go to a page, type a po number, &quot;click&quot; to search, and...
  3. HerickP

    FIELD OR TEXTBOX VALIDATION HELP

    Hi,<br><br>I have a table in access associated with a form that i use to enter data into the table. One textbox in my table is bounded to field &quot;PO Number&quot; and I have used this code to force data entry into the PO field:<br><br>Private Sub Form_AfterUpdate()<br>If Me![Text2] =...
  4. HerickP

    REQUIRE IMPUT ON TEXT BOX WITH CUSTOM POPUP BOX

    Hi,<br><br>I have a database and users sometimes leave some fields in blank in a form, where they were not supposed to. If I go in Table Design View, I have the &quot;Required field Property&quot; set to &quot;yes&quot; but I would like to have a custom popup message to show when the user leaves...
  5. HerickP

    ADDING DATE RANGE TO A LABEL

    THANKS!!!!
  6. HerickP

    ADDING DATE RANGE TO A LABEL

    Hi, <br><br>I have a report based on a query and this query is run based on a date Range I specify. Here is the criteria I use for one of the fields, which is a date field:<br><br>&quot;Between [Enter Week Start:] And [Enter Week End:]&quot;<br><br>When I run the query, it will ask me for the...
  7. HerickP

    HELP COMPARING DATA FROM ONE SOURCE TO UPDATE ANOTHER

    U r Awsome!!!!!! Two Questions: In the SQL statement, whats the diff between the &quot;RIGHT JOIN&quot; and &quot;INNER JOIN&quot;????? And Also, how to prevent access from updating the records in the access table that already have status &quot;Delivered&quot; and the receiving date? Because I...
  8. HerickP

    HELP COMPARING DATA FROM ONE SOURCE TO UPDATE ANOTHER

    just to make clear, this is what I have in SQL view:<br><br><br>UPDATE tblRCC3 RIGHT JOIN rcc3rcv ON tblRCC3.PO Number = rcc3rcv.PO Number SET tblRCC3.Status = &quot;DELIVERED&quot;, tblRCC3.Received Date = Date();<br><br>tblRCC3 is my access table;<br>rcc3rcv is the spreadsheet...
  9. HerickP

    HELP COMPARING DATA FROM ONE SOURCE TO UPDATE ANOTHER

    When I run the query, I get an error:<br><br>&quot;Syntax Error (missing operator) in query expression 'tblaccess.PONumber = tblexcel.PONumber. tblaccess and tblexcel are the names u have given in the example, and I replaced this with my table names.
  10. HerickP

    HELP COMPARING DATA FROM ONE SOURCE TO UPDATE ANOTHER

    Well, for receiving date, i want the date they have provided me in the Spreadsheet sent to me....and &quot;DELIVERD&quot; will be the new status from field &quot;STATUS&quot; in my table, which was &quot;In Transit&quot; before.
  11. HerickP

    HELP COMPARING DATA FROM ONE SOURCE TO UPDATE ANOTHER

    Hi Everybody,<br><br>My problem is the following: I keep an access table where I have data that holds information about orders ( the fields are: Customer Name, PO Number, Date shipped, Date Received, Status)... Field &quot;Status&quot; is always &quot;In Transit&quot;, since the order is still...
  12. HerickP

    CALCULATE TOTAL RECORD NUMBER IN 4 TABLES BY DATE RANGE

    Hi,<br><br>I have 4 tables, similar in aspect, and all 4 of them have a field named &quot;DATEENTERED', bounded to a control in a form, so everytime a record gets entered, Access flags the field of the specific record with the date it was entered. Now, what I need is to have a query that can...
  13. HerickP

    DUPLICATE RECORD QUESTION

    Hi,<br><br>I have a form that I use for record entering...I have force the fields in the table not to accept duplicate records if entered. Is there a way I can have a customized meg box to popup when the user enters a duplicate record and hits the command button that will enter the record??? Thanks
  14. HerickP

    NEED A SIMPLE FORM TO UPDATE RECORS

    Missed the last part:<br><br>LAst, it would have a command button to update the records. thanks!!
  15. HerickP

    NEED A SIMPLE FORM TO UPDATE RECORS

    Hi,<br><br>Anyone knows how to code or the code to a form where it will update two fields in a table, using 3 texboxes: Here is how it should work:<br><br>-First texbox: The user will imput a PO number; this PO already exists in the table, but Access should search this po in the table, then...
  16. HerickP

    DISABLING "ENTER KEY" IN A FORM

    Hi again,<br><br>Is there a way to disable the &quot;Enter&quot; key in a form?? I have users complaining that before they can finish entering all records in the textboxes, sometimes they will hit enter by accident, and imcomplete records get entered into the table. THanks a lot once again!!!
  17. HerickP

    AUTOMATIC ENTER TODAYS DATE INTO A FIELD

    Hi, <br><br><br>I have this form used to enter data into a table. I would like to tag every single record with a date that it was entered, so when u add a record to the table, it will also automatically add the date it was entered to a field in the table called &quot;date entered&quot;. The...
  18. HerickP

    ADDING UPDATE CAPABILITY

    This will only gather all the data into one table. Now, what about the part where I can update the data, sor of, entering a PO in a texbox, then , have access to find it, and if so, give me the chance to update the STATUS and DATE without having to touch the table, just using a form??
  19. HerickP

    ADDING UPDATE CAPABILITY

    Hi, and Thanks again for the support from this forum.<br><br>I have 4 table database, each table assigned to a region of the country. each table are similar in field names, which are &quot;PO Number&quot; &quot;Name&quot; &quot;Date Received&quot; and &quot;Status&quot; ( these are the values...
  20. HerickP

    BLANK FIELDS IN FORM

    hi,<br><br><br>I have a form with 5 textboxes, each one bounded to a field of a table. Users will be entering Data on these texboxes, but I do not want them to be able to save the record without having all texboxes filled out ( which means, no blank texboxes allowed). Is there a way I can...

Part and Inventory Search

Back
Top