Search results

I have a number of mutiusers that access my database. I was attempting to split the database by using the tool wizard, but every attempt I have made returns an error. I truely don't know what this error message is referring to. The message reads as follows: "You tried to assign the Null value to...

For the last 2 days when my user's have been putting Data into the database they have been getting an error message that reads "No Records Found". This occurs after they have inputed at least a couple of records. When I go into the database to view the tables all the tables have disappeared. The...

I found the solution to this one. In the After Update text box put this code example: If me.textname.value > 0 then Select case Me.Dropdwnbox.value Case "John", "Peter", "Tom" Me.textname.value = Me.textname.value * -1 Case else End select End if This worked for...

I have a form that has a drop down box where the customer can select an item. I have three items which if select I want it to turn data enter into the text field into a negative value when the customer inputs their data, but only when they make that selection. I am stumped on how to get this...

I have a problem where I need to total up the sum of each group average at the end of my report. In my report for each customer I had to find out what was their average cost per month but at the end of the report I have to total up all the averages together. I have tried using Sum but that...

I didn't know what I was thinking of. I was trying to perform this task in a query that had two other tables in it. So what I did was take the table with the two fields I need and create the greater than query, then I added that query into another query with the other two tables. That provide...

I have two fields in my query , lets call one Access_amt and the other Total_amt, where I only want the query to print out the record of those who's Total_amt is greater than the Access_amt. I have tried a lot of combinations such as creating a subquery with in the query, but nothing seems to...

I'm using MS Access 2000.

I have three subforms on my main form and because there is no data in one of the subforms I get a #Error message in my text box. Here is the formula that I am using"=IIf([subActiveCallingCards].[Form].[HasData]=True,[subActiveCallingCards].[Form]![text6],0)+...