Search results

Hi Access community experts! I tried but without success to use crosstab query to make Table1 to become the result in Table2. I put it in my sample file so that you can see both the Table1 and Table2. Hope someone could give me an answer or some clues. I'm using Access 2003. Thanks a bunch in...

Many thanks to Chris.

Hi there! Instead of trying to count within a string, I try to count in a table field to find out how many are upper case & lower case characters, how many are numbers, and how many are other characters. I use the code below but the answer I checked, it ain't right. I seem to hit a block now and...

Thanks John. However, I am still looking for the solution on combo box control to bind to the listbox list. Reason being I want to build further code base on users can do a multiselection of items in the list box. Hope to get further tips on this. Thanks again.

Hi there! It could be a simple bound control example, but I am getting no where after attempting for several hours. Hope to get help in this forum. I have a list box that displays output content from a query named QryCustomerSales. (contents are CustomerID, CustomerName, PO, POItem, ParNumber...