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...
"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.
<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 "Join" 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("location","peripherals","location=" & [asset number]))
run this in the main form's OnCurrent event.
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 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 "You have Birthday cards to send"
End If
The...
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 "hanging around". 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.
"D:\PathTo MsAcces\MsAccess.exe /decompile "D:\Path To Db\YourDb.mdb"
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.