Search results for query: *

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.

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

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.

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?

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

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

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

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

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

Thanks, PHV. It works.

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

PHV solved my problem. It worked like a charm.

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

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

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

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

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.

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