Search results for query: *

The help file says "Only one option in an option group can be selected at a time." So that's that! You'll need to use a simpe Rectangle to 'group' your checkboxes. Then all you need to do is put some string of characters in the checkboxes' Tag property and you can run this code on...

OnKey, Dmax, Zero Out??? I Think you need to post another question.

"Why let the calculation text box have focus" - because the user might want to copy the data and paste it elsewhere. However, jasonmac, instead of assigning the result of the calculaton to the textbox try assigning a string copy of the result. e.g. txtMyAnswer = 1/3 ' assigns the...

When adding controls to a tab control, you first have to select the tab control, then you an use the toobox to add new objects or copy and paste existing objects from other forms, but the crucial thing is to select the tab control (and the relevant page) first.

You could set the startup form to be the one you created. Look for "Startup..." on the Tools menu.

<Soapbox mode on> It is a common mistake to try to use autonumbers to represent something outside of the database, such an a customer account number. If the actual value of an autonumber field is important to you then you are not using the autonumber facility they way it's intended to be used...

Try this. Locate the Workgroup Admin program. It's called Wrkgadm.exe and you should find it in C:\Winnt\system32. Make sure that you still have the default system.mdw file, it too should be found in C:\Winnt\system32. Run Wrkgadm and click the &quot;Join&quot; button. In the next dialog...

I assumed that the name of your command button was 'cmdbutton', just change the code to reflect the real name of the control. AFAIK, Access 2002 dos Dlookup's the same as Acces 97, but I could be wrong there.

cmdbutton.Enabled = not IsNull(Dlookup(&quot;location&quot;,&quot;peripherals&quot;,&quot;location=&quot; & [asset number])) run this in the main form's OnCurrent event.

You'll find a solution here... http://www.lebans.com/mousewheelonoff.htm

you could make it a dinamic array which will allow you do do this... Dim EPArray() As Single ... ReDim EPArray(1 To 9, 1 To 3, 2000 To 2003, 1 To 12, 1996 To 2003, 1 To 12, 1 To 5, 1 To 4) As Single ... ' your code does it's thing and then needs to empty the array ' so... ReDim EPArray(1 To 9...

YOu will need to load in into Access 97, have it converted to A97 and then feed the converted database to A2K

You have Dim src As Integer but I'm guessing that MAWBID is a primary key (AutoNumber?) field in your table, and so it is most likley a long intger,. and that's where your overflow error is being caused. Change the declaration of src to... Dim scr as Long

I think that if you had just modified your original form Load event as follows, that the form would have displayed itself prior to the MsgBox dialog poping up... lngCount = rstItems.RecordCount DoEvents If lngCount > 0 Then MsgBox &quot;You have Birthday cards to send&quot; End If The...

Try... [Forms]![frmECNMasterData200]![BOMComponent(s)]! PartNumber.SetFocus DoCmd.RunCommand acCmdSelectRecord DoCmd.Echo False DoCmd.SetWarnings False DoCmd.RunCommand acCmdDeleteRecord DoCmd.Echo True DoCmd.SetWarnings True DoCmd.Close acForm, &quot;frmWarningECN_BOM&quot; Setting the focus...

Are you using Access 2000 or later? If so take a look at the Split() function. It will break your string up at the commans for you.

Check out Rick Fisher's Find and Replace tool. Works wonders for me. http://www.rickworld.com/products.html

Jim: Great that you got it all working. Decompiling: In an Access mdb you have the VBA code in text form, and it is compiled into a machine form. As you make changes to your code and recompile, sometimes old bits of compiled code are left &quot;hanging around&quot;. This sometimes causes...

I just tried your code on a simple form and it DOES run the AfterInsert event. ???? It may be time for you to backup the database first (very important) and then decompile the database. &quot;D:\PathTo MsAcces\MsAccess.exe /decompile &quot;D:\Path To Db\YourDb.mdb&quot;

How are you changing the sort order of the first form? If you are using the toolbar button to sort with then you are out of luck. None of the form events seem to fire when that's done. But if you do the sorting with code just add another line of code to sort the data in the second form as well.