Search results

I have this in the Format portion of the text box property: [Blue]\R;[Green]\R;[Red]\S;© I have Font Name: Wingdings 2 I have Border Style: Transparent I have Enabled: Yes I have Locked: Yes I have Tab Stop: No I have Default: True I have Source: Running (a Yes/No field) I have the following...

Forgot about that, I'll check it out

See this thread by @CJ_London for reference: https://www.access-programmers.co.uk/forums/threads/use-a-textbox-as-a-resizeable-and-colourful-checkbox.305659/ The formatting doesn't appear to be working as intended. Clicking on the form control still tries to enter text in the field even when...

Thanks for the explanation. I feel better that this is what I was thinking/understanding. Looking back I had the basics idea correct. It was just the default = 0 thing that was tripping me up. Thinking about it now, I think that the 0/null issue may have been the root cause of some of my...

Thanks @Pat Hartman! That makes sense. Now for the follow-up. Apologies in advance because this is probably form building 101... You've seen the table structure I posted in post #5. That is a portion of the database relationship view. When creating the query that will serve as the...

Maybe it's not working as I expect or I haven't noticed it, but, all of my joins are inner including the one optional FK and it seems to be functioning properly when I set the default to null. What is the reasoning behind making the optional FK to a LEFT join?

@MajP - Spot On! Thanks! @Minty - If that is the case, why does every tutorial using this type of setup (and quite a few posts from experts demonstrating this idea) not alter the default join type at all? Just to be 100% clear. Removing the default value of 0 from the number fields that were...

@The_Doc_Man - I don't doubt your expertise, but I THINK my relationships are fine the way they were. I've checked a bunch of different posts on here and they all have the same type of relationship when they have a list table related to a main table via a FK. A 1 on the list table and an...

Ok. I changed all of the join types as you said and I still get the same error. I posted the table relationships earlier. Here is the query design relatonships:

These forms are broadly similar in format (not neccessarily presentation) in that they are bucket of text fields to be completed to take snapshot (test results, current equipment status readouts, etc). Your example of a line item/invoice seems like it would apply. But, it's not feasible (imo)...

It's quite possible. Here are the relationships. I've cut the other parts out as they are not currently implemented on the form.

Before I can save the main record, it wants a value to store in the field bound to the disabled combobox. Ex: "You cannot add or change a record because a related record is required in table 'tblMotors'."

My idea for the form I'm working on is to have a section that is a compilation of addable "subrecords" for lack of a better description. 1.User completes main part of form 2. User adds a variable number of subrecords using command buttons (click button, fill out subform, save). 3. These...

I have a few different bound comboboxes that have a query (just the full list table plus a conactenation field) as record source for list selection. They store the FK in the main record. Howver, not all of these are required on the main records and I enable/disable the combo boxes as needed...

I could have tried it, it would have worked, and I STILL wouldn't have understood WHY it worked 🤪 But, thanks to your explanation, I now understand. Thanks!

Yep. Now that i recall the other sub, I can use more than one Dim ctl without running into a conflict. I've edited the previously posted code to reflect the change. As for your other note, I don't see how that works if the user is clicking on the buttons? while the form is already active?

Might be a remnant when I had nested code that used the ctl object twice. So, I changed the name on one of them. I reworked the code to as it is now. Might work back as "ctl". I admit it is confusing a bit. I'll see if it works.

Here is my final code that seems to be working very well. I put it all in a module called modButtonPress: Option Compare Database Option Explicit 'These subs format option group toggle buttons based on their selection status 'This provides the look of a depressed button when selected 'Modify...

Where's my ruler...no arguing in class...WHACK! Everyone's comments are duly noted and my code is working as it should. Thanks! To wrap things up I used a Select Case block and put it in the Click event of the Option group because it fires last and because it would seem logical to someone...

I might need to take a brief break from this....o_O Seeing @Pat Hartman mentioning "lectures" conjured up a picture of her walking around a classroom with a giant ruler speaking in a bad german accent "Zee table structure must ALWAYS be normalized...whack!" 🤣