Search results

Good to know, Thanks Bob. I guess I haven't used 2000 for a while.

If you are using 2003 or higher you can create a MDE file for users. Tools | Create MDE File

Yes, If your in the same query, it's only going to count rows where columnA equals 2 AND columnB equals -1. If you need to count multiple fields separatly, create different queries. Then you can create a 'master' query that looks at your other queries.

Open the query, right click on a field below and select 'totals'. A new row appears called 'totals'. In the [option A] column, totals should be 'count' and criteria should be 'like -1'

Why would you want to store a calculation in the table? Run the calculation on the form or in a query at runtime. There is no reason the store this value in a table! No wonder your driving yourself crazy. You can store this value using VB coding, but I do not recomend it.

Not enough info.......... Based on what you said, I would setup the table and a bunch of yes/no(boolean) values. Then whan you run a query, count how many [Option A]'s = -1

In the control source of [line total] write, =[quantity]*[price] if those are the names of the textboxes. To get a grand total, use a form footer. Create a new text box with its control source =sum([line total]) If still not working, you'll have to post your DB.

First of all....... Why would you need a table tblAssignment? It seems like this is just duplicating data. Link the two tables and create a query that will display info like tblAssignment would do. Put another field in your tblMeasures that links to the ItemID in your tblPurchases. You will...

There are two header/footers on a form. Page Headers/footers Form Headers/footers Form headers will show once every form, and page headers will be shown every page.... Hope this helps...........

I don't think you can do this because an IIF statement is not a value. I have done this before by adding code to the OnLoad event of the form. Try adding your code there....... except you woulg write it like If Me!Hours = 0 then me!OUTPUT = "YES" Else me!OUTPUT = "NO" End if

I do not understand you question...... Please explain

I'm sorry............this code works........... Function RMin(ParamArray avValues() As Variant) As Variant Dim vThisItem As Variant, vThisElement As Variant On Error Resume Next For Each vThisItem In avValues If IsArray(vThisItem) Then For Each vThisElement...

I got it................. I threw this code in a module, and I'm able to run this from the form level. Hope this helps someone else out there!!! Function Min(ParamArray avValues() As Variant) As Variant Dim vThisItem As Variant, vThisElement As Variant On Error Resume Next For...

I have a form with about 100 unbound text boxes. How do I get the Max and Min values of these boxes? I spilt these boxes into groups of 10 and I need to find the Max and Min values of each group of 10? I was hoping not to have this calculation run in VB because there is alot of other code...

Why not use a command button? Anyways, I have acomplished this in the past by: In my continuous form, I add all the fields I want to display in my details form and hide them. Visible=false I then create a new form that is not linked to any other form and with no recordsource. Add some unbound...

Do you have a sample of the database you can POST?

Oh, i forgot to tell you. That is a subform I had to bring in for the last count of "MU". It needs to stay on this form to work. In the design view of the input form, you can shrink the size of the subform to nothing so the user wouldn'd even know it's there.

I got it working..... You might want to rename the form and query to fit your naming convension. Remember that tables, queries, forms, controls, etc. should not have any () or spaces. Let me know if you need me to explain what I did. See attached......

Will Form C, or whatever the keyword is, be included in your table? If so, what field?

So it's OK to have Form A #523 and Form C #523?