Recent content by HerickP

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 =...

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...

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] =...

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...

THANKS!!!!

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...

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...

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...

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.

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.

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...

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...

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

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

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...