Right now we're still using Access 97 at work and I know some suggestions only work with 2003 and newer. But I will try your suggestion again, just to see what happens.
Once again thanks for your help.
bruce24444
Last Activity: Jun 24 '08, 05:05 PM
Joined: Mar 16 '07
Location:
-
Need Value from Table based on Query Results
Working on a database to calculate the value of a home.
User inputs criteria, which is calculated in a query to produce a base factor.
With this base factor I need to apply a predetermined “Multiplier” from a table which I have created. This multiplier is based on (2) of the previous determined values.
I’ve been trying Dlookup with many different configurations, but just can’t to seem to get it to return... -
Thanks everyone for your suggestios, it returns exactly what I was hoping for
BruceLeave a comment:
-
Thanks for the quick response. I’m fairly new to Access and have never used modules before, but I have a fair idea of what you’re trying to explain.
So what I did is copied your coding into a module and called it Round200.
...Code:Option Compare Database Option Explicit Public Function Round200(ByVal sqft As Integer) As Integer Dim squareFootage As Integer squareFootage
Leave a comment:
-
Round to nearest 200 in a query
I'm designing a database which takes into consideration the total square footage of a house and multiplies it by a predetermined multiplier to determine the cost. However, the table with the predetermined multipliers is designed for every 200 sq. ft.
IE:
Total Sq. foot - - - - Multiplier
400 - - - - - - - - - - - 1.032
600 - - - - - - - - - - - 1.025
800 - - - - - - - - - - - 1.013
... -
Can I change an Error Message to direct user to correct field
I have a field in a table set to "Required". When a user is inputting data via a form and if they leave this field blank, Access automatically returns the following error message:
The field ‘tbl:Main.Claim Number’ can’t contain a Null value because the required property for this field is set to True. Enter a value in this field.
Can I change this message to say something different as the database is... -
I'm not sure how your suggestion is to be applied.
I have a second query which gathers the information from que:Main and only returns the applicable shape multiplier and the total square footage, which sometimes doesn't specifically apply to tbl:ShapeMultip lier
...Code:SELECT SELECT [que:Main].Shape, [que:Main].[Total Sq Footage] FROM [que:Main], [tbl:ShapeMultiplier], [tbl:ShapeMultiplier] AS [tbl:ShapeMultiplier_1]
Leave a comment:
-
Need cross reference from table for query
I'm trying to create a database for calculating the approximate replacement cost of a house.
In the form I have, you input the square footage of each floor and the complexity of the exterior wall shaping, which is recorded in tbl:Main.
I then have a query which adds all of the floors square footage to obtain a “Total square footage”.
I have another table , tbl:ShapeMultip lier, which has predefined variable... -
This additional form must have fried some brain cells cause some reason I just can't get this.
Form Name: F:Claims_Assign ment_Mtce
At the top is a textbox named: Text1
Then a command button to apply a filter
On click, of this command button, I want it to find the Claim Number entered in the text box and fill in the remainder of the form which contains fields linked to tbl:Claims_Assi gnment with textboxes...Leave a comment:
-
Find Record in Table and Return Values
I'm working on a database created in Access 97 which has a form which tracks claims made for damages. When the person reports the claim, a form is used to enter Date Reported, Claim Number, Loss Type, Reported To, and Caller Name. This information is recorded into tbl:Claims_Assi gnment.
I've been asked to create a form, to correct these initial details if entered incorrectly, so the end user doesn't have to go into tbl:Claims_Assi gnment,... -
Thank you very much for your quick response, that's exactly what I was looking for.Leave a comment:
-
Calendar Button (Dropdown) to fill a text box
I have designed a database for work, which creates reports from specific start and end dates. What I'd like to add to this form is a calendar dropdown where you would click a specific date on a calendar and it would fill the text box with the appropriate date.
Database is created with Access 97. -
I tried your suggestion and still nothing. I then noticed that on the week query the assigned files for the last day of the sequence where not being included. I tried:
Between Date() And Date()+1
and all of a sudden everything works.
Thanks for your suggestions.Leave a comment:
-
I still get nothing
...Code:SELECT Staff.[Last Name], Staff.[First Name], Loss_Type.[Type of Loss], Claim_Assignment.[Assigned Date] FROM Loss_Type INNER JOIN (Staff INNER JOIN Claim_Assignment ON Staff.[Last Name] = Claim_Assignment.[Last Name]) ON Loss_Type.[Type of Loss] = Claim_Assignment.[Type of Loss] GROUP BY Staff.[Last Name], Staff.[First Name], Loss_Type.[Type of Loss], Claim_Assignment.[Assigned Date] HAVING
Leave a comment:
-
Problem with Query Returning report based on current date
I have a database which assigns warranty claims to people with a main screen showing number of files assigned to each person. The number assigned shows day, week, month and year numbers so they can be evenly distributed.
The problem I'm having is getting the query to return a number of files for the current date. Week, month and year appear to work fine.
Below are the SQL's for both day and week.
Any... -
Crosstab Query to display all possibilities, even if zero
First of all I'm new to the forum and am working on my first database. So far I think I've done not too bad but have hit a stumbling block for which I'm not sure how to get around.
What I have is a database which tracks assigned files to a certain people which is generated by a form and then recorded into a table. Tables are as follows “Staff” “Loss_Type” and “Claims_Assignm ent”.
From this “Claim_Assignme nt”... -
I hope this is what you were asking for. Again, this is the first time I've used Access, so it's a learning process as well as to terminology.
...Code:SELECT Staff.[Last Name], Staff.[First Name], Loss_Type.[Type of Loss], Claim_Assignment.[Assigned Date] FROM Start_End, Loss_Type INNER JOIN (Staff INNER JOIN Claim_Assignment ON Staff.[Last Name] = Claim_Assignment.[Last Name]) ON Loss_Type.[Type of Loss] = Claim_Assignment.[Type of
Leave a comment:
-
I have to apologize for my ignorance, but this is the first database I've designed and couldn't figure out how to post the screen shots so I created a webpage for illustration purposes.
http://www.geocities.com/bruce24444/...xplanation.htm
I hope this helps...Leave a comment:
-
Crosstab Query to Display Zero
What I have is a database which tracks assigned files to a certain people which is generated by a form and then recorded into a table. Table are as follows “Staff” “Loss_Type” and “Claims_Assignm ent”.
From this “Claim_Assignme nt” table I have created separate queries that provide reports sorted by certain predetermined dates. IE: week, month, year
I have designed (2) crosstab queries from... -
Duplicate Error Message
I am designing a database to use a work to assign files to certain people. Form includes Date textbox, File Number textbox, File Type combobox and Assigned To combobox. The form is working fine and the File Number textbox is set “not to accept duplicates”.
What I'd like to do is change the error message that pops up if a duplicate file number is entered and attempted to be assigned.
Right now I get an error message...
No activity results to display
Leave a comment: