Recent content by Travis

  1. Travis

    Change Wallpaper with Windows API

    Look here for the difference in your code. http://support.microsoft.com/kb/q97142/
  2. Travis

    kicking people out of a frontend

    First Save yourself some frustration add a global Boolean to your module. Example: Dim mfAlreadyToldYou as Boolean Public Function updwrng() Dim rs As ADODB.Recordset Set rs = New ADODB.Recordset Dim strSQL As String rs.Open "tblLogout", CurrentProject.Connection...
  3. Travis

    Problem with recordset loop

    Use "" instead of '' for MS Access
  4. Travis

    Splitting a Ms Database

    One method would be to have the following 2 Front Ends (One for Branch, One for Staff) 1 Back End (Where the tables are located) You would then link the Front Ends to the Back End.
  5. Travis

    redim preserve multi dimensional array

    See this article. http://support.microsoft.com/default.aspx?scid=kb;en-us;75517 Since you can only redim the rightmost subscript, one way to get the dimension that you want is to know upfront how big you need to make the left subscript(s). You could also look into other possible solutions...
  6. Travis

    Lost all modules

    Make a copy of this MDB Leaving the Original alone (Don't touch it) try and compile the copy and see if you can access the modules. If not then look into Decompile http://www.mvps.org/access/bugs/bugs0008.htm AGAIN I DON"T THINK I CAN STRESS THIS ENOUGH. DON'T DO THIS ON THE ORIGINAL, DO...
  7. Travis

    Using a multi-instanced form as a child form

    Just a question. Why not just put the forms in each of the Tabs through the Designer?
  8. Travis

    Verifying Required Fields

    1. Place this code in a Public Module 2. Add the word "Required" (or "NumberRequired" for number fields) to each control on your form that you want to have validated. 3. From an event (Button Click, OnSave etc) call the fnValidateForm by passing the form object. Example...
  9. Travis

    DLookup Help

    Place this in the Current Event of the Form. That way everytime you switch records it runs.
  10. Travis

    DLookup Help

    'Using the Formst Recordset check the value of the previous record Dim rst As Object Set rst = Me.RecordsetClone 'Places the recordset clone on the current record rst.Bookmark = Me.Recordset.Bookmark rst.MovePrevious If rst.BOF then 'Trap for not having a previous record Else...
  11. Travis

    Continuous Forms Loop

    Using ADODB and the Forms Recordsetclone Dim rst As Object Set rst = Me.RecordsetClone Do While Not rst.EOF 'Check Field rst.Fields("{FieldName}").Value rst.MoveNext Loop Set rst = Nothing
  12. Travis

    Int and Fix problem

    I ran tests and it seems that the fix line is using some mathimatical presidence. You can fix this issue by changing your code as follows: This will force the Amount * 100 calc prior to the Fix Function MakeAmount(Amount As Double) As String Dim x As String x = (Amount * 100) x =...
  13. Travis

    ADO Connection Error

    You are not getting an error, because an Error did not occur. This issue is that the Provider you choose does not have those properties therefore the connection variable cannot display them. However, the question really comes down to what comes after the connection. Do you get data? You are...
  14. Travis

    Getting the value for the next field

    For a single Field such as in your case you can use DLookUp to return the Level and populate a variable. From There you can use the varable to determine you settings. For more then one I would use a recordset. This reduces the # of calls to the backend data.
  15. Travis

    Automating Outlook Task

    MS Knowledge base
Top Bottom