Recent content by lifter10

There are no null values

Anyone???

monsky, that's exactly what I would like to do. I'll look into ClearMatch and see what it's about. I would like to be able to do this on my own, but it sounds like a huge undertaking on my part.

So, do you mean that people contract out this kind of work or they purchase the software that helps determine the matches? A point system sounds like a good plan, getting people onboard with that plan maybe a challenge.

I've just started a new position and it's been a career change for me (went from accounting to database analyst). I'm moderately experienced with databases, but need some advice from everyone. We have a database of potential people we would like to send mailings out to. About everyday, a...

Can anyone help me with this problem???

Here is my update query: UPDATE Final INNER JOIN [Fix D5_ytd] ON Final.Cusip = [Fix D5_ytd].Cusip SET [Fix D5_ytd].Consideration = [Fix D5_ytd]![Consideration]-[Final]![Total], [Fix D5_ytd].[Gain/Loss] = [Fix D5_ytd]![Gain/Loss]-[Final]![Total], [Fix D5_ytd].[Total Gain/Loss] = [Fix...

I'm using Access 2002 and I have an update query that takes a value from the table and subtracts out the value of another table: Update To: [Fix D4_ytd]![Consideration]-[Final]![Total] Now I have several other columns in the update query updating different columns by the same amount [Total]...

Wow, I've had two easy questions today. Thanks for the response! Maybe I could use my head a little today. Thanks again, Chris

anyone?

I have one Access(1) database that I would like to run a specific function in another Access(2) database. How can this be done? Basically, the function in the other(2) database runs some code and then executes a make-table query that makes a table in my first(1) database. Thanks in advance...

Sweet! I don't know why I couldn't think of that, but thanks a lot for the help! I've been stuck on this for a while. Thanks Bob! Chris

I am running a make-table query and I set up 2 fields where the values are zero. Later I run 2 update queries for these zero valued fields and I get a conversion error. What happens is when the make-table query runs, it sets these two field values to Long Integer. When I run my update query...

Alright, that worked! Thanks Roy. Do you know the reason it wouldn't work when I used the New keyword in my declaration? In Microsoft's documentation (Porting DAO Code to ADO with the Microsoft Jet Provider), it shows it being done the way I first tried it. Thanks for the help, Chris

In other words I put in the following code into a private function in a module: Dim conn As New ADODB.Connection Dim rst As New ADODB.Recordset conn.Open CurrentProject.Connection The error says: Run-time error - '2147467259 (80004005)': The database has been placed in a state...