Search results

I just want to count how many items of the same value are in a text box. If text box is not linked to a table or a query.

WayneRyan, Since the text box is free standing and not linked to any table or query, is it possible to do this without using a query? Thank you

Hi, Here's in essence what I want to do: Say I have a text box with the following values in it: NOTE: These values are item classifications Math Science Math Reading Writing Science Math Math Writing I want to compute how many total Math Values there are, how many total Science Values...

Hi, How can I change the criteria of a query? For example, I have a Query called qryQuery1. It has the following fields: Item ID Item Author Item Question Item Classification I want the user to have the ability to limit the items by, say, Item Author and Item Classification so I would like to...

Thanks ghudson. Your code worked! Mike375, What is so hard about the code? It seems pretty straight forward! Also, I'm not a big fan of Batch Files as I like to have everything in one database and not rely on external files! KenHigg, I was just using that as an example! :) Alex

Hi, I have a form which has a listbox that lists all Item ID's currently in the database. The ListBox's Multi-Select is set to Simple. Lets say the user chooses the following Item IDs: 3, 258, and 396. After the user clicks a command button, I want the program to find the records that have...

Hi, I have a folder "C:\Databases" and I have the following files in it: db1.mdb, db2.mdb, db3.mdb, and db4.mdb. I want to copy these files into a folder "C:\Databases2" with a click of a command button. How can this be done? Thank you!

Nevermind, I got it! ;)

Wayne, Thanks a lot. I have one question. How would a sample SQL look like with the sort order specified as DESC? Thanks again!

Hi, I have a list box that displays values from a field in a table. I was wondering how I can make the list box scroll to the very bottom of the list automatically so the user can see the latest values that they have entered? Thank you!

Here is a sample of the classifications: Level 1: Math Level 2: Addition Level 3: Simple, Hard Level 2: Division Level 3: Simple, Hard There is another form (not included in DB.zip) where the user selects item classifications from 4 combo boxes. These combo...

This is used for the user to enter the Item Classifications that they later will use when they are entering the items to choose the Item Classifications for the items. P.S. Macros are fun! ;)

Mile-O-Phile, Here's the stripped-down version: http://www.metriks.com/DB.zip It was too big to upload it to this website. :(

So instead of 'Not Like "None"' it should be 'Is "None"'? Thanks!

I just created one with the following criteria: ItemID4 ICL 1 (Not Like "None") My only concern with this is: Would I be able to disable the criteria through code? Some of the time, I do not want the query to use the criteria. Is this possible? Thanks...

Mike375, Thank you! That got the ball rolling. However, I have another textbox filtering question. Keep in mind these records are not Null. They have "none" as the word in the record. Here is the code that I am using to filter blank, null, and "none" records in a textbox but for some reason...

I created a form using Form Wizard, and the form contained one field on it which is a textbox field. This field is linked to a field in the table. I want to filter that textbox to never display "none" records. Do you need more information? Thanks!

Hi, I have a database that contains test items. These items are then grouped by classification. Here is a sample of the classifications: Level 1: Math Level 2: Addition Level 3: Simple, Hard Level 2: Division Level 3: Simple, Hard I created a form where...

Hi, In the Forms OnOpen Event, I want a textbox (txtICL) to display the last record that is not "None". How would I go about doing this? Thanks a lot!

Hi, I have a MultiSelect list box on a form that contains all of the Item IDs in the database. When the user clicks on an Item ID, is it possible for the item that has that Item ID to be displayed? Thanks, Alex