Search results

You wil find may post in this matter if you perform a search through the fora on listbox and report keywords. The following also dealswith the subject: Use Listbox to select records for a report

Pat, I never used outer joins for tables relationships, but only for queries. What are the advantages of using outer joins in the very structure design, over using them only in queries when needed?

Thanks Pat. Cristal-clear and cogent as usually. I only realize now that the articles I pointed to do recommend such extensive and probably exagerrated use of surrogate keys. I have so far only used them in top-level tables and have used multiple-fileds PKs in child tables without even wondering...

Use an autonumber field (YourID) and use the display that field in the format "GO6/" & [YourID] in a text box on your form. Disable and/or lock that textox so that the user cannot try to enter/modify the displayed value.

If you are really playing your last cards, you may want to try to Decompile your DB. Beware, this is not an officially supported feature. No success garanteed. Read the following articles before going for that technique: The real deal on the /Decompile switch The undocumented decompile feature

Use debug.Print to get and check the value in gstrWhereProcedure after the loop. I'd like to see what you are getting looks like.

Code could be made mor compact using syntax like Me.Controls("BuyerText" & i) in a loop I am not sure the SetFocus statements are needed at all neither. However, despite of your comments, what you intend to do with your code is not clear to me?

Yes. In the first line a new column in the QBE grid, write something like: AbsValue: Abs([Oral Communication]) BTW you should avoid using spaces in your filed names

Did you try to use a (eventually blank) main form and place into it two subforms side by side?

Check that you have : Bound your combo onto your adress field Set the bound field property of the combo to match the field correponding to the adress in your recordsource (which I suppose is a multi-fields query)

In a query you could check for chr(13) ex SELECT MyTable.* FROM MyTable WHERE (((InStr(1,[MyMemoFieldName],Chr(13)))<>0)); In VBA for VBCrLf ex If InStr(1,YourSting, vbCrLf) <> 0 ...

My personal opinion has little weight in this discussion since I am by no mean a serious/regular/experienced DB designer. But I would defer to Pat's judgment at anytime and I believe the above thread is quite an interesting reference for this dicussion since Pat's position seems (as far as I...

There are known problems and precautions to be taken when running both A97 and A2k on the same computer. There is an artivle in the MS knowledge DB about this though I do not have the reference at hand.

Not sure whether this will help you a lot, but... I went through quite a good amount of 'literature' regarding replication and never came across references regarding particularities for sync. over internet for W2k (I mean in comparison with w98/95). Since W2k is pretty new it could mean that I...

If i remember well Chomsky goes even further, and suggests that there would be an actual kind of 'gramatical center' organ common to humans and providing them with similar fundamental gramatical principles and gramatical construction/interpretation abilities. ie langage would not be only...

You should also try to open a new blank DB and import all your database objects into it.

Hi Colin, I do agree with you and know from first-hand experience (since my field of work lead me to try to learn a few langages , with more or less success :p ) how important it is to try to learn and actually do mistakes. Not only does it not make you look like a fool in the eyes of people...

Ouais, hé ben ça se sent! :p (Try to translate this one :D ) Nice try, Colin but this pretty well proves -if need be- that automatic translation technologies are not mature yet, and good old learning methods still needed for a while ;)

No, I mean modules. With VBA code, not macros. However, you can very probably extend that no-no advice to macros, pages and queries...

You still are welcome to contribute, shep:p Currency , checks and credit cards accepted:D More seriously I believe it would be nice if there were a thread that could be reffered to when expanations are requested on this common and fundamental topic. So other (in kind) contributions are most...