Search results for query: *

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

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

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

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

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

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

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

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

HI,<br><br>I have one query that calculates the total of POs in one table, and another query to find the total of delivered pos, by looking it the field &quot;status&quot; for the criteria &quot;DELIVERED&quot;. Now, I wanna a report that gets the total of POS ans subtract the total of...

I have a form that I use to enter data into a table. Fields are:<br><br>PO Number<br>Customer Name<br>Date Shipped<br>Date Arrived<br>Status<br><br>Everytime an order gets shipped, I will add a record to the table using the form, but Field &quot;Date Arrived&quot; will be blank since the order...

Hi, its me again :)<br><br>Thanks for your help, My database seems fine, but as DougP said &quot; when u get one problem fixed, another million appear&quot;...<br><br>I have a form that I use to enter data into a table. Fields are:<br><br>PO Number<br>Customer Name<br>Date Shipped<br>Date...

HI,<br><br>I have designed a form with 10 fields that will go into a table when I have filled them out and hit a command button button assigned to &quot;add record&quot;. No problem with that, except that when I open this form to add the records, for some reason, each textbox that it was bounded...

Sorry for so many questions, but this forum has been so far my only solution; I have a question regarding entering Data in Multiple tables using one Form:<br><br>How can I create a Form where I will be entering data in tables ( all common fields, except that each table is for a specific region)...

Hi hi hi!!<br><br>Sorry for so many questions, but this forum has been so far my only solution; I have a question regarding entering Data in Multiple tables using one Form:<br><br>How can I create a Form where I will be entering data in tables ( all common fields, except that each table is for a...

hI AGAIN,<br>I am having a problem finding a result using the query; I have a Table with many fields, in question are SHIPPED ON, DELIVERED ON, STATUS. On the Status field, everytime something gets delivered, I change the status from INTRANSIT to DELIVERED. Running the query, I can find a total...