Search results

Lesson Learned. somehow I missed that it was locked in the VBA when the form is opened.

thank you for your time too @theDBguy

this is embarassing. Can I delete this thread? Thanks Xavier.Battle

here you go. Take a while to clear up unneccesary parts/data

just the subform

Not sure if this is supposed to go to the VBA forum or this.. but here it goes: I have a form with a linked subform. The subform is populating the proper view of the data (filtered on the parent linked field) Then I add a button on the main form to allow adding a new record for the subform...

thank you. I guess the missing step was step #5; this is when the query is calling the function in the mdlImage module Appreciate your time to explain this, MajP

This is an interesting solution.. so in the demo form (the continuous form), there is no vba code. the control source (object Image9) is ImagePath. How does it know when to call in the module (mdlImages) to get the ImagePath information?

This is very helpful.. thank you for all your responses. special thanks to arnelgp for showing the GUI

So, I have been looking at sample codes regarding file picker. There is plenty of mention of FileDialog with msoFileDialogFilePicker. How do one look at the details of the library? Using google, it show this particular page: it's a link to learn.microsoft page (I can't post the link, but...

Let's say I have an order form. I'd like to have an subform in that form where it will dynamically tab pages with the number of items from that order form. Is this possible? the order form has a limit (up to four) entries. Each of the tab will then have same detailed pages, just different...

Noted. Thanks for the input! I just create a cmdbutton to toggle for the Edit. It should at least will not allow the user to accidentally edit the values. There should be better way to implement, but it works for now.

In Northwind DB frmProductDetail, I try to make the user unable to Edit the data by putting me.allowEdits = False when the form is open Private Sub Form_Open(Cancel As Integer) Me.AllowEdits = False End Sub This make the combo box cboFindProduct unselectable in form view. What is the best...

This is one thing that I tried to grasp when looking inside the Northwind DB.. I simply look at the event list of the property sheet when selecting this field in design view. There is nothing in any of the event. Then I looked at the code for this form and search for txtProductID which is the...

I can't post the link here, but there is an explanation from isladogs website; search for "highlight required fields"

Thank you.. Noted!

Ah I think I understand now thanks Gasman and arnelgpp the link that I was trying to put here is talking about it, but I wasn't sure how it behaviour (quirk?) to this in northwind sample. In the property, the back color is "no color". but once the back style is change to "normal", the back...

Back Color is transparent in design view

I am referring to this highlight when the Product ID field is selected, not on a new record but on an existing one. seems like the background itself is white I just skim over modValidation, it seems to work for the fields that need to be filled in. but I can't find any event that will...

I come across to the northwind 2.0 database (Developer version). In the frmProductDetail form, the txtProductID text field has the property of Back Color is "No Color" and the Back Style is "Transparent". There is no event associated with this field either. But when a user click on this field...