Search:

Thanks to both. That was the issue exactly.
Scott

Morning. I have a issue where I'm trying to delete records that match a certain pattern.
The code I'm using is this:

cnnDBServer = New ADODB.Connection
cnnDBServer.Provider =...

Mark,
I was thinking that similar to the trendline in Excel if the last point of the hypothetical trendline in my table is higher than the starting point the trend would be "Up" and vice versa.
But...

Hi,
In Access 2000 I have a rollong 12 months revenue data for my accounts. I was asked to add a column that shows a trend. Up, Flat, or Down. No numbers, just an indicator.
I've used the...

Hi I need to do a match between table with street addresses and zip codes.
I can join the zipcodes easy enough but how can I compare the street names if the zip codes match.
I'm not concerned with...

Francois,
Scary how almost live this forum is. Or I need to be able to type faster.
Thanks to all.

Sorry,
Should have looked before I posted. I just had to add 2 lines (in bold)

Thanks for the solution

Function CreateDealerList()
Dim db As DAO.Database
Dim rs As DAO.Recordset
Dim...

Hans,
Its almost there but something isn't looping correctly.
Here is the output.

http://www.ready4data.com/documents/snap1.gif
Here is a sample database with your function if you can take a...

david,
I tried that too. Still same message.

Scott

Not when it is on the very last record.
Scott

David,
Thanks but it never gets to that point when its on the last record. Its still in the inside loop.
Scott

Hi,
In Access 2000, I need to take a table with 3 fields Data_ID, Dealer, User
and append another table with the same fields in a pipe "|" separated format.( this will be used in another...

Hans,
Sorry, I'm speaking ot the field names in the table.

Scott

Hi,
I'm using MS Access 2000 and I need to move the column names to the first row of data in a table.
Some of the column names will be longer than 64 characters which is the max for Access.
The...

You have to treat null (blank) values separately. Try

SELECT BranchID, Selected, PreviousSelected
FROM tblBranch
WHERE (Selected<>PreviousSelected) Or (Selected Is Not Null And PreviousSelected...

Hi,
I'm struggling with something I thoought would be easy.
I have a table with 3 columns
ID, Selected, PreviousSelected

The Selected and PreviousSelected would contain the value "Yes"

ID...

Hans,
I could add a date field and modify the date anytime the record is updated.
I'm not opposed to a total a new approach since this is a new project.

Scott

Hi,
I'm trying to show the status of 2 pieces of equipment. Monitor 1 and Monitor 2.
I have a table that has the fields MonitorNumber(type int) ,SentDate(type Date), Return Date(type Date)
I was...

I need help in creating a query that can use checkboxes as part of the parameters.
The table has 156,000 rows of data that have to be chopped down exported to Excel in various ways.
Some of the key...

Hans,
I can't thank you enough.
That worked perfectly.


Scott

I'm trying to merge some results from a web survey output using a query.
Each survey has 13 questions. In the output there are some extra rows because of the way the survey is.
If they answer a...

Hans,
That makes some sense. I'll see what it looks like.
Thanks,
Scott

I have the results from an Service Importance survey I did. We surveyed end users and we did a self assesment of what we think they would answer to see how well we know our customers.
The scale was...

I'm using this code to populate a listbox with data from another sheet.
Is there a way to add a button the the form to let the user add an item that isn't in the list?
<pre>Function...

Hans,
I included the Function to show you how the cells in the row get their value.
I modified the Function so if there isn't any sum involved, it won't place a zero in the cell.
<pre>Function...