Recent content by Compressor

Yes. Thank you. Now I'll must be able to get it to work on this end. Thank you very much! :)

Thanks, that will help me out most likely. But immediately I ran into a couple of problems: 3. Create the following Controls to the form Name: CtlBack Control Source: =IIf([SelTop]=[ctlCurrentLine],"ÛÛÛÛÛÛÛÛÛÛÛÛ",Null) "Û" is character 0219, the easiest way to enter this is to copy and paste...

I have a main form with several continuous subforms on it. These subforms are based on a selection of fields of a complete and editable form, so these subforms are overview forms so to speak. Whenever a field of a certain record is clicked, the other subforms show the linked data for that...

Ow, and about the splitting up of the sales: at first I only meant to have sales linked to cases, since an other situation will almost never occur. But in case they do occur, I will create a client called passer by and invoice it directly should an over the counter sale do occur. So... just a...

It works! Tnx! :)

Thanks for your reply. You know what the funny thing is: there was a point at which it worked. I have started another thread in which I asked about table structures, PK's and relationships. In those tables the adding of a record was no problem. In those tables I kept ALL values that were used...

Don't know for sure, but it seems that you have the same question as me. The Bookmark function seems to be the answer. http://www.access-programmers.co.uk/forums/showthread.php?t=116812 Thanks to ansentry.

Or maybe create a subform which is displayed in datasheet mode based on the table/query which hold the values you want? Datasheet mode with a couple of head(er)s above it, or if that isn't possible use some labels, should represent a table quite nicely.

Well.... I can't ;) Structure of DB and relations is included in jpg. I have created two separate parts for sales. One which is used for over the counter sales, and one which is used for sales and labour per case. I've created two forms (a form with a subform) for the bottom ones. Whenever...

Hahaha.... I'm such a newbie... Can't make heads or tails of it. Well... at least one of them is missing ;) Well, as far as I can tell I need to take a crashcourse on the Bookmark function. So as soon as I've recovered from the crash of this afternoon I will start and do that. Thanks!

I did do the compact and repair action, but I did know about the decompile switch. I'll take a look at that right now (after I've made a backup this time ;) ) Thanks!

I have a subform (continuous) which shows a summary of all clients basic data in a list. Clicking a client requerys and refreshes some other subforms so the accompanying data for that client is shown. Whenever I double click a record, the "main" window for that "object" opens. So say I double...

Pfffffffffffffew.... found it.... in the most obvious of all places none the less.... I did check the forms seperately (say: mainform and subform), but NOT the subform object within the mainform itself. In the tab Data, link child and master fields were still set incorrectly. Hit me please...

I'm getting an error message (informational only): This happens when I start entering data in the field "productname" of a subform. So I'm assuming something in the form or in the code of the form is referring to ClientID. but I've checked it, and there is nothing referring to it anymore...

Thanks for your reply roy. Good thing you point out the difference between relation and relationship, because I just use those words as if they were the same. My english is kind of ok, but in this case the language barrier becomes painfully clear once again. About the amount of PK's and...