Search:

Type: Posts; User: ready4data; Keyword(s):

Page 1 of 11 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    4
    Views
    2,665

    ADO delete sql not working with LIKE

    Thanks to both. That was the issue exactly.
    Scott
  2. Replies
    4
    Views
    2,665

    ADO delete sql not working with LIKE

    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 =...
  3. Replies
    3
    Views
    546

    Mark, I was thinking that similar to the...

    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...
  4. Replies
    3
    Views
    546

    Hi, In Access 2000 I have a rollong 12 months...

    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...
  5. Replies
    2
    Views
    603

    Hi I need to do a match between table with street...

    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...
  6. Replies
    15
    Views
    991

    Francois, Scary how almost live this forum is....

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

    Sorry, Should have looked before I posted. I...

    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...
  8. Replies
    15
    Views
    991

    Hans, Its almost there but something isn't...

    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...
  9. Replies
    15
    Views
    991

    david, I tried that too. Still same message. ...

    david,
    I tried that too. Still same message.

    Scott
  10. Replies
    15
    Views
    991

    Not when it is on the very last record. Scott

    Not when it is on the very last record.
    Scott
  11. Replies
    15
    Views
    991

    David, Thanks but it never gets to that point...

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

    Hi, In Access 2000, I need to take a table with...

    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...
  13. Replies
    4
    Views
    426

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

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

    Scott
  14. Replies
    4
    Views
    426

    Hi, I'm using MS Access 2000 and I need to move...

    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...
  15. Replies
    2
    Views
    657

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

    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...
  16. Replies
    2
    Views
    657

    Hi, I'm struggling with something I thoought...

    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...
  17. Replies
    3
    Views
    476

    Re: Query Quandry (A2K)

    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
  18. Replies
    3
    Views
    476

    Query Quandry (A2K)

    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...
  19. Create query in vba using checkbox as criteria (2000)

    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...
  20. Replies
    3
    Views
    421

    Re: Concatenation Query (A2K)

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


    Scott
  21. Replies
    3
    Views
    421

    Concatenation Query (A2K)

    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...
  22. Replies
    2
    Views
    344

    Re: Survey results help (2000)

    Hans,
    That makes some sense. I'll see what it looks like.
    Thanks,
    Scott
  23. Replies
    2
    Views
    344

    Survey results help (2000)

    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...
  24. Replies
    1
    Views
    282

    Add items to Listbox (Excel2000)

    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...
  25. Re: Find a cell meeting these conditions (Excel 2000)

    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...
Results 1 to 25 of 274
Page 1 of 11 1 2 3 4