Recent content by jamesave

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...

Thank you! This is very useful. I have always wondered why in the world of MS access users, they like to create autonumber as the only key.