Search results for query: *

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...

That is correct, I am trying to access tables from within the same database where the code is run. I've tried using currentproject.connection, but get the same error. It really shouldn't be this difficult to open a table in the current database I'm working in. Anymore suggestions? Thanks, Chris

I am new to using ADO for data access and I'm having some problems. I'm using VBA in Access 2002 to try and access some data that I have stored in a table. I'm trying to build a connection to the database that I have currently open and I'm not having any luck. Here is my code. Dim conn...

Anyone have any help??? If this is a dumb question, please reply and say it is.

I want to be able to subtract values from a subreport in my main report. How can this be done in my main report? Main Report Value -Subreport Value =Total Thanks in advance! Chris

I did try that, but it didn't work. I opened and closed the database a few times and it finally went back to normal. Must have been a glich. Thanks for the response though! Chris