Search results

I am looking into building up a new PC and wonder if I should look at DDR3 or keep going with the DDR2. I am looking for a big computer that could be good for many years (easily upgradable). So I thought that I should buy DDR3, but I am not sure. Is it worth the latency difference? Should I...

I've seen something on another forum and I thought I should tell it to this forum users. It is the use of a tag at the beginning of the title to tell, with one word, in which sub-category the question falls. There is no need to modify the forum itself. It is just a new way to post new threads...

[Import][Access]Importing tables from a secured Access database Hi, I have some problems trying to import datas from a protected Access database. By protected, I mean a split database with both front-end and back-end in .mdb version and an .mdw security. I went through (Translated from French...

I wish a happy Canada Day to all my friends from Canada. Altough I never felt like a true member of this country, I must admit that most Canadians I met, here on IRL, always tried to make me feel welcome and, while trying to convince me of the benefits from being united, always respected my...

I thought that this list of National holidays could be a nice add-on to this forum. This way, we can all send our best wishes to our friends from other countries on their National holiday. Happy birthday to all Luxembourger, if any, from this forum.

I have a customer who made a query with a field that looks like that: NewField: iif(Field1=True and Field2>100 and isnull(Field3);"Blue";iif(Field1=True and Field2>100 and not isnull(Field3);"Black";iif(Field1=True and Field2=100 and isnull(Field3);"White";... And so on, for miles and miles...

MIT researchers demonstrate 'WiTricity' (Wireless electricity) iTWire Wow!!! Imagine the future...

Hi, I have created an mde that was installed on more than 30 computers. All of them work fine but one who gets a message saying that there is a broken or missing reference. How can I repair this knowing that I cannot access the references in a mde? Thanks!

Hi! I have a problem with Internet Explorer's "Content Advisor". I've looked everywhere on the net and found nothing to help. I hope someone here might help me out. I have a computer with Admin and Guest as users. I activated the IE Content Advisor so that the guests could not surf the net but...

Thought that some might be interested in the results of Quebec election... "Liberal Party" lost is majority but are still the governement. Some says that John James Charest might loose is job as leader of the party because he is the one who called the election. They still get most of the...

I once had a problem with a database that was giving me the error "Can't find «Description» field" when closing the DB. I searched the forums only to find out that many had the same problem but none had the answer. The problem stopped within a few days with no reason. Now, it starting again. I...

I have a table with a large text field in it, among other fields. What I am trying to do, in a query, is to show only the characters that are between brackets "[" and "]" for that field. And, if there is more than one pair of brackets, show only what lies between the last pair of brackets. What...

I have queries that give me hundreds of records which they get from many tables with hundreds of thousands of records each. I am looking for something like a passthru query that would return only the records needed from the back-end. Do you believe that it could be done without problem or do you...

I cannot open a form in PivotChart view or PivotTable view. I can't see that option and if I type "DoCmd.OpenForm stDocName, acFormPivotChart", I get this message: "compile error: Variable{acFormPivotChart} not defined". What's wrong? I thought it was a missing reference, but everything seems...

I have a module that, every nights, opens a report and sends it by e-mail to the person the records belong to in a snapshot format. (Its code follows this message...) It's been working fine for a couple of months, but started to act crazy last weekend. Sometimes, it sends more snp files that...

I have a module that, every nights, opens a report and sends it by e-mail to the person the records belong to in a snapshot format. (It's code follows this message...) It's been working fine for a couple of months, but started to act crazy last weekend. Sometimes, it sends more snp files than...

Is there a place where I can find all the reasons for a query to be in read-only? Thank you!

Which of these methods do you think is best and why? 1: -A delete query of the datas of TableX(Back-end). -An insert query of QueryX to TableX. -An insert query of QueryY to TableX. 2: -An union query(QueryZ) of QueryX & QueryY. -A create table query of the TableX(Front-End) based on QueryZ...

My customer doesn't like the fact that the directory where lies the MDB file is not in read-only. I know that, since the first user to connect to the DB has to create the LDB file and the last user to quite the DB has to delete that LDB file, this directory cannot be in read-only. So, I was...

I want to make a short cut to a db that would look like this: "C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE" "\\Intranet\Company\Province\City\District\Server\Shared\Department\Folder\Database.mdb" /wrkgrp...