Recent content by baldeagle

You mean like a histogram?

Have you ever used one of those plant identification guides? I'm attempting to make some decsion logic much like that. It involves many many queries, so I've decided to save them in a table. The table has: pk: ID (autonumber) QueryDescription (text) SQLTest (memo) NextStepTrue (Number)...

I posted in this section because I don't know a better category. I have data (from a cross tab report) that looks: and I would like it to look like: So that the 'X's make a diagonal.... It helps the humans understand the data better. :D I was thinking of exporting the query to excel and...

I've got a table with the following fields: UnitID Event Date An example would be: Unit Event Date 01 Start 1/1/06 01 Finish 5/1/06 02 Start 2/6/06 02 Finish 01 Start 3/9/06 01 Finish 4/1/06 ect... I would like to write a query that lists all the Units that are...

Nice error trapping. :)

I'm searching through some text fields like the following: Ann12 #1 Ann12 #2 Ann12 #3 Ann1 #12 Ann2 #14 ect... I'm doing a like query Like "*#*2*" However, the # is the keyword for Date, so what do I use instead?

Cool. I'm over in Channelview/Downtown Houston, having escaped for College Station. Its neat when the interweb isn't really all that big of a place.

Worked like a champ. Thanks, FoFa. BTW: What part of the state are you from?

That works for finding the very last entry of the Journal (as a whole). However, I want the very last entry of each day, ie. the supper description of each day

The "last" total in an Access query is unpredictiable. I have a Journal, with the main form/dataset being linked to the entries of that day. I would expect the 'last' total word to give me the last entry of that day, ie. what I ate for supper. But in the two qrys shown, it does the opposite...

500 text boxes... Well, lets just say that the form has to be printed as a report with page breaks to keep it in check. I didn't design the form, its just my problem to deal with. Basically, the owner of the form wanted the filter by selection funtionality, by listing all distinct entries for...

I have code set up to disable a textbox by clicking on it (Yes, that right, I want the textbox disabled as soon as it is clicked on) with Me.Txt.enabled = false during the _onClick Event. However, the with which I am working has 500 textboxes. Is there a way to call a function or something...

My primary key for my database a WorkOrder Number. The issue is that sometimes problems span a selection of WorkOrders. For example, if we get a lot of bad parts, 3 different WorkOrders might be affected, and each may have different resolution to the effect. To speed up data entry, I've had a...

I think I've solved a method to have cascading comboboxes on a continous subfrom. The after update on the first box sets the query the drives the secondbox's rowsource, and blanks out all the boxes below it. And so on. Dim EventTP As String EventTP = Me.cbxClass1 Me.cbxClass2.RowSource =...

In excel, you would use the LEFT keyword. Left(String,Number of characters)... try something like that.