Search results

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

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?

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

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

Is it possible to link the results of a query in Database A to database B? Other choice is to delete & Append a table with the query results... which is not ideal. I guess I should mention the whats / whys... I've got a table in Database A that contains lots of data. Database B is interested...

For some reason, when opening a modal/popup form from the switchboard, the underlieing reference to the table disapeared. Solved by not using default switchboard. Any Ideas?

I have a text box, when after update refreshes a subform. The first time is it used, it works fine, but the next record - it displays the subform data from the previous record. Strange. Any Ideas? The subform is related to the parent form by a 1 -> Many Inner Join (I think. It is the type...

This works just fine to transfer the value from one listbox to the other, except: If only one value is selected, nothing happens. Weird. Private Sub btnAdd_Click() Dim rst As New ADODB.Recordset Dim ctl As Control Dim x As Variant Set ctl = Me.lstAvaliable rst.Open "tblstdProcesses"...

I know how the header and footer work, on a continous form. However, is there anything that functions the same way, only to the side? Or should I just make it a subform and be done with it. P.S. Happy New Year

I am running MS Access temporairaly (next couple years) until I can convince upper managment to purchase a SQL package & server. In the meantime, I'm having problems with time it takes for forms to load / queries to run, ect. I was thinking of during load, having the frontpage copy the...

Howdy, I am attempting to create a module that will return true if the two passed values are present in a table. tblStaurdays ------------ workorder WorkDate Option Compare Database Option Explicit Function fWorkWeekend(Workodr As Integer, Wdate As Date) As String Dim rst As New...

Howdy, I'm still trying to grasp modules and how they work. I have a form where I need to lock and unlock all the fields. Can I do this using a module and the Me.XXX.Locked property? Of should I just cut & paste this code into each form? -Thanks & Gig'em

I have a continuous form with a text box sourced to tblA. tblA contains 'X', 'Y'. tblB contains 'A', 'B', 'X'. Is there a way to make the text box grayed out if the current record is listed in tblB? Can this be implemented with a continuous form?

Howdy, I have the following two tables: 1) | A | B | C | D | 2) | A | B | C | E |. Table #1 is a list of previous product, so all the fields are known. Table #2 is input by the user - after updating text C, I would like to have text E automatically fill in with the matching value from...