Search results

This function will calculate your change Function change_calc_case(change_amount As Currency) Dim dollar_100 As Integer Dim dollar_50 As Integer Dim dollar_20 As Integer Dim dollar_10 As Integer Dim dollar_5 As Integer Dim dollar_1 As Integer Dim cent_50 As Integer Dim cent_20 As Integer Dim...

Create a macro called Autoexec and in the action part of the macro enter your procedure name.

Steve Check your formula I do not get 99, 98, 97 etc. I get between 99.9 to 99.5 greearn Try this Points= (1 - (Run Time - Reference time)) * 100 Run Time is the actual time taken, Reference time is the run time required for 100 points Using 12.01 Points =(1 - (12.01- 12.00)) * 100 gives 99...

It took me a while to work out what you want. You have these tables structured as above with an extra field which I will call F8 to store the cost of the part. You have a query or table that displays the number of parts sold during a certain period as shown in T4 above how T4 is populated is...

Here is an updated version qry_group_cost_total will give you the total units sold between the minimum and maximum values entered in the prompts. . This is a broad statement could you please be more specific?

You will need two queries one to group your F2 and F3 and total the f4 from T3 the other to group your F3 and total the f4 from T3. I have attached a sample database wit the two queries

I have attached an updated version. In the new drop down you will need to list your Investorswho are also in the Interests table. Otherwise you will receive an error message as there are no matching records in the Interests table.

In your query qryInterest_LookUp add the field Deal_ID from the table tblDeals, move the criteria you have for borrowers to Deal_ID. In your current database when the user selects the Borrower the value sent to the query is the deal_id and not the name of the borrower so this results in no...

Yes there is, please send a copy of your database with the relevant for mand table. Maybe it would be a good idea to take this of forum and send the database to my email address below.

Thank you for your comments, I am not an expert just a person who dabbles with access. You want to save the record when the user clicks on the Pallet Conformity button when the caption is YES and take no action for a caption of No. Using the Click event of the pallet_conformity button add...

Jon I have attached a document with the code and highlighted the relevant sections of the code that are used for defects percentages.

Query qry_payments was missing from the database. I have attached the latest version. Yes I noticed you had Invoice spelt incorrect.

Jon Glad to help, just remember 1. Do not use RESERVED words Like Date, Time etc. for field names 2. Field names to be one word or two words joined by an underscore. Do not use N/O etc. 3. Correct data type e.g. Number for storing numbers not Text.

I have attached it as zip file, I also added a doc showing the layout and the code used. There is only one form in the database and it is not bound to a table.

Jon Here is an updated version. It only has one form all fields in the form are unbound, this was to save confusion with your field names etc. You have fields doing the same function e.g. Major Defects and N/o Major Defects. Also, the fields used to store defects etc. are shown as text in the...

Jon The 10% was not in your priority calculation see message 1. I will redo your form etc and send a later version later today our time.

Your welcome, now you can progress on your project.

No I have not done the first two as Jon said the third one was important. Jon In my version that I uploaded if I entered 25 for nets, 4 for checked and 4 for major defects 4% is displayed in the percent field and the caption is YES. When I change the major defects to 5, 5% is displayed and the...

Jon The attached database contains only your table and form. The form only has the code to display the result of the calculation required to change the caption depending on the percentage. I found that you were using two words for the name of fields try and use one word or two words with an...

How many buttons do you have in your option group? As John requested would you please post your code or a sample of your database. It is a bit hard trying to give help with so little info.