Search results

i don't have a lot of experience with this but i would say go with java if users might be accessing the app from many types of (non-windows) systems, otherwise go .net, or asp.net (web app). p.s. is that 300 concurrent users? how many might access it at one time?

i think this is one: http://www.candace-tripp.com/Pages/Main.aspx?cat=demo see: Color Command Buttons

hey there. the simple answer is no. many people develop work-arounds and variations like the one you described but, basically, no, there is no built-in way to do it. (not sure about A2007).

the key is the Before Update event. (i'd be happy to hear about alternatives to this though). you can update the timestamp when the form closes, but the user won't see the new date. i suppose you can put in the code into a text box as well, but that could result in problems/errors if changes...

if you remove the default value does the problem go away?

hi. you never have to open it - it's always ready to go. just requery the list. me.listbox.requery

do you have a default value set that fits the criteria? also, what's the data type (not sure it matters though)?

sry, didn't notice.

i usually use MouseWheel.dll.

a string is fine. Docmd.OpenForm "strVariable" Dim strFormName As String strFormName = "Form2" DoCmd.OpenForm strFormName

hello. have a look at the Nulls (Nz) function. if you can post the query we could be more specific. the nulls function can return a value if one is "not available".

i think the first syntax is correct. not positive but it seems the problem is not the validation rule but the data. so yes, you have to enforce the rule at insert time by actually checking the data before attempting to insert it. as for seeing the sql, if it's an access query, you can see the...

here's another link: http://support.microsoft.com/kb/290136

right, i didn't use all the fields there.

i don't use excel much but i think it's safe to say that dates in VBA are never compared 'as they are formatted', but how they are stored; and dates are stored as numbers (type 'double' i believe). so the format should be irrelevant. er, i don't see what's wrong with your statements, 01/01/2009...

DoCmd.RunCommand acCmdSaveRecord DoCmd.OpenForm "Form2",,,"TheTableID = " & Me.IDControl

there is a way, but as suggested, you'll need a unique identifier - an ID of some sort. see pic. (in my pic, field3 is the same as your Qty field).

if you close the first form first, the data will update and the second form will be up to date. or, use the same form and change the data entry mode. key is to save the data - force a save if necessary: docmd.runcommand accmdsaverecord

Docmd.OpenReport(ReportName, View, FilterName, WhereCondition, WindowMode, OpenArgs) WhereCondition: To open a report and restrict its records to those specified by the value of a control on a form, use the following expression: [fieldname] = Forms![formname]![controlname on form]

look up ProcOfLine Property in vba help. there's a good example there that should get you going.