Search results

can't tell how to help you from that description. if it is a bug in excel, have you tried searching for a hotfix form microsoft? is your excel program up-to-date with service packs and updates? if not a bug, what is your formula? what do you expect to happen when you copy it (write out the...

i think i also have to mention, because it might not be obvious - avtuvy, if you are building this database for others to use (network, commercial, other) you have to be aware of what will and won't work in previous versions. split forms, like missinglinq says, was something introduced in...

when you copy a formula to a different cell, the formula updates any references to the changed location. e.g., in cell A1 you create a formula which look like: =A2*10 if you then paste the cell A1 to B1, the formula will automatically update to: =B2*10. is this what you mean?

value lists are problematic and limited. i would urge you to make this 'value list' a separate table called tlkpYourValueListName (including primary key ID and values) and then use a query of that table as the control source. you will then be able to manipulate, update, change, select to your...

what you want is certainly possible. if you followed the tutorials but it still doesn't work, then we'll need more of a description of your actual scenario - or better yet, your db posted here (with some advice on which form and combo is the troublesome one).

just a tip - your PK and FK should have the same name in all tables they appear in i.e., HuisgenotenID (PK) = HuisgenotenID (FK) NOT HuisgenotenID (PK) = HuisgID (FK) based on PERSONAL EXPERIENCE, naming your PK/FK the same will save you MUCH FRUSTRATION as your db project grows and expands.

could you please translate the two words? access might not let you create the relationship you intend because perhaps i can't be done that way. e.g., tblMuseums and tblMaterpieces - you can have one museum with many masterpieces, but not one masterpiece in many museums (discounting replicas...

why don't you count a field that isn't null from that query? it will still group by ID...

can't really determine that from your description. my gut feeling tells me you probably haven't normalised your data properly. are you able to post a (sanitised) version of your database here? (with a brief description of which report it is that you're having trouble with - some people post...

people's inspection dates actually have nothing to do with the people themselves. normally, all you'd expect in a people table is stuff like primary key, first name, surname, eye colour, phone number, address... etc. then you ought to have an inspections table, with primary key, foreign key...

i have generated reports that are hundreds of pages long. the first thing you need is to base your report of a query, which is made from good, normalised tables. the second things you MAY need, is to use SUBreports. that is, make a query based on your cities. then make a report based off that...

yes, there is an easy way to do it in 'one' report. any other questions?

OMG - ALL that code in a "not in list" event and Mage-7 thought it had nothing to do with the problem??? LOL it's going to take a little while to go through all that....

ah great - glad you fixed it. i didn't even notice it! good work. :)

that's a neat trick boB!

is that czeski?

could you please re-post your code using the code wrap? i can't read it like that.

have you tried throwing in a message box with the path displayed, to see if it comes up fine? it's a trick i use when i'm attempting to pass compound variables...

you seem to have used a codec that is proprietry (g2m3) for the video. i've tried installing the codec from here, but i cannot get any video feed, only audio...

are you sure it's not just dbase IV that is limited to 5 decimal points? just an idea...