Search results

ComboName.RowSourceType = "Value List" ComboName.RowSource = "Open;Closed" Regards, Tim

Along with some kind of chicken pizza thing... a winning combination.

That place has character...but no customers:D

Saloon pilot (sea biscuit)...

Quick lunch here...

Sorry, I simply don't understand what you're trying to do... Just tested this in Northwind: When I put an unbound textbox on a report and add a DLookup function to that textbox's control source property... =DLookUp("categoryName","categories","categoryId =1") ...I see a value in that...

If I'm following you, yes... One way to do this is to just put a dlookup in the textbox's control source property. =DLookup("DatefieldName","QueryName","fieldName=X") Regards, Tim

Or you can create a query using the Access Query Grid...assuming your data is related... Tim

Hi there, If you want to use VBA to pull data from three tables, assembling the data and displaying it in, say, one textbox, then the easiest solution might be to use the Dlookup function...roughly... ' Tie together data from 3 tables and put the result in a textbox on a form...

Assuming table1 and table2 and table3 are text boxes located on the same form as txtTest.... Me.txtTest.Value = Me.table1.Value & Right(Year([table2]), 2) & Me.table3.Value Regards, Tim

Set the Key Preview property of your form to Yes. Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer) Select Case KeyCode Case 13, 18 KeyCode = 0 End Select End Sub Look up Keycode in Help for more info... Regards, Tim

Winter approaches and I could use a new sweater. I don't think this is an unreasonable first fix; once properly done it will build up our collective confidence as we move on to more pressing issues, such as the exchange rate between the U.S. dollar and pound...until that's evened out I won't be...

If KeyCode = 187 Then ' Move to a control. Me.TextBoxXYZ.SetFocus ' Eat the key. KeyCode = 0 End If Regards, Tim

DoCmd.RunSQL _ "ALTER TABLE TheTableName " & _ "ALTER COLUMN ID_Number long" Regards, Tim

Who the hell are we talking about here? TessB?

While I haven't used Access professionally in a long time, I still pop in here and watch the same spats erupt and similar thread topics (in the 'cooler and elsewhere) repeat every few months. For example, there must be at least one thread on evolution versus creationism every year…ironically the...

Do their user accounts belong to the same Windows security groups as your account? That is, it might be a permissions problem. Regards, Tim

Is it a "time bomb" (something insidious) or just an expired license?

Try this... Me.Requery Regards, Tim

Try this... DLookup("unit_no", "unit", "[unit_name]='" & Me.units.Value &"'") A pretty good reference. Regards, Tim