Search results

Thanks for your reply TJBernard, This was a wery annoying problem, and did the debugging extremely much harder, so I searched several forums, and found others having the problem without any solution or reason for it. In UtterAccess forums, LarrySteele, who is a knowledged person in Access, has...

TJBernard, Did you ever find a reason for this? I'm experiencing exactly the same. For example: I have a function in a Standard Module which calculates some value. If I call a function from the immediate window, after setting a breakpoint at the variable returning the value, it should...

Hi, I've got several sub forms in continous view on a main form. They all have a 1 to many relationship with the main form. Now I was going to insert a field in the main formas a new primary key. I tried doing so, and got a message that the table was 'a primary table with relationship to other...

Thanks for your answer ans advice Peter. I'll have to do some changes then, and I don't hope Access gets to difficult in this process :) . The value created in the function is a unique value, and is ideal as a primary key. It might however be a big difference whether Access creates it as an...

Hi, I have a main form and a sub form. My promary key is a calculated value, returned from a VBA function, which is called from the primary key fields' Default value. Here's the problem: If the user don't use the keyboard, the record in the main table is not created, so trying to do record...

Hi Chris Thanks for your reply and attached db. I've looked at it, and it uses a pop-up. I use a sub form (SF1) in continous form view, and when a record in the SF1 is selected, another sub form (SF2)hows the details of the record selected in SF2. SF2 is also a form in continous view, and has a...

I've tried the HasData in a sample db, but I don't get it to work as it should. I've used it successfully in a report, through a query though. I don't know if you can create a recordset the way you do when your outside the form you want to clone. I would rather run a SQL statement to create the...

Could you post the code you're using, and what level is the subform on? Main->Sub1 or Main->Sub1->Sub2 or anything else?

Hi, In my continous form (sub form as datasheet) I have a field which when receives focus, jumps to another subform where data can be entered. This works great, but I'd like to get the row in the first SF, to be displayed in another color. This to indicate which record in SF1, data is being...

gdomino, Seems like there might be a space or two missing in the sql. Is there a space after the paranthese )AS (should be ) AS, and after the = sign? hth Gerhard

Ben, Try using Forms!MainForm!Subform2.Form.HasData to determine if the subform has an empty recordset. A form IsLoaded whether it has records or not. hth Gerhard

Hi Rich, My e-mail is ger-alf@online.no . Thank you very much. Apreciate it very much. Gerhard

I just discovered today that there's a 'hierical control'. I've searched around to find some good basics of how to use it, but without any big success yet. Does any one know where there is a sample db which has this demonstrated, or some basic info on how to use it? Thanks in advance. Gerhard

danikuper, Just an idea.... Declare a Public variable at module level, so it's accessible from all forms. Make it a Boolean type. In the OnCurrent Event of the main form, set it to False. When another form is updated, set the variable to True in the forms AfterUpdate event. When you return to...

Hi, I wanted to use an unbound form to enter a time stamp. I have the Time and Date part split in two unbound controls. The form is a pop-up. I use the OpenArgs to get a previous and next time stamp info to the form. This works fine. My problem comes when I want to validate the entered...

david, You should not store calculated fields unless you have very good reasons for it. At the moment I can't think of one right now :) . You might get problems with data concistency. However if you must...... Set your StoreField to the Calculated value, something like this...

You don't say what type of form it is, so I assume it's the row numbers of a continous sub form. These can seem to be a bit tricky, because you cant use VBA code directly on a certain 'cell' in the form. You'll have to do this through the sub form query source. If the sub form don't use a query...

Cosmos75, Great....almost :) . I got an error message that said I could not go to that record, so I tried going to the last record instead, and that worked. So now I have the right 'syntax', so now I have to see what causes the error. This is probably caused by some other code, so I'll look ino...

Hi, I'm not getting this to work. Not as long as the button is on the main form. I tried setting focus to the sub form control itsself, and even to a control in the sub form, but I still receive the error form is not open. Any ideas Thanks for the reply Gerhard

Thanks for your reply FoFa However, I think I'll stick with my current publick variable solution, because I've got to many controls on the form already. Thanks for your reply thogh.