Recent content by zach028

I have a whole lot of forms, queries, and reports already set up to look to that field, so for the time being I'll switch to the make-table query to get it done. I look forward to seeing any solutions you have to offer! thank you!

Well, I just pulled two of our progammers over here to look at this and they couldn't figure it out. When I first set this up (about two years ago), I had a make-table query and then an update from that query. I couldn't figure out why I ever would have done that, but I guess it was because I...

OK, so I can't do it that way. Here's what I originally had as my SQL statement: UPDATE [MAIN] INNER JOIN [PAYMENTS] ON [MAIN].acctnum = [PAYMENTS].acctnum SET [MAIN].curbal = [MAIN].[amtclosed]-Sum([PAYMENTS].[pmt]); I still can't see why this won't work! I appreciate you sticking with me...

UPDATE [MAIN] INNER JOIN [PAYMENTS] ON [MAIN].acctnum = [PAYMENTS].acctnum SET [MAIN].curbal = Expr1 WHERE Expr1 = [MAIN].[amtclosed]-Sum([PAYMENTS].[pmt]); Here's the SQL. I added the table name to the where clause (I didn't have it in before). Now it tells me "Can't have aggregate...

I'm trying to run a query and am getting the error message "You tried to execute a query that doesn't include the specified expression as part of an aggregate function or grouping" I've been all over the net this morning and can't find something that will help. Here's the scenario...

I have a database that is being used by bill collectors to collect on accounts. At the end of each month, through the use of a combo-box, they designate for each account whether they would like to keep it or get a new one. They are only permitted to have 10 accounts at a time. I currently...

My info is coming from 97 but I think it will still apply. Under "view" click on "grouping and sorting". Use the drop-down box to add major and make sure you are grouping by it and not just sorting. Also be sure to set to "group footer" to yes. On the report...

Thanks Gord. I'll consider this one a loss. Zach

I have a corrupted database that I am trying to recover but am running into problems. I can't import anything from it. At all. All I get is the same error message. There are no *.ldb files out there. I also have disabled the AllowBypassKey function. Could I ever recover it or is it gone...

Thanks again for your help Paul. This will definitely work :)

OK, I've worked around this problem. All I did was create a new field in the table and update it with the value from the old field. Here is the code if you want to see.... Dim db As Database Dim tdf As TableDef, fld As Field Set db = CurrentDb Set tdf = db.TableDefs("Homeq") Set...

OK, that did work, but not how I wanted. I see that I may have been confusing you with my terminology (my bad!). That code left the Data Type as text and changed the Format to currency. I want to change the Data Type to Currency and don't really to do anything with the Format. Thanks for...

I'm not sure if a Format Property is set. Looking at the table design, there is of course a data type (text), but nothing is set in the format options. I tried running the code anyway, but it didn't do anything at all. Is it possible to set a format property using code? Maybe by Setting p...

Quite simply, I am trying to format field "CURRBAL" in table "Homeq" to a currency format.

Is there a way to do this? I set up this function but Access asks me to define "Tables". I don't think this function is meant to work with tables but I don't know what else to try. Can anyone help? Function FormatValue() As Integer Dim val As Variant val =...