Hi there,
I want to have two tables in my database. One table will be a list of all raw materials used (called materials), and the other will be a list of all the raw materials which have been approved (called approved). Both tables have exactly the some column titles and data types (a copy and paste of the materials tabled, then renamed).
I have a form which contains a section for approval information to be added and...
djgeverson
Last Activity: Sep 24 '14, 12:10 PM
Joined: Feb 14 '14
Location:
-
Hi Jim!
Thanks so much for that! I am new to VB so didnt think the last piece of code was right but thanks for showing me how to do it! It now works like a treat! -
Error message displayed on form depending on calculated value
On my form I have a calculated value text box which is the sum of 5 text boxes. I have three error messages which I want to appear "high risk" "low risk" and "medium risk" depending on the value in the calculated text box. I have these error messages as labels on the form and when the form loads they are made not visible.
I want the messages to appear as the "calculate" button I have is clicked.... -
Thanks it worked first time!!Leave a comment:
-
Sum of multiple text boxes on form
Hi there,
I am trying to add together 4 fields on a form to give total sumation. I have created the expression:
But when values are entered into the appropriate txt boxes instead of adding all the values together to give a sumation, it just adds them together i.e. if the numbers in the text boxes are 3, 4, 5 and 6, I want to...Code:=Nz([txtprice],0)+Nz([txtshippping],0)+Nz([txtimporttax],0)+Nz([txtadditionalcosts],0)
Last edited by zmbd; Mar 19 '14, 07:06 PM. Reason: [Z{Please use the [CODE/] button to format posted script and formated text - Please read the FAQ}] -
Thanks! I am a bit new to Access so tried the first method first then used the second one as well when I had more confidence! Thanks to both!Leave a comment:
-
Before event for checkbox
Hi there,
My level of VBA coding is not great and I can get by with docmd. functions but I want to have a checkbox which if it is not ticked means that subsequent data after it cannot be entered (so the text boxes are greyed out) but when the checkbox is clicked the text boxes become active and allow data entry. Can someone help me?! -
Convert a filled in form into report
Hi there,
I have a form that I want users to fill in and then on a button click have that information entered in the active form turned into a report. I can only find ways to export entire sections of data into reports not individual active form windows! Help anyone! -
Thats great! Thanks!Leave a comment:
-
Open blank email from button
Hi there,
I want to have a button on an 'admin' form whereby the user of the database would click the button and a blank email would open in Outlook for the user to enter his/her problem into. But I want the 'to' email address and subject to be already present in the new email.
If the Outlook program is closed, when the user clicks the button I also want Outlook to open and the blank email with subject and 'to' address...
No activity results to display
Leave a comment: