Search results

Hi all, it's easy to set up a form with a combobox that will list all records and moves the user to the selected record. But I can't figure out how to just show a selection of the records in this combobox, instead of all records. So, to use the example used in most online tutorials: a drop...

Yes, that seems to have been the problem. I added: If Not IsNull(ctl_prime_ID) Then Works like a charm.

Yes, I didnt change anything to the code. Could it be caused by the fact that it tries to get the primary_ID from the ctl_prime_ID field on the form, which however is not yet generated? It is only generated when I start filling the other fields in the form.

It doesn't get out of the While Not rst.EOF loop when making a new record.

Great! Thank you so much. Now, I really hope this is the last problem I ask you to solve: the database crashes when I move to a new record in the form.

When I'm viewing a page in my form I want to have only those checkboxes ticked of the strata a feature belongs to (so the saved label captions). What happens now is the following: I view a page in my form of feature number 5. It has pre-ticked the checkbox CB1, corresponding to the saved CB...

Checked it again today and it does work. Don't understand what was going on yesterday. Probably my brain didnt cooperate. Anyway, it works only in part. As soon as the script checks the checkboxes it doesnt uncheck them when the criteria are not met. I tried with an else statement after If...

Yea, I used the edited version. Debugging gives me this: Rst.EOF = false Rst.Fields(0) = "CBLx" (so, the correct caption of the label) Ctrl.Name = "Auto_header()" I was wondering, the checkboxes themselves have no caption, only their associated labels do. Something going awry here maybe?

I set all checkbox defaults on false as you suggested, but It doesn't work. I don't get an error message either.

Okay. next problem. When displaying a record on the form I'd like to have only the checkboxes checked of the strata the feature belongs to. So, I want to set the value of the checkbox on true when a feature is present and on false when its not. I tried to put this query "SELECT * FROM...

Another thing I don't yet understand is why there is an uneven number of parentheses. I assumed that parentheses always appear in pairs as they have to surround a function or string or something.

It works! Also when using currentdb.execute. Why did you replace docmd.sql with currentdb.execute in the first place? What's the difference between the two? Many thanks for helping out!

Yes, I named the checkboxes and labels as you suggested. When I change current.execute back to docmnd.runsql it adds the records, but only fills the primary_ID field not the stratum_ID field with the name of the checkbox label.

Ok. Now I get 'Too few parameters. Expected 1.' when I try to add records. The same for unchecking/deleting records.

My main problem was that I didn't understand how the reference system works when trying to refer to a variable, such as the name of the check box (in my mind I didnt see how the code knew which of the check boxes I ticked and than only add the names of these - or their corresponding label - to...

But the caption of MyLabel is a variable which depends on the corresponding checked checkbox. How can I refer to a variable caption?

Sorry, its the ID field, the 'add strata' command button and either the name of check box 1 and 2, but preferably the labels of check box 1 and 2. Found out that i could refer to the bound label with Control.Controls(0).Caption Although I still don't completely understand why this works... I...

Mmm. Yeah, you're totally right. Thanks. The reason why it kept going wrong is that I was trying it with Forms!feature_form!Control.Name But then it couldnt find the specific control I mean and gave an error. Just in the process of getting familiar with the conceptual side of how this VBA...

Yeah, I just realized that too. Attached a screenshot. The button is in the same form. The present two checkboxes are just for experimental purposes. When everything works, in stead of 2 checkboxes there will be in total 41 of these. I tried to recode it using DAO but got stuck with the same...

Thanks, that worked! Now I want to move one step further and add a command button to append the records of each of the checked strata at once. I created this code: Private Sub cmdStrata_Click() For Each Control In Me.Controls If Control.ControlType = acCheckBox Then If Control.Value = True...