Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. LambertH

    Frame and checkboxes

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

    Quick Question about DMax.

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

    When text box has focus, decimal places change. Why?

    "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...
  4. LambertH

    Vertical multiTabs

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

    Force user to enter data by form

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

    Autonum Starting Point

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

    Securty System.mdw file inaccessible

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

    Search 2nd table for match in main table

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

    Search 2nd table for match in main table

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

    'Wheelie' mouse problems

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

    Empty an array

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

    Access 2 to access 2000

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

    DLookup Overflow problem

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

    I have a module on my main form tha

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

    DoCmd Questions. Tuffy.

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

    Need to seperate text from text box

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

    Code to change all references to table/query

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

    Problem with Form_AfterInsert()

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

    Problem with Form_AfterInsert()

    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;
  20. LambertH

    OnOrder Event

    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.

Part and Inventory Search

Back
Top