Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. woro2006

    How to define the mining structure

    The problem is that if I combine all the attributes together, customer ID will be repeated multiple times. Is that going to be a problem when the observation is not unique in each row? Thanks.
  2. woro2006

    How to define the mining structure

    I need some help in defining the mining structure to solve my problem. Suppose I have the following OTLP structure. Sales Managers -> (1-n) Clients -> (1-n) Products Sales Managers Attributes Manager ID Region State Years of experience Age Clients Attributes Client Type (Technology / Finance...
  3. woro2006

    Access Auto Number

    Yeah, but I removed records from the original table. The ids are not sequentially ordered (1,2,3,5,7,10). If I add a new autonumber, the ids will not match up. I need the autonumber to restart on the last id of the field.
  4. woro2006

    Access Auto Number

    I changed the field data type from autonumber to number, but I'd like to change it back. When I tried, I am getting an error. "Once you enter data in a table, you can't change the data type of any field to AutoNumber, even if you haven't yet added data to that field. Any ideas?
  5. woro2006

    Microsoft outlook

    In outlook, I locate my contacts through corporate global directory list. When I open an email, I can browse an employee's details by double clicking on the name of the contact. I want to use vba to do the same - open an email and grab the sender's details (Alias, job title, phone number, etc)...
  6. woro2006

    compact and repair database in access 2007

    Specifically, I would like to do something like the following in Access 2007. Thanks. Public Sub CompactDB() CommandBars("MenuBar").Controls("Tools").Controls("Database utilities").Controls("Compact and repair database...").accDoDefaultAction End Sub
  7. woro2006

    compact and repair database in access 2007

    I just want to compact and repair on the same database that I open using vba. Thanks.
  8. woro2006

    Import data

    hi, i have a few extracts in .csv format updated daily. I am open to all suggestions. I'd like to keep the tables in Access updated. Do I have to import the data and delete the table every day? If so, is there a way to schedule such a task automatically? If not, I try linking the tables...
  9. woro2006

    a ready to use application that does CRUD

    I am a very simple guy. I am wondering if there are any existing open source web applications that does create, read, update, and delete my records in the database. I am using Microsoft Access. Let's say I have a simple table structure like the following. id user password comment lastupdate
  10. woro2006

    access sql query need your help

    Thanks, PHV. It works.
  11. woro2006

    access sql query need your help

    table structure is as follow id field1 field2 1 yes $10 1 yes $20 1 $30 1 $40 2 $50 2 $60 . . . I want to select 1) the records where field1=yes union with 2) the records where field1=Null but the id cannot be the same as 1)...
  12. woro2006

    apostrophe select sql using Like

    PHV solved my problem. It worked like a charm.
  13. woro2006

    apostrophe select sql using Like

    Because I want to do dlookup with the apostrophes stripped out.
  14. woro2006

    apostrophe select sql using Like

    I can't seem to make this work, as I don't have a query string to apply replace(str, "'", "''"). I am trying to query the database for all records that contain an apostrophe. For example, O'connor, O'Donald, would be returned. After that, the replace function would take out the apostrophes (i.e...
  15. woro2006

    Business Days Function needs error handling

    I am hoping that someone can edit the following code to handle 1) When either of the input (i.e. dtstartdate or dtendate) is null, leave the result null 2) When dtstartdate > dtendate, networkdays=0 3) If there are any other errors, just ignore them (i.e. I don't want them to display #error on...
  16. woro2006

    Business Days Calculations that accounts for holidays

    I found somewhere in the forum that I can calculate business days between two days. Suppose I have a table that contains all the holiday day dates (table = tblholiday, field name = hoilday). How can I extend the following function to allow me to account for the holidays in tblholiday. Please...
  17. woro2006

    Access query/search help

    Hi Duane, Merry Christmas! How come your query works? I don't understand that. Can you explain to me what went wrong with mine (why it exclude blanks) and why yours works (include the blanks) in plain English? Thanks ahead.
  18. woro2006

    Access query/search help

    Hi I have a query that depends on the input (several parameters) from a form. The form has a list object that shows the results of the query. For example, when I type in "s" in last name and "b" in city, it shows everybody whose last name starts with s and city name that starts with b. The...

Part and Inventory Search

Back
Top