Recent content by kilou

The PK would be the Lot number and it would be linked to sublots that would be stored in another table. Most of my database would use the Lot number level though and many tables would be linked through the Lot number primary key. I really need an update query and not an append one because data...

No I really need an update query not append. The problem is the following: I need to feed my database with an Extract from Oracle that is updated daily (the Oracle extract is an Excel spreadsheet that is linked in my database. I don't have rights to directly access Oracle via ODBD). However this...

Hi, I have a linked Excel file which contains many duplicative values. I need to get the unique values of 1 field and put them into an existing table with an update query. I could figure out how to create a select query that removes duplicates but I can't use this as the source to update an...

No solution to be able to see people that left while preventing them being selected?

Thanks for the suggestion lagbolt. However I still get the same result: if a doc had been reviewed by an active person and now this person is no more active, then opening the form will show a blank combobox. You're right that this person still remains mentioned in the table but it's no more...

Hi, newbie question: I have a form that stores dates when a document has been created, reviewed and approved and next to each date, I have a combobox where I can choose the creator, reviewer or approver. People are managed T_People table with checkmarks to determine who's able to create...

Any idea? I can't believe Access is so slow to compute a count on 13000 rows. I mean it's ok when it's simply a query with calculated weeks, months and years but I also need to compute the nb of workdays between 2 dates and return the average time (via a UDF VBA function, designed by MS...)...

wow that's an old thread! Did you get a solution? I'm facing the same issue.

As far as I could understand, seems like that your first thread was about Jet IIf vs VBA IIf but not Jet IIf vs VBA If then Else.... But I learned that VBA will always evaluate both sides of the function... Is that right?

Hi, I've read that IIf function is somewhat slow since it has to compute both the true and false part of the equation everytime. Would it be better to build a custom VBA function something like this (example of string fields): Function CustomIf(criteria as string, truepart as string, falsepart...

Hi, here's one of my many Access problem as a newbie :) I have large list of batch information in a table, like batch manufacturing date and the date of batch release. Now I have another table which stores target release time with effective date. This means that for example in 2006 the batch...

I ran the performance analyzer on the query and Access proposed to create a relationship between T_Batch and itself on LotID.... I tried but it doesn't improve speed.

Hi, I have a table called T_Batch which stores batch information as follow: T_Batch LotID ProductName Type DateMfg From this table I have created one query Q_Area which calculate the area in which the product is manufactured (one product is manufactured in one area 1 while others are...

OK, I understand that. I will see if I can put T_Release and T_Analyze together but I'll leave T_Batch alone since it's already a large table and it is an imported table. Probably better to leave it alone. Thanks a lot for your help Banana! I'm starting enjoying learning Access :)

Yes it helps a lot! I also thought about putting everything in the same table but in a sense it's also good to have separate tables with one-to-one relationship. Basically the T_Batch table is an import that contains batch information for all batches. Then some people will add information...