Search results for query: *

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

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

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

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

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