Recent content by WitchCraft

  1. W

    Open custom help from F1 key

    Well you must first enable the keypreview ont the form. then use the "run" command.
  2. W

    Null Parameters in Query

    I just use a checkbox on the side and disable the combo when the user wants to select the whole list or no item in the list.
  3. W

    Any Ideas Will Help

    No problem.
  4. W

    Code

    I'd say your problem would be fixed if you just deleted all the records like this : button_action I assume you're positionned on the record to delete? dim rs as recordset set rs db.OpenRecordset("SELECT * FROM tblShifts ORDER By ShiftID") rs.findfirst "recordId="Forms!frmMain!RecordID if...
  5. W

    Check Box -Cosmetic Question

    make a button with an inside style. then use a picture as the checked. :)
  6. W

    Any Ideas Will Help

    Your question is unclear. how about a little math? something like item :[______! !] (combo colum 0 and 1 are hidden, 1 is size, 2 is item name) size :[________] comment:[________] (text fields) 'with comment invisible until you enter a size. 'declare public var dim booleanOversize...
  7. W

    Dynamically resizing listboxes

    Try to do a count of the length of each line in your listbox : compare to the highest value, if the value is higher change the max to it. Move to nexr dim intMax as integer for I=0 to list.count do if len(list.column(0,I) > intMax then intMax=len(list.column(0,I) end list.height=intMax '...
  8. W

    if then else

    Try this : Private Sub SelectSRO_Click() If isnull(Me!SearchOperations.Value) Then MsgBox "There is no value" else If Me!SearchOperations.Value = "" Then MsgBox "There is no value" Else MsgBox "Please enter or select " + "'" + Me...
  9. W

    Importing Text File Error

    Are you trying to import or read the file? If it's just reading it, do something like this to read it line by line : open "[your file's path]" for input as #File1 line input #File1, [Var to hold value]
  10. W

    Dynamic label in a report (lbl.caption goes wrong)

    Sometimes there are certain properties that don't appear in a formula becaue access only shows what is of the same type (boolean,integer,object,...) If the propertie shows up if you make a new line of code with the item only then you can still use it.
  11. W

    Access 2000 and 'Docmd.Addmenu'

    I want to use the DoCmd.Addmenu command. How do I use it? The Access help was useless and hours of searching on the web proved fruitless. Can someone please show me an example of code using this? Thanks.
See more
Top Bottom