Search results

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

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

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

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

I have tables with the following relationship: 1. tbl_RecipeList with recipeID as PK 2. tbl_MasterRecipe with recipeID as PK and ingredientID as PK 3. tbl_PriceList with ingredientID as PK 4. tbl_CostVersion with CostVersionID as PK and ingredientID as PK and costnumber as one of the field My...

Just wondering on how a good form is being created.. A bit confused to differentiate a form that will show the result of a query in the subform and how to differentiate a form that would allow edit or new record of the said subform. Looking at northwind databases, one can understand from the...

Hoping to learn more of the beauty of MS Access here! (and making friends along the way) I am pretty much a newbie on Access. Have been looking at some videos over youtube this past month(particularly learnAccessbyCrystal and PC Learning Zone -by Rich). Used to learn SQL many years ago, but...