Search results

What VB code shall I create if I want the Intranet online form created in MS Access to prompt me with a message box everytime there is a NEW request?

What VB code shall I create if I want the Intranet online form created in MS Access to prompt me with a message box everytime there is a NEW request?

help! i'd like all fields in my combo box to appear in my report. i've created a query from the table where my combo box is. i'd like all data about the general agent to appear i.e. GA number, GA last name, GA first name but what only appears is the GA last name. this would create a big...

hi! i have defined nine fields which may or may not be filled out (e.g. only five fields could be filled out, the rest of the fields will just be blank). i've created a new field on my query to add the nine fields. however, it's only working when all nine fields have been filled out...

hi RV, i was able to execute your suggestion and it worked wonders. thanks a million

I tried defining this in the criteria based on my research from this site: Between [Enter Start Month & Day mm/dd] And [Enter Ending Month & Day mm/dd] The prompt worked, however, it's not giving back accurate results. What shall I do? Where did I go wrong?

i just found the solution to my problem at: http://support.microsoft.com/default.aspx?scid=kb;EN-US;q129096 here's the correct formula: =Sum([Policy Yearly Contribution]+[Trust Yearly Contribution]) thanks anyway!

May I ask for help from anyone who knows the correct way to add two sums e.g. sum of policy yearly contribution and sum of trust yearly contribution in the report? I've tried this formula: =Sum([Policy Yearly Contribution])+([Trust Yearly Contribution]) It's not giving me the correct answer...

hi pathartman, where shall i paste the code you've created? sorry this is the first time i'll be doing this. thanks so much, ella

hi jerry and david, thanks for your suggestions. i've tried doing your tips. however, my primary key is the client number that's why when i try to count them in the query, it counts the number of client numbers. do you suggest i create an agent number as well for this to work? help! thanks...

hi djn, where exactly will i paste that code? i'm sorry it's the first time i'll be doing this. thanks so much! ella

i'm creating a system wherein i would like to count the number of clients each agent has. i'd like the query to count the primary key to determine this. how do i go about it? help!

how do i define in my query the birthday celebrants for the existing month so that when someone prints the birthday celebrants report, all celebrants for the existing month only will be shown? help! thanks!