Search results

[Name] = DLookup("[Name]", "Names", "Code=[code]") ---Look up the value of field Name in the table Names where field Code equals the value of the code variable on a form--- [Name] = DLookup("[Name]", "Names", "Code=[code]") ---Same line as above--- [Price] = DLookup("[Price]", "Names"...

This is your original description of your tables: -Tbcampaign (ID_Campaign, Campaign name) -TbKPI (ID_KPI, KPI Name) -TbRegion (ID_Region, Region Name) -TbTime (ID_Time, Month, Year) -TbFact (ID_KPI, ID_Campaign, ID_Region, ID_Time, Value) Clearly, you're going to have to use TbFact as it's...

Are you just trying to calculate a number to give to management on a regular basis?

And $100,000 later, they'll be looking for a replacement. :P Good luck with that for real. I've been flown around for interviews as well and it's nerve-wracking to say the least. After you do it enough though, you can talk your way into first class tickets.

Does anyone know what KPIs are and how countries/marks are related?

You know you love it, Adam. ;) And, I don't mind "scaring off" OPs like this. How about if you own a car repair shop and I come in and say, "Hey, I have this thing on my car that makes this noise. What is it?" It's just as descriptive.

Make sure you look into acViewNormal versus acViewPreview. Also, on a much more important note, you've asked an extremely generalized question and provided zero examples that you've actually attempted anything. There was no, "I tried this, that, and the other thing and I got stuck at this...

Tools -> Startup. In the form drop-down, select the name of the form that is your password form.

Yes, it makes sense. The structure of it should contain both the error and the resolution, and there should be a unique ID in there (an autonumber is fine in this case) so that the same error isn't entered twice. The trick is that you have different types of errors. Some are spelling errors...

Three things: 1) Just write an update query to accomplish this. Writing queries in code is a great way to get yourself in trouble down the road. 2) For the time being, put a breakpoint on this line: rst2.FindFirst [ChemicalID] = gintChemicalID Now, get the value of gintChemicalID and...

After my 5-10 minutes of experimenting, I couldn't seem to trap this one. SetWarnings False will in fact skirt around it, but it won't tell you what/how many got missed. One way to do it would be to expand on what Bob suggested and check on a record-level basis. Another possibility is to...

The problem is a key violation, which means you're doing one of the following: 1) You're trying to put a duplicate value into the primary key, which you cannot do 2) You're trying to put a duplicate value into any index that has Unique = Yes, meaning no duplicates

One other way (performs quicker than a WHERE statement): . . SELECT tblStudents.STU_ID ,tblStudents.STU_FORENAME ,tblStudents.STU_SURNAME ,tblStudents.STU_STANDING ,Nz(tblStudents.STU_COURSE_CODE,"") ,tblStudents.STU_TU_CODE ,tblStudents.STU_FAC_NO...

INSERT INTO tblFinalYrs (STU_ID ,STU_FORENAME ,STU_SURNAME ,STU_STANDING ,STU_COURSE_CODE ,STU_TU_CODE ,STU_FAC_NO ,STU_EMAIL) SELECT tblStudents.STU_ID ,tblStudents.STU_FORENAME ,tblStudents.STU_SURNAME ,tblStudents.STU_STANDING...

If it's a report, then you set the columns in the Page Setup of the report (File -> Page Setup) to the number of columns you want, and then set the format to down and across. You don't want a bazillion textboxes like that, especially since all the data already exists. If you're trying to do...

There are lots of ways to do this in code. The simplest is DoCmd.TransferText. Look that one up in Access Help. It's not super-flexible, but you didn't really describe anything in detail, so it may very well suit your needs just fine.

SxMW, before I write this, let me make sure I get it right. You have multiple fields, something like this: Field1 - Text Field2 - Date Field3 - Number . . FieldX - DataType You need to go through these fields and say things like, "Field1, if your value is X and it should be Y, display this...

ADO goes higher than 2.7. However, the more important question is, what is the highest version of ADO on the oldest machine in there? For example, do you have an Access 2000 user with ADO 2.5 as the highest? You want to aim for the lowest common denominator here so that you don't get...

I have to drive to the office and stuff, but if no one gets to it before me, I'll get to it in the next hour or so.

Well, let's dissect that sample you gave: 2008022119444500 20080221 = 02/21/2008 (American mm/dd/yyyy format, stored as yyyymmdd) 19444500 = 7:44:45 pm The last two digits are superfluous in Access (no milliseconds), so drop them. From there, you can use Format and string functions (left...