Search results

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.

Hi MajP, Appreciate your reply and comments in this thread. I've learned quite a lot from poking inside your example file. One question that I can't get the answer is: how does the participants subform able to limit the input data to only one specific student only? In other words, it won't...

I have a simple table "InfoTable" with the following fields: "SetID", "Itemized", "Qty" Try to run a simple query that create to the following statement from the QBE: SELECT InfoTable.SetID, DSum("Qty","InfoTable","SetID=" & [SetID]) AS TotalQty FROM InfoTable; But it produces error: "The...

This is quite interesting point of view. The way the tables are designed with all the normalization effort and anyone without access background would have thought nothing about this autonumber as PK. I wonder if there is any reading that I can read further about the technique of creating a...

thanks for the advise and correction

Hi June, Do you have a recommendation of where should I read regarding building such complex Queries? Was it because of the table schema as well? I am trying to understand the thought processes that you can come up with such solution.. I have been looking at this for quite a while. so my...

I understand this part now by what it means with B data.

Thanks June! I've been looking around for this solution but not many documents or discussions talk about nested SQL in access. I've been pulling my hair out to use simply join statements