Search results

I'm having the same sorta problem How do you compensate for the alpha sort putting 1,10,12,2, ect...?

On the AfterUpdate event of the part the user enters, set the combo box to "". You might have to copy your code under the combo box and set them all blank also. Make sense?

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

And at the end of the day, thats what counts. Those, and well, backdoors. ;)

I am working on a MRP II system. One table contains generic process steps. The other table contains product specific steps. (I.e. Some products only get baked and bagged, others get pickled and canned.) I figured out how to do it with a continous subform. I can even set the order of the events...

Thanks. Worked Great.... Maybe I need better coffee. :)

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

Access to PDA Same question: Is there a way to run a front end on a PDA, and have it update the backend when it synchs at a later time?

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

Done. Solved that problem. Done Done. I'm having issues with data type mismatch, when the rst.open command takes place. Option Compare Database Option Explicit Function fWorkWeekend(Workodr As Long, Wdate As Date) As Boolean Dim rst As New ADODB.Recordset Dim strSQL As String strSQL =...

What about the report function? You could group it by Week, then turn on the summery options(Count, Ave, Min, Max) Standard Deviation is the Square root of [ The sum of (each sale qty-avg sales qty) divided by the number of sales withdrawls]. Hope that helps some...

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?

Thank You. Worked like a charm.

What code do you have? Currently, None. Are the text boxes bound? The text boxes are bound to table #1. So the users are inputing data into Table #1: columns A, B & C. I want #1 column D to be referanced from table #2 column E, and automatically filled in. (Basically table #2 E =...

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