Search results

Hi, Mark Thank you as always, and that's exactly what I was thinking of, select queries won't change anyting in a table, I will take another look to see if I had overlook by mistake, or the developer of this database wrote some code to achieve his goal?? I will dig a bit of the information...

HI, Mark and all Wish you all well these days ! I am recently studying a sample database, which uses much less VBA codes, and the design of the forms are elegant, all the functions I am looking for seems there. however, what makes me most fascinated is as below I attached the screenshot to...

Fantastic, Mark, I will consider this immediately, though it sounds a bit intimidating to make calculated fields. I will do a research to nail it down, thank you, Mark ! Good weekends ! Kindest Regards Minn

Thank you, Mark, as always ! I really like your idea of "focus you on user experience and ease of operation " This afternoon, I learnt a lesson to open a filtered query from a form. that was really exciting, coz I stealed some code and put into the query criteria, add a botton on form with a...

It seems I am going nowhere for now, though I digged into NorthWind examples, but, really feel lost given so much events triggered by codes. I think I am getting into a wrong direction, but, really have no idea what is the next step to move forward. not sure if you can give me some exercises to...

This is tremendously insightful, Mark ! It's really silly me that I even forgot the most important lesson, yeah it is truely real the control box is actually the ribbon stuff ! now I fully understood what you were referring to. I will get used to the professional habit, the database is...

Mark, the illustration is elegant, and you don't know how excited I was, I made a simple ledger with combo box to show the chart of account for my subordinate, and she is really expressed, :p in the three method, I like the second way the most. Just a few further questions, if you don't mind...

Hi, Mark the layout of your form looks so cool, I tried to set the property parameters the same as yours except what's in the data tab, however, my form is still displayed in full screen view, don't know how you managed to resize your form ? By the way, it seems I could not find the combo...

Hi, Mark, no apologies please, you are always so helpful, and I don't know how to express my gratitudes to you. I feel I really pick up the thing faster than I initially expected, that is because of your help and guidance, I am really getting into the right path, thank you ! I will take a...

Combo box only gives unique value to different records, I wish having a different value on different records. By google search the internet, and studying sample database, I think the solution is to use SELECT DISTINCTROW statement to solve the problem. I just got the half way; after put the...

Hi, Everyone, Hi, Mark It seems long time no post, wish every one of you well. I am trying hard to learn combo box, the drop down list looks cute. here is my work, but, with problem. I have a subform, where I wish could have a dropdown list in datasheet view, so, the user may pick the...

Mark, Thanks very much, I won't be able to get the basics quick without your help. it is really pity my workload as accountant will put me off the topic for a while, as year end closing requires tremendous input from me, hopefully I would have the basics with me once I got my chance coming back...

after deleting the link between tblPackSpec and tblVareity, it works out nicely, very cute, Mark ! :) Kindest Regards Minn

Hi, Mark Yeah, I noticed the toolbox being named as controls in 2007 ( I mistake my Access 2007 as Access 2010, this is wierd part of my installation, what I installed is Ms Office 2010,but, the access on my computer is Access 2007:p). thank you for the brilliant explanation about objects I...

Hi, Mark When working with query based on more than 2 tables, I got SQL statement not executable due to ambiguous outer joins. This is really a complicated concept to me. I tried to understand it by google some information, here is the summary info I got Quote Begin...

Good Morning, Mark It is really amazing, by following your instruction, I can make the desired form now, please see the attached screenshot. Just wondering what is the exact reason I have to build my form upon a query, instead of directly using table; probably this is a question regarding to...

Hi, Mark, I think I am able to make addition in the form now, attached with the screencatch to show the total in a field I made. Meanwhile, in the same form, you may notice that I can not get the exchange rate successfully into the subform field under the title of Ex Rate; the second and third...

Good Morning, Mark, as always, thanks very much for the beautifully laid out sales ledger . I looked into the forms design view, and changed the design from continuous subform to a speadsheet view of F002, it changes accordingly in the form 001, really fun experience. It seems the formula of...

Mark, as always, thank you a ton. I guess I managed to introduce a foreign key in the other related table, however, it was made in a different set of data base, which is only for trial and error purpose. I will do the same on the "Sales Model Practise", which I have been posting since, just to...

Even though the form is able to display data from two tables with link by Customer field, the Q'ty & Inv Val in USD content only display a single line of record in the source table, I was expecting the sum of each customer, which is not the case for the moment. I also attached the screenshot...