I have a database that tracks patient orders and order progress.
On one single-view form, frmOrderUpdate, the users are entering information into text box fields named PreCertNo and Expiration, and each record is associated with an OrderID.
I have a second form (split view/datasheet), frmOrderProgres s, which will open behind the scenes, with a default value for its OrderID field set to be that of the current record open...
jcrist30
Last Activity: Apr 11 '17, 04:15 PM
Joined: Feb 16 '12
Location: Montgomery, AL
-
Button Click Automatically Adds Record w/ Default Values
-
Twinnyfo,
Everything that can be calculated in the query has been. I figured that might have had something to do with an issue I was having earlier, and I was correct. Unfortunately, the fields/controls giving me issues now are only calculated on a combination of certain records, not all records, so I can't use the query and simply pull the fields into the report. -
Different Values Displayed in Report Layout View & Print Preview
I have a report with several fields/text boxes that are used to determine the values of various report/field totals. Everything is calculating and populating the fields correctly when I view the report in Layout View. However, when I view the report in Print Preview, one of the fields suddenly has a value of 0.00. This field is used in a calculation and acts as the denominator of an equation, so naturally, I get a "division by zero"... -
How do I make one field value determine value of second field in form?
In my database, I have a table that has a list of procedure codes as one field and a cost assigned to each procedure as a second field.
I have a second table where I enter one of the procedure codes (looked-up from my original table/typed in), and I would like the value associated with this code in the original table to auto-populate a second field "after update".
Is there a way to make this field pull from... -
jcrist30 started a topic What is a Function to Display a String if certain Date is Within Defined Date Range?in AccessWhat is a Function to Display a String if certain Date is Within Defined Date Range?
I know I have seen this before, but I can't seem to locate the example again.
What I have is a contracts database, and I am trying to create a field that will display a notification when the current system date is within a certain number of days (i.e. 90 days) of the contract term date.
The example I have seen had a field (let's say, "Notificati on") in a table ("Contracts" ) that has its default value... -
Can textbox value be converted from "Alpha Bravo Charlie" to "ABC"?
I am wondering if there is a way to convert the value of a text box to an acronym represented by the first letter of each word in the textbox.
i.e. User would input "Alpha Bravo Charlie" and this could be converted elsewhere to "ABC".
Any help would be great! :) -
Perfect! Thanks ADezii! After a few modifications, I got the code to work. :)Leave a comment:
-
How do I AutoFill fields if a Primary Key value has already been taken?
For the database I'm building, users will have to fill data into a form that uses a date as the Primary Key for the related table. The scenario for which I need the form to auto-fill is as follows:
If the user wants to enter data for 1/31/2012, but he or she forgot that data for that day had already been entered, is there a way that once they begin filling out the form and type "1/31/2012" in the Date (i.e. Primary Key)... -
Rabbit,
Thanks for the help! I simply renamed the module and it works. You have no idea how much this help out! My headache has miraculously disappeared.
Thanks to you, as well, NeoPa.Leave a comment:
-
How do I display Windows Username in Form/Table?
I have copied the code found at http://www.mvps.org/access/api/api0008.htm into a module and saved the module as fOSUserName.
Following the directions listed in a similar post (http://bytes.com/topic/access/answer...nto-form-field), I then created a field on my table labeled "UserID" and inserted the field into the related form. I set the default value for the text box in the form to =f...
No activity results to display
Leave a comment: